[CentOS] mysql 5 for centos 5.2

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

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)