Re: InnoDB Performance

[Gleb Paharenko]

Hello.

Send the piece of 'SHOW PROCESSLIST', 'SHOW STATUS' output and
corresponding configuration file (after applying all previous advices). 
It could provide more information to reflection.


Marcin Lewandowski <lists@stripped> 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
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com