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 <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
