文章目录
MySQL 性能优化
1. 查询执行计划
mysql> explain SQL_statement;
mysql> show warnings;
mysql> explain select 1 from dual;
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+----------------+
| id
mysql> explain SQL_statement;
mysql> show warnings;
mysql> explain select 1 from dual;
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+----------------+
| id