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)