Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT SEQ,STATE,DURATION,SOURCE_FUNCTION FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=4;
- +-----+----------------------+------------+---------------------------+
- | SEQ | STATE | DURATION | SOURCE_FUNCTION |
- +-----+----------------------+------------+---------------------------+
- | 2 | starting | 0.000148 | NULL |
- | 3 | checking permissions | 0.000003 | check_access |
- | 4 | checking permissions | 0.000001 | check_access |
- | 5 | checking permissions | 0.000001 | check_access |
- | 6 | checking permissions | 0.000003 | check_access |
- | 7 | checking permissions | 0.000002 | check_access |
- | 8 | checking permissions | 0.000003 | check_access |
- | 9 | Opening tables | 0.000160 | open_tables |
- | 10 | init | 0.000076 | handle_query |
- | 11 | System lock | 0.000009 | mysql_lock_tables |
- | 12 | optimizing | 0.000019 | optimize |
- | 13 | statistics | 0.000631 | optimize |
- | 14 | preparing | 0.000048 | optimize |
- | 15 | Creating tmp table | 0.000050 | create_intermediate_table |
- | 16 | Sorting result | 0.000006 | make_tmp_tables_info |
- | 17 | executing | 0.000001 | exec |
- | 18 | Sending data | 826.993521 | exec |
- | 19 | Creating sort index | 0.050288 | sort_table |
- | 20 | end | 0.000017 | handle_query |
- | 21 | query end | 0.000132 | mysql_execute_command |
- | 22 | removing tmp table | 0.000138 | free_tmp_table |
- | 23 | query end | 0.000011 | free_tmp_table |
- | 24 | removing tmp table | 0.000163 | free_tmp_table |
- | 25 | query end | 0.000004 | free_tmp_table |
- | 26 | closing tables | 0.000017 | mysql_execute_command |
- | 27 | freeing items | 0.000045 | mysql_parse |
- | 28 | logging slow query | 0.000002 | log_slow_do |
- | 29 | logging slow query | 0.000131 | log_slow_do |
- | 30 | cleaning up | 0.000067 | dispatch_command |
- +-----+----------------------+------------+---------------------------+
- 29 rows in set, 1 warning (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment