[CentOS] mysql 5 for centos 5.2

[John R Pierce]

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