I've changed settings to:
innodb_data_file_path = ibdata1:128M:autoextend innodb_buffer_pool_size=150M innodb_additional_mem_pool_size = 50M
and system load is "only" 2 to 3.
kernel napisał(a):
What does the cpu % show when the machine has the high load avg ?
Now, there are about 50% of normal load and system load is "only" circa 1.0. On myisam there was about 0.5. And here comes few lines from top:
Cpu(s): 19.9% us, 2.6% sy, 0.0% ni, 74.8% id, 2.3% wa, 0.0% hi, 0.3% si
Cpu(s): 14.3% us, 1.0% sy, 0.0% ni, 82.4% id, 2.0% wa, 0.0% hi, 0.3% si
Cpu(s): 26.9% us, 3.3% sy, 0.0% ni, 69.4% id, 0.0% wa, 0.0% hi, 0.3% si
Usually high load avgs point to disk I/O isssues. What is the size of your ibdata1 file ? If you have more ram, you can increase
I've got 512 mb of RAM, and it's full (and 200mb of swap is currently used).
server root # ls -l /data/mysql/ib* -rw-rw---- 1 mysql mysql 5242880 Apr 12 23:14 /data/mysql/ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Apr 12 18:48 /data/mysql/ib_logfile1 -rw-rw---- 1 mysql mysql 1000341504 Apr 12 23:14 /data/mysql/ibdata1
innodb_buffer_pool_size or do some tweaks to the OS so it caches the disk a little more.
-- Marcin Lewandowski [ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ] [ http://www.nosoftwarepatents.com/pl/m/intro/index.html ]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]