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 Jon L. Miller, ASE, CNS, CLS, MCNE Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au "I don't know the key to success, but the key to failure is trying to please everybody." -Bill Cosby
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD> <BODY style="MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px"> <DIV>We have MySQL and MySQL-MAX on a RH8 release. The server specs is as follows:</DIV> <DIV>Dual Xeon CPU 2.8GHz</DIV> <DIV>2G DDR Memory</DIV> <DIV>215GB HDD storage SCSI U160 HDD</DIV> <DIV> </DIV> <DIV>When a report (large one) runs I've noticed the following through tops.</DIV> <DIV>mysqld-max = 97.2 - 99.9 %CPU with 1.2% memory usage</DIV> <DIV>In the top of tops I've noticed that all 4 CPU (CPU0-CPU3) never gets over 50% for more than 2-3 seconds.</DIV> <DIV> </DIV> <DIV>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.</DIV> <DIV>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?</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Thanks</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Jon L. Miller, ASE, CNS, CLS, MCNE<BR>Director/Sr Systems Consultant<BR>MMT Networks Pty Ltd<BR><A href="http://www.mmtnetworks.com.au">http://www.mmtnetworks.com.au</A></DIV> <DIV> </DIV> <DIV>"I don't know the key to success, but the key to failure<BR> is trying to please everybody." -Bill Cosby</DIV> <DIV> </DIV> <DIV> </DIV></BODY></HTML>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]