On Tue, Oct 14, 2008 at 12:29 PM, John R Pierce pierce@hogranch.com wrote:
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
oh ok got it. But as i can see that with my database server it only eats up 1 core of my core2quad processor. how can i optimize mysql to use all 4 core of my processor?
thanks again for the answers