SET profiling = 1;
|
USE test;
|
DROP TABLE IF EXISTS t1;
|
CREATE TABLE T1 (id INT);
|
SHOW PROFILES;
|
+----------+------------+--------------------------+
|
| Query_ID | Duration | Query |
|
+----------+------------+--------------------------+
|
| 1 | 0.00009200 | SELECT DATABASE() |
|
| 2 | 0.00023800 | show databases |
|
| 3 | 0.00018900 | show tables |
|
| 4 | 0.00014700 | DROP TABLE IF EXISTS t1 |
|
| 5 | 0.24476900 | CREATE TABLE T1 (id INT) |
|
+----------+------------+--------------------------+
|
|
SHOW PROFILE;
|
+----------------------+----------+
|
| Status | Duration |
|
+----------------------+----------+
|
| starting | 0.000042 |
|
| checking permissions | 0.000044 |
|
| creating table | 0.244645 |
|
| After create | 0.000013 |
|
| query end | 0.000003 |
|
| freeing items | 0.000016 |
|
| logging slow query | 0.000003 |
|
| cleaning up | 0.000003 |
|
+----------------------+----------+
|
|
SHOW PROFILE CPU FOR QUERY 5;
|
+----------------------+----------+----------+------------+
|
| Status | Duration | CPU_user | CPU_system |
|
+----------------------+----------+----------+------------+
|
| starting | 0.000042 | 0.000000 | 0.000000 |
|
| checking permissions | 0.000044 | 0.000000 | 0.000000 |
|
| creating table | 0.244645 | 0.000000 | 0.000000 |
|
| After create | 0.000013 | 0.000000 | 0.000000 |
|
| query end | 0.000003 | 0.000000 | 0.000000 |
|
| freeing items | 0.000016 | 0.000000 | 0.000000 |
|
| logging slow query | 0.000003 | 0.000000 | 0.000000 |
|
| cleaning up | 0.000003 | 0.000000 | 0.000000 |
|
+----------------------+----------+----------+------------+
|
|