kieranbarnes Independent PHP, WordPress & CubeCart Programmer

[mysqld] skip-innodb

[mysqld]
max_connections = 200
bind-address = 127.0.0.1
 
safe-show-database
skip-locking
skip-innodb
 
# MySQL 4.x has query caching available.
# Enable it for vast improvement and it may be all you need to tweak.
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
 
interactive_timeout=100
 
# Reduced wait_timeout to prevent idle clients holding connections.
wait_timeout=15
connect_timeout=10
 
# Checked opened tables and adjusted accordingly after running for a while.
table_cache=512
 
# Reduced it to 32 to prevent memory hogging.
thread_cache=32
 
# Reduced it by checking current size of *.MYI files.
key_buffer=128M
 
thread_concurrency=1
 
log_error                = /var/log/mysql/error.log
 
# log slow queries is a must.
log_slow_queries=/var/log/mysqld.slow.log
long_query_time=2
 
[mysqldump]
quick
max_allowed_packet=16M
 
[mysql]
no-auto-rehash
 
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
 
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
 
[mysqlhotcopy]
interactive-timeout