Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Making connection accept faster
+4 Vote Up -0 Vote Down

Domas documented a few things we needed to fix to make MySQL faster at accepting connections. Someone new to the team, Yongqiang He, spent a few weeks implementing some of the suggestions and the results are great. The tests used one 24-core host for the clients and another for mysqld. The clients were split across 8 sysbench processes and used sysbench modified to only do connections. The tests were run in two configurations with thread_cache_size=2000 and then with thread_cache_size=0.

 

Results with thread_cache_size=2000

 

 

Results with thread_cache_size=0

 

Votes:

You must be logged in with a MySQL account to vote on Planet MySQL entries. More information on PlanetMySQL voting.

Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.