本文介绍了TRACE语句的用法。

TRACE语句用于查看具体SQL的执行情况。TRACE [SQL]和SHOW TRACE要结合使用。

说明 TRACE SQL和EXPLAIN SQL的区别在于TRACE SQL会实际执行该语句。

示例

查看select 1这条语句的执行情况。

mysql> trace select 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.03 sec)

mysql> show trace;
+------+----------+----------------+-----------------------------------+---------------+--------------------------+------+-----------+--------+
| ID   | TYPE     | GROUP_NAME     | DBKEY_NAME                        | TIME_COST(MS) | CONNECTION_TIME_COST(MS) | ROWS | STATEMENT | PARAMS |
+------+----------+----------------+-----------------------------------+---------------+--------------------------+------+-----------+--------+
|    0 | Optimize | DRDS           | DRDS                              | 3             | 0.00                     |    0 | select 1  | NULL   |
|    1 | Query    | TDDL5_00_GROUP | db218249098_sqa_zmf_tddl5_00_3309 | 7             | 0.15                     |    1 | select 1  | NULL   |
+------+----------+----------------+-----------------------------------+---------------+--------------------------+------+-----------+--------+
2 rows in set (0.01 sec)