mysqld_safe] err-log = /var/log/mysql/mysql.err nice = -5 open_files_limit = 8192 [mysqld] user = mysql port = 3306 socket = /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld.pid log-error = /var/log/mysql/mysqld.err basedir = /usr datadir = /var/lib/mysql skip-locking key_buffer = 256M thread_cache_size = 400 wait_timeout = 10 interactive_timeout = 150 connect_timeout = 60 tmp_table_size = 164M max_heap_table_size = 84M max_allowed_packet = 64M table_cache = 3200 sort_buffer_size = 2M join_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 128K max_connect_errors = 2 read_rnd_buffer_size = 2M myisam_sort_buffer_size = 64M back_log = 150 safe-show-database max_connections = 500 bulk_insert_buffer_size = 6M query_cache_limit = 4M query_cache_size = 1024M query_cache_type = 1 query_prealloc_size = 81920 query_alloc_block_size = 163840 default-storage-engine = MyISAM log-slow-queries=/var/db/mysql/slow.log long_query_time=5 skip-name-resolve skip-host-cache thread_concurrency = 16 language = /usr/share/mysql/english bind-address = 0.0.0.0 expire_logs_days = 2 server-id = 1 tmpdir = /tmp/ innodb_buffer_pool_size = 4096M innodb_additional_mem_pool_size = 2048M innodb_flush_method=O_DIRECT innodb_data_file_path = innodbtable1:10M:autoextend:max:24096M innodb_log_file_size = 1024M innodb_log_buffer_size = 128M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 innodb_file_per_table