[CentOS] mysql 5 for centos 5.2
John R Pierce
pierce at hogranch.com
Tue Oct 14 04:29:41 UTC 2008
Mark Quitoriano wrote:
> What do you recommend me to do so i can optimize my database on a
> multi-core processor? and i haven't got an answer for the mysql
> package for centos 5 is the multi-threading supported?
each connection to mysql spawns a thread, however under various
conditions the threads can block each other, including if they are
stacking up on table locks to update the same table.
otherwise, yes, mysql is fully multithreaded, as long as you're making
multiple queries concurrently via different connections
More information about the CentOS