etc/my.cnf000064400000001640151776411400006443 0ustar00[mysqld]
long_query_time = 3
slow_query_log_file = /var/lib/mysql/mysql-slow-query.log
max_connections = 500
default-storage-engine = MyISAM
innodb_file_per_table = 1
local-infile = 0
max_allowed_packet = 1073741824
tmpdir = /tmp/.mysql/
log_error = /var/lib/mysql/mysqld-err.log
innodb_buffer_pool_size = 1G
innodb_open_files = 10000
query_cache_limit = 32768
query_cache_min_res_unit = 2048
thread_cache_size = 50
innodb_write_io_threads = 8
innodb_read_io_threads = 8
sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
innodb_log_file_size = 128M
max_user_connections = 50
innodb_flush_method = fsync
innodb_flush_log_at_trx_commit = 1
slow_query_log = 1
query_cache_type = 0
query_cache_size = 0
table_open_cache = 30000
open_files_limit = 500000
table_definition_cache = 30000

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