mysql settings - using the available resources
- by Christian Payne
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???