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:
thread_concurrency=n
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 http://tools.assembla.com/svn/mysqltuner/mysqltuner.pl)

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: