压力测试工具
生产环境 my.cnf 配置案例
配置文件生成工具参考链接:https://imysql.com/my_cnf_generator
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
| innodb_file_per_table = 1
max_connections = 8000
open_files_limit = 10240
back_log = 300
max_connect_errors = 1000
max_allowed_packet = 32M
wait_timeout = 10
sort_buffer_size = 16M
join_buffer_size = 16M
query_cache_size = 128M
query_cache_limit = 4M
transaction_isolation = REPEATABLE-READ
连接时被预留. thread_stack = 512K
log-bin=/data/mysqlbinlogs/
binlog_format=row
innodb_buffer_pool_size = 24G
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_log_buffer_size = 16M
innodb_log_file_size = 512M
innodb_log_files_in_group = 3
innodb_lock_wait_timeout = 120
long_query_time = 2
log-queries-not-using-indexes
|
MySQL 配置最佳实践