备份帖：MariaDB5.5.60优化配置_美国VPS

hz 32G内存 G口 Intel Core i7-4770 MariaDB5.5.60优化配置

2019/07/26 再次更新配置

[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
log-queries-not-using-indexes
log-slow-admin-statements
log-slow-slave-statements
symbolic-links = 0
character-set-server = utf8mb4
interactive_timeout = 31536000
wait_timeout = 31536000
max_allowed_packet = 64M
max_connections = 100000
max_connect_errors = 1000000
thread_cache_size = 512
max_user_connections = 99999
slow_query_log = ON
long_query_time = 1
table_cache = 614
table_open_cache = 10240
thread_concurrency = 32
query_cache_type = 1
query_cache_size = 32M
query_cache_limit = 2M
key_buffer_size = 5120M
sort_buffer_size = 10M
join_buffer_size = 1M
read_buffer_size = 8M
read_rnd_buffer_size = 32M
thread_stack = 512K
bulk_insert_buffer_size = 8M
min_examined_row_limit = 5
query_cache_min_res_unit = 2k
innodb_log_buffer_size = 8.388608e+06
innodb_thread_concurrency = 1
innodb_buffer_pool_size = 8342177280
slow_query_log_file = /var/log/mariadb/slow.log
log_bin = OFF
server_id = 1
open_files_limit = 10000
[mysqld_safe]
log-error = /var/log/mariadb/mariadb.log
pid-file = /var/run/mariadb/mariadb.pid
# include all files from the config directory
!includedir /etc/my.cnf.d
# 慢查询相关参数
[client]
socket = /var/lib/mysql/mysql.sock

复制代码

上海网友:感谢楼主的分享
内蒙古网友:踩坑无数,含辛茹苦啊~.~
河北网友:这个参数是给什么配置的主机用的？占用内存大概多少？
海南网友:hz 32G内存 G口 Intel Core i7-4770 MariaDB5.5.60优化配置
江苏网友:啊哈哈哈，大佬打扰了~
这面没有用过这么高配置的机器呢。

天津网友:这配置我最少上MariaDB10.4
江西网友:楼主，为什么不用mysql？
河南网友:30G的数据量升级好麻烦
河南网友:python+mariadb 都是sh脚本一键安装啊也一样的。
上海网友:2019/07/26 再次更新配置