Percona Server 高可用与调优指南
# 查询事物隔离级别 SHOW VARIABLES LIKE 'transaction%'; SELECT @@GLOBAL.transaction_isolation,@@transaction_isolation; # 修改全局隔离级别为读提交 SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED # 修改会话隔离级别 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; # 可选参数有:READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE. [mysqld] transaction-isolation=READ-COMMITTED
# Percona Server template configuration # Percona 8.0.15 参数调优(https://support.huaweicloud.com/tngg-kunpengdbs/kunpengpercona_05_0015.html) # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html [mysqld] # 启用线程池 (https://www.percona.com/doc/percona-server/8.0/performance/threadpool.html) thread_handling=pool-of-threads ssl=0 #关闭ssl max_connections=1000 #设置最大连接数 back_log=2048 #设置会话请求缓存个数 performance_schema=OFF #关闭性能模式,非生产环境,测试极限性能设置为OFF。 max_prepared_stmt_count=128000 lock_wait_timeout=60 #buffers innodb_buffer_pool_size=1G #设置buffer pool size,一般为服务器内存60% innodb_buffer_pool_instances=16 #设置buffer pool instance个数,提高并发能力 innodb_log_buffer_size=200M #设置log buffer size大小 innodb_lock_wait_timeout=120 # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove the leading "# " to disable binary logging # Binary logging captures changes between backups and is enabled by # default. It's default setting is log_bin=binlog # disable_log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M # # Remove leading # to revert to previous value for default_authentication_plugin, # this will increase compatibility with older clients. For background, see: # https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin # default-authentication-plugin=mysql_native_password
REFER :
https://www.percona.com/downloads/
https://github.com/sysown/proxysql
MySQL 最优配置文件模板
https://github.com/jdaaaaaavid/mysql_best_configuration
Percona 8.0.15 调优指南(鲲鹏920 for CentOS 7.6)
https://support.huaweicloud.com/tngg-kunpengdbs/kunpengpercona_05_0015.html
Percona XtraDB Cluster 8.0 与 Proxysql 史上最详尽用法指南
https://segmentfault.com/a/1190000037760128
互联网项目中mysql应该选什么事务隔离级别
https://www.cnblogs.com/rjzheng/p/10510174.html
仅此一文让你明白事务隔离级别、脏读、不可重复读、幻读
https://www.cnblogs.com/yubaolee/p/10398633.html
新说Mysql事务隔离级别
https://www.cnblogs.com/rjzheng/p/9955395.html
彻底搞懂 MySQL 事务的隔离级别
https://developer.aliyun.com/article/743691
事务隔离级别中的可重复读能防幻读吗?
https://www.cnblogs.com/CoderAyu/p/11525408.html