qq_31315703的博客

https://dev.mysql.com/doc/refman/8.0/en/backup-types.html

修改配置[mysqld]下设置sql_mode通过查询SELECT @@sql_mode;去掉only_full_group_bysql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

优化概述优化SQL语句优化和索引优化数据库结构优化InnoDB表优化MyISAM表优化内存表了解查询执行计划控制查询优化器缓冲和缓存优化锁定操作优化MySQL服务器衡量效果（基准测试）检查服务器线程（进程）信息https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html...

https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html

mysql的view不支持子查询CREATE VIEW waits AS SELECT * FROM ( selectid,company_id,createtime,updatetime,status, 1 as name FROMfa_company_test where status in (‘试工中’,‘邀请中’, ‘试工完成’)UNION ALL SELECT id,company_id,createtime,updatetime,status, 2 as nameFROM fa_c