mysql执行查询的时间记录及查看

1
2
3
4
5
6
7
8
9
mysql> show variables like "%profiling%";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| have_profiling         | YES   |
| profiling              | OFF   |
| profiling_history_size | 15    |
+------------------------+-------+
3 rows in set

1
2
mysql> set profiling = 1;
Query OK, 0 rows affected

1
2
3
4
5
6
7
8
9
10
11
12
13
mysql> show profiles;
+----------+------------+-------------------------------------------------------+
| Query_ID | Duration   | Query                                                 |
+----------+------------+-------------------------------------------------------+
|       22 | 0.01073875 | select sum(bill_count) from flink_merchant_stat_day   |
|       23 |  0.0001045 | show variables like profiling                         |
|       24 |  0.0001215 | show variables like profiling*                        |
|       25 | 0.00016975 | show variables = profiling                            |
|       26 | 0.00011025 | show variables profiling                              |
|       27 |    0.00012 | show variable profiling                               |
|       28 | 0.00270125 | show variables like "%profiling%"                     |
+----------+------------+-------------------------------------------------------+

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
mysql> show profile for query 22;
+----------------------+----------+
| Status               | Duration |
+----------------------+----------+
| starting             | 6.9E-5   |
| checking permissions | 1.3E-5   |
| Opening tables       | 2.3E-5   |
| init                 | 2.5E-5   |
| System lock          | 1.5E-5   |
| optimizing           | 1.1E-5   |
| statistics           | 2.8E-5   |
| preparing            | 2.8E-5   |
| executing            | 8E-6     |
| Sending data         | 0.01043  |
| end                  | 1.4E-5   |
| query end            | 1.4E-5   |
| closing tables       | 1.2E-5   |
| freeing items        | 3.4E-5   |
| cleaning up          | 1.9E-5   |
+----------------------+----------+
15 rows in set

1
2
mysql> set profiling = 0;
Query OK, 0 rows affected