[client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] log-slow-queries = /var/log/longquery skip-name-resolve datadir=/var/lib/mysql port = 3306 socket=/var/lib/mysql/mysql.sock safe-show-database old_passwords back_log = 75 max_connections = 500 thread_concurrency = 8 key_buffer = 64M long_query_time = 10 myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 3600 open_files_limit = 7200 thread_cache_size = 384 wait_timeout = 60 interactive_timeout = 60 connect_timeout = 10 tmp_table_size = 80M max_heap_table_size = 64M max_allowed_packet = 64M max_connect_errors = 10 read_rnd_buffer_size = 524288 bulk_insert_buffer_size = 8M query_cache_limit = 5M query_cache_size = 80M query_cache_type = 1 query_prealloc_size = 163840 query_alloc_block_size = 32768 default-storage-engine = MyISAM [mysql.server] user=mysql basedir=/var/lib old-passwords = 1 [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M [mysqlhotcopy] interactive-timeout