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

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

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 not