mysql settings - using the available resources
Posted
by Christian Payne
on Server Fault
See other posts from Server Fault
or by Christian Payne
Published on 2010-04-22T23:39:48Z
Indexed on
2010/04/22
23:43 UTC
Read the original article
Hit count: 484
I've got a lot of processing work I need to run on a mysql server.
I've installed mysql 5.1.45-community on a Win 2007 64bit.
Its running on a xenon, 3ghz 6 processors with 8 gig ram.
It doesn't seem to matter what queries I run (or the number I run at the same time), when I look in task manager, I'll see one processor is out at 100%. The other 5 are idol. Memory is static at 1.54 gig.
When I installed mysql, I used the wizard and selected the default "server" (not workstation) option.
I feel like I should be getting more bang for my buck. Is there something else I should be monitoring or something I should change to use the other system resources???
© Server Fault or respective owner