mysql-优化班学习-2-20170510
percona版本的便利:
thread pool 【群主】叶金荣(4700963) 20:36:38 extra port
把log_slow_verbosity 设置为0 立即所有都会记录slow_log, 会增加很多信息:
如下所示:
突破了
-----------------------------------------------------------------------------------------------------------------
【群主】叶金荣(4700963) 20:55:18 https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-features/ 【群主】叶金荣(4700963) 20:57:57 MariaDB 5.3 vs MySQL 5.5/5.6 查询优化器优势对比,https://mariadb.com/kb/en/mariadb/optimizer-feature-comparison-matrix/ 【群主】叶金荣(4700963) 20:58:13 MariaDB 5.3 vs MySQL 5.5/5.6 性能对比,https://mariadb.com/resources/blog/mariadb-53-optimizer-benchmark
zabbix的数据库推荐使用mariadb的并行复制功能,不会出现延迟,基于schema的并行复制
infinidb = columnstore
越到右边性能越差
WB、WT 【吐槽】A561-陈星宇-上海(280186925) 22:14:58 http://baike.baidu.com/link?url=VoCmpFXmOwdDUcwnR6EbQlMwXfGytrdAHd7XnH-cf_VbK35GaPDWqKSFQNW_q9vNDmHCnge83OSEt4qWoYo1xcl8u0g1qXFIG0TFYiNl2AIg5o7xRLz63ObLTJOMQ89_ci3BJfjE9qZwmMAICxHkFw5l74QXriNiJbK7pDdLRdi
每个表一定要有主键! 每个表一定要有主键! 每个表一定要有主键!