[mysqld] query_cache_limit=8M query_cache_size=64M query_cache_type=1 max_connections=900 interactive_timeout=60 wait_timeout=90 connect_timeout=30 thread_cache_size=256 key_buffer=32M join_buffer=2M max_allowed_packet=32M table_cache=4096 record_buffer=2M sort_buffer_size=2M read_buffer_size=2M read_rnd_buffer_size = 4M max_connect_errors=90 myisam_sort_buffer_size=64M #log-bin thread_concurrency = 4 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [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 # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /var/db/mysql/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /var/db/mysql/innodblogs/ innodb_log_arch_dir = /var/db/mysql/innodblogsarchive/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 32M innodb_additional_mem_pool_size = 10M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 24M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50