The MyIsam storage engine is a non transactional engine and InnoDb is a
transactional engine. That is the main difference. So I think the MyIsam
engine should be faster.
Try to adjust the "innodb_thread_concurrency" parameter when you have a
lot of users.
Reto
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
>
