14 Oct
2008
14 Oct
'08
6:29 a.m.
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