15 Oct
2008
15 Oct
'08
6:54 p.m.
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)