Re: InnoDB Performance

[Marcin Lewandowski]

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:www@stripped  gg:188068 jid:saepia@stripped  ]
[   http://www.nosoftwarepatents.com/pl/m/intro/index.html   ]