[mysqld]
slow-query-log = 1
long_query_time = 1
max_connections = 500
default-storage-engine = MyISAM
innodb_file_per_table = 1
local-infile = 0
max_allowed_packet = 1073741824
open_files_limit = 80000
tmpdir = /tmp/.mysql/
log_error = /var/lib/mysql/mysqld-err.log
slow_query_log_file = /var/lib/mysql/mysql-slow-query.log
innodb_buffer_pool_size = 1G
innodb_open_files = 10000
query_cache_size=1048576
query_cache_limit = 32768
query_cache_min_res_unit = 2048
thread_cache_size = 50
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_log_file_size = 128M
sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
max_user_connections = 50
query_cache_type=DEMAND

slow_query_log_file=/var/lib/mysql/mysql-slow-query.log
log_error=/var/lib/mysql/mysqld-err.log
max_user_connections=50
tmpdir=/tmp/.mysql/
innodb_flush_method = fsync
innodb_flush_log_at_trx_commit = 2