[client] port = 3306 default-character-set=utf8 [mysqld] character-set-server=utf8 collation_server=utf8_general_ci #skip-innodb innodb_file_per_table innodb_log_file_size=64M innodb_buffer_pool_size=64M #datadir=/www/mysql socket=/var/lib/mysql/mysql.sock #port = 3306 skip-external-locking #skip-networking skip-name-resolve max_allowed_packet = 4M table_open_cache = 128 tmp_table_size = 24M max_heap_table_size = 24M key_buffer_size = 384M sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 2M myisam_sort_buffer_size = 2M thread_cache_size = 8 query_cache_type = 1 query_cache_size = 16M max-connections = 32 #log-bin #log = /tmp/mysql-query.log #server-id = 1 #long-query-time=2 #slow-query-log=1 #slow-query-log-file=/tmp/slow-queries.log