我的MariaDB从服务器配置my.ini

[mysqld]
#key_buffer_size+(read_buffer_size+sort_buffer_size)*max_connections
#=384M+(2M+2M)*100=784M
port = 3306
skip-external-locking #跳过外部锁定
key_buffer_size = 384M #256M(内存1G) 400M(内存2G)
max_allowed_packet = 2M #2M(内存1G) 4M(内存2G)
table_open_cache = 64 #small=4,medium=64,large=256,huge=512
sort_buffer_size = 2M #2M(内存1G) 4M(内存2G) 8M(内存4G)
net_buffer_length = 512K
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M #64M(内存1G) 128M(内存2G)
thread_cache_size = 8 #8(内存1G) 64(内存2G)
query_cache_size = 32M #32M(内存1G) 64M(内存2G)
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
max_connections = 100 #允许的并行客户端连接数目。
wait_timeout = 60 #等待超时时间
connect_timeout = 3 #连接超时
interactive_timeout = 120 #活动连接超时
long_query_time = 1 #长查询时间
log-slow-queries = mysqlslowquery.log #记录慢查询
log_bin_trust_function_creators=1 log-bin
=mysql-bin binlog_format=mixed server-id = 20660 replicate-rewrite-db="96dt_radio->96dt_radio" replicate-do-db=96dt_radio
飞儿传媒www.firadio.com
原文地址:https://www.cnblogs.com/firadio/p/3513022.html