[mysqld] myisam-recover=backup,force #innodb_force_recovery = 6 innodb_file_per_table innodb_buffer_pool_size = 1100M innodb_flush_method = O_DIRECT innodb_flush_log_at_trx_commit=1 sync_binlog=1 log-bin=mysql-bin server-id=6 #log-error = /var/log/mysql-errors.log log-output=file log-slow-queries = /var/log/mysql-slow.log auto_increment_increment=2 auto_increment_offset=1 skip-slave-start #slave_exec_mode = IDEMPOTENT datadir = /usr/local/mysql/data innodb_data_home_dir = /usr/local/mysql/data innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_log_files_in_group = 2 innodb_log_file_size = 5242880 #innodb_locks_unsafe_for_binlog=1 innodb_thread_concurrency=8 datetime_format = %Y%m%d%H%i%s delayed_insert_timeout = 3000 innodb_lock_wait_timeout = 500 interactive_timeout = 20 net_read_timeout = 300 net_write_timeout = 600 # Replication #master-host = host #master-user = user #master-password = pw #master-port = 3306 #skip-name-resolve #skip-innodb max_connections = 100 key_buffer = 200M key_buffer_size = 10M myisam_sort_buffer_size = 1M join_buffer_size = 64M read_buffer_size = 1M sort_buffer_size = 1M read_rnd_buffer_size = 768K table_cache = 200 thread_cache_size = 80 wait_timeout = 1000 connect_timeout = 100 tmp_table_size = 128M max_heap_table_size=128M max_tmp_tables=32 bulk_insert_buffer_size = 8M max_allowed_packet = 64M max_connect_errors = 500 query_cache_limit = 1M query_cache_size = 64M query_cache_type = 1 default-storage-engine = MyIsam [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 64M sort_buffer_size = 1M read_buffer = 16M write_buffer = 16M