mysql running on multiple cpus

A little post to write about a tip rarely documented:
Mysql doesn’t use multiple CPU with its default configuration. If you have several cpus on your mysql system use:
in your my.cnf, where n is number_of_core * 2 .
It doesn’t change much the performance because usually mysql is not short on cpu but rather short on ram or disk I/O, but it’s still a gain, it still can handle more concurrent request.
(For general mysql tunning I always recommend to use


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: