Re: InnoDB Performance

[kernel]

Marcin Lewandowski wrote:
Hi,
I've got webserver. There, I've got phpbb2 with circa 6000 users 
(average 70-100 users online). There was problems with locking or 
something else, when phpbb was using myisam tables. Yesterday, we have 
converted tables to innodb, because it should be more effective. Since 
then we have high system load.

server root # uptime
 16:11:17 up 1 day, 23:56,  4 users,  load average: 1.37, 1.35, 6.63
server root # free
             total       used       free     shared    buffers     cached
Mem:        508284     506732       1552          0       2800     322848
-/+ buffers/cache:     181084     327200
Swap:      1000400     128308     872092
MyTop shows that there are about 40-50 queries per second.
MySQL is 4.0.22-log (gentoo linux)
Here comes my.cnf:
[client]
port            = 4417
socket          = /var/run/mysqld/mysqld.sock
[safe_mysqld]
err-log         = /var/log/mysql/mysql.err
[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
log-error       = /var/log/mysql/mysqld.err
innodb_data_file_path = ibdata1:64M:autoextend
innodb_buffer_pool_size=128M
innodb_flush_log_at_trx_commit=1

basedir         = /usr
datadir         = /data/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/polish
log-slow-queries = /data/logs/mysql/slow.log
log-update      = /data/logs/mysql/update.log
skip-locking
skip-bdb
low-priority-updates
max_write_lock_count = 7
character-set   = latin2
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = thread_stack=128K
long_query_time = 4
wait-timeout    = 60
max-connections = 150
port            = 4417
[mysqldump]
quick
set-variable    = max_allowed_packet=1M
[mysql]
[isamchk]
set-variable    = key_buffer=16M
I've tried many values in innodb_data_file_path = ibdata1:64M:autoextend
Thanks in advance
Marcin,
What does the cpu % show when the machine has the high load avg ? 
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 
innodb_buffer_pool_size or do some tweaks to the OS so it  caches  the 
disk a little more.

walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]