mysql 优化

最新推荐文章于 2025-04-23 05:00:00 发布

原创最新推荐文章于 2025-04-23 05:00:00 发布 · 118 阅读

0 ·

CC 4.0 BY-SA版权

db 专栏收录该内容

31 篇文章

订阅专栏

本文深入解析MySQL配置文件中关键参数的设置，如InnoDB缓冲池大小、日志文件配置及连接数限制等，旨在提升数据库性能与稳定性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[mysqld]
innodb_buffer_pool_size = 2G
innodb_file_per_table = ON
innodb_log_buffer_size= 100M
innodb_log_file_size = 100M
innodb_data_file_path = ibdata1:1024M;ibdata2:1024M:autoextend
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_thread_concurrency = 12
innodb_flush_neighbors = 1
innodb_purge_threads = 4
innodb_large_prefix = 1
innodb_print_all_deadlocks = 1
innodb_strict_mode = 1
innodb_lock_wait_timeout = 5
skip_name_resolve = 1
skip_ssl = 1
lower_case_table_names = 1
#basedir = /opt/mysql
datadir = /ccdata/mysql/
port = 3306
socket = /var/lib/mysql/mysql.sock
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
key_buffer_size = 16M
max_connect_errors = 10000
max_connections = 3000
open_files_limit = 65535
log_error = /var/log/mysqld.log
#log_timestamps = SYSTEM
character-set-server = utf8
explicit_defaults_for_timestamp=true
log-bin=mysql-bin
binlog-format=ROW
[mysql]
default-character-set=utf8