Making connection accept faster

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.

https://www.facebook.com/note.php?note_id=10150729290160933
http://dom.as/2011/08/28/mysql-connection-accept-speed/