[CentOS] mysql 5 for centos 5.2

John R Pierce pierce at hogranch.com
Wed Oct 15 16:54:42 UTC 2008


Mark Quitoriano wrote:
> 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?
>   

you said you had 50-100 simultaneous connections to mysql?   these are 
presumably issuing various queries at overlapping times?  I find it 
pretty hard to believe its only using one processor unless all these 
queries are updates to the same table, using full table locking (myISAM 
for instance)





More information about the CentOS mailing list