Re: reports slows down network
Jon Miller wrote: This is the configuration file in use. /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock port=3306 [mysql.server] user=root basedir=/var/lib [safe_mysqld] err-log = /var/log/mysqld.log pid-file= /var/run/mysqld/mysqld.pid log_slow_queries= /var/log/slow-queries.log long_query_time=2 max_allowed_packet = 384M table cache = 512 sort_buffer_size= 2M read_buffer_size= 2M myisam_sort_buffer_size = 64M thread_cache= 8 query_cache = 32M thread_concurrency = 16 innodb_buffer_pool_size = 384M innodb_additional_mem_pool_size = 20M Right. Firstly, don't top-post. It's annoying. Secondly, don't just post directly to people on the list. Post all stuff to the LIST. That way other people who have the same problem as you don't have to ask the same question. Your max_allowed_packet size is HUGE. Why is that big? Maybe that should be the key_buffer instead of the max_allowed_packet? Have a look at the example config files ( in support-files in the source distribution ). Have a look at the page I linked to in my last post, and also: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html They both talk about exactly what you want to do: tune the performance of your server. You also didn't include any details of the tables or queries you're running. I see you have a slow queries log, in /var/log/slow-queries.log. That would be a good one to look at too. Dan -- 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]
Re: reports slows down network
Jon Miller wrote: 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 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 ). 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]
reports slows down network
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 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, MCNEDirector/Sr Systems ConsultantMMT Networks Pty Ltdhttp://www.mmtnetworks.com.au";>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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]