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:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ] [ http://www.nosoftwarepatents.com/pl/m/intro/index.html ]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]