[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
disable-log-bin = 1
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
default-storage-engine = MyISAM
#skip-name-resolve
tmpdir = /dev/shm
sql_mode = ""
#innodb_file_per_table = 1
#innodb_buffer_pool_size = 8G
#innodb_log_file_size = 512M
#innodb_log_files_in_group = 2
# 64G RAM、共享主機：先給 12G（約 18%），視監控再調 8~16G
innodb_buffer_pool_size = 12G
# 每個 instance ~1G；>=8G 時使用 8 個區塊
innodb_buffer_pool_instances = 8
# redo log：每檔 512M、2 個（總 1G）通常足夠；維持即可
innodb_log_file_size = 512M
innodb_log_files_in_group = 2
# 降低雙重快取、穩定 I/O
innodb_flush_method = O_DIRECT
# 折衷耐用/效能（fsync 降低），若要求最嚴格一致性再改回 1
innodb_flush_log_at_trx_commit = 2
max_allowed_packet = 64M
local-infile = 0
max_user_connections = 20
max_connections = 200
interactive_timeout = 20
wait_timeout = 20
connect_timeout = 20
#key_buffer_size = 4096M
key_buffer_size = 128M
myisam_sort_buffer_size = 64M
table_open_cache = 20000
table_definition_cache = 40000
thread_cache_size = 512
join_buffer_size = 2M
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 512M
performance_schema = ON
performance_schema_digests_size=10000
open_files_limit = 200000
low_priority_updates = 1
event_scheduler = off
tmp_table_size = 384M
max_heap_table_size = 384M
#log_slow_query  = 1
slow_query_log = ON
slow-query_log_file = /var/log/mysql-slow.log
#log_slow_query_time = 8
long_query_time = 8
log_output = FILE
min_examined_row_limit = 1000
log_queries_not_using_indexes = OFF

[mysqld_safe]
open_files_limit = 200000

[mysqldump]
quick

[mysql]
no-auto-rehash

[isamchk]
key-buffer-size = 1024M
sort_buffer = 1024M
read_buffer = 256M
write_buffer = 256M