[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 mailing list