Jon Miller wrote:
I'm pretty sure that each individual query can only run on 1 CPU at once. If you have more than 1 query, each one *can* get allocated to a different CPU, but you're not going to get all CPUs running one thread ( query ).We have MySQL and MySQL-MAX on a RH8 release. The server specs is as follows: Dual Xeon CPU 2.8GHz 2G DDR Memory 215GB HDD storage SCSI U160 HDD
When a report (large one) runs I've noticed the following through tops. mysqld-max = 97.2 - 99.9 %CPU with 1.2% memory usage In the top of tops I've noticed that all 4 CPU (CPU0-CPU3) never gets over 50% for more than 2-3 seconds.
Can someone tell me why the reports makes the server run slower than expected and how can I set mysqld-max to make use of each CPU thus keep the CPU usage down. Is there a command I can run in mysql that can give me an accurate reading of how much cpu and memory is being used?
Thanks
As for why the query takes so long ... why is MySQL only using 1.2% of your memory?
Have a look at:
http://dev.mysql.com/doc/mysql/en/Server_parameters.html
If MySQL isn't using enough memory it will have to use the disk(s) a lot, which will slow things down a lot.
Without seeing any of your config files or queries, there's not much more to be said.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
