MySQL 自建配置

MySQL

字数统计: 92阅读时长: 1 min

 2022/11/27 

MySQL 自用优化配置

适用于4c8g 机器.

[mysqld]
sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
skip_ssl
ignore-db-dir=lost+found
datadir=/var/lib/mysql
socket=/tmp/mysql.sock
skip-host-cache
binlog_format=ROW
default_storage_engine=InnoDB
innodb_flush_log_at_trx_commit  = 0
innodb_flush_method             = O_DIRECT
innodb_file_per_table           = 1
innodb_thread_concurrency = 0
innodb_max_dirty_pages_pct = 75
innodb_autoinc_lock_mode=2
bind_address = 0.0.0.0
innodb_buffer_pool_size = 5G
character-set-server = utf8mb4
max_connections = 2048
max_connect_errors=50000
wait_timeout=7200
interactive_timeout = 7200
thread_cache_size = 256
table_open_cache = 2000 
max_allowed_packet = 256M
slow_query_log=1
long_query_time=0.2
log_output=FILE
log_error=/var/lib/mysql/mysql-error.log
slow_query_log_file=/var/lib/mysql/mysql-slow.log
log-queries-not-using-indexes = 0
sort_buffer_size=512k
read_rnd_buffer_size=512k
max_length_for_sort_data = 16k
join_buffer_size=512k
tmp_table_size = 2M
max_heap_table_size = 2M
query_cache_size=0
query_cache_type=OFF
innodb_lock_wait_timeout = 5
innodb_deadlock_detect=on
innodb_read_io_threads = 4
innodb_write_io_threads = 4

原文作者：0x0034

原文链接：https://0x0034.github.io/2022/11/27/MySQL-%E8%87%AA%E5%BB%BA%E9%85%8D%E7%BD%AE/

发表日期：November 27th 2022, 8:35:51 pm

更新日期：November 27th 2022, 8:35:51 pm

Next Post

xfs_repair 修复文件系统
Previous Post

ssh免密脚本

CATALOG

1. MySQL 自用优化配置