Re: reports slows down network

2004-08-24 Thread Daniel Kasak
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

2004-08-24 Thread Daniel Kasak
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

2004-08-24 Thread Jon Miller
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]