InnoDB Performance

[Marcin Lewandowski]

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