SELECT * FROM `events_statements_current`
|
THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | LOCK_TIME | SQL_TEXT | DIGEST | DIGEST_TEXT | CURRENT_SCHEMA | OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | OBJECT_INSTANCE_BEGIN | MYSQL_ERRNO | RETURNED_SQLSTATE | MESSAGE_TEXT | ERRORS | WARNINGS | ROWS_AFFECTED | ROWS_SENT | ROWS_EXAMINED | CREATED_TMP_DISK_TABLES | CREATED_TMP_TABLES | SELECT_FULL_JOIN | SELECT_FULL_RANGE_JOIN | SELECT_RANGE | SELECT_RANGE_CHECK | SELECT_SCAN | SORT_MERGE_PASSES | SORT_RANGE | SORT_ROWS | SORT_SCAN | NO_INDEX_USED | NO_GOOD_INDEX_USED | NESTING_EVENT_ID | NESTING_EVENT_TYPE | NESTING_EVENT_LEVEL | STATEMENT_ID | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 1 | 1 | statement/sql/select | srv_session.cc:1107 | 1489354442000 | 1490519270000 | 1164828000 | 0 | SELECT @@skip_networking, @@skip_name_resolve, @@h... | 1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39... | SELECT @@`skip_networking` , @@`skip_name_resolve`... | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 2 | |
19300 | 138 | 139 | statement/sql/select | init_net_server_extension.cc:95 | 1074328674715000 | 1074328765200000 | 90485000 | 36000000 | /*NOTRACK*/ SELECT 1 FROM `phpmyadmin`.`pma__track... | 603da55acfc576f0f0ddb63f3abfb2b341607f72dfe9c3a956... | SELECT ? FROM `phpmyadmin` . `pma__tracking` WHERE... | phpmyadmin | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 685141 | |
19301 | 25 | 26 | statement/sql/show_fields | init_net_server_extension.cc:95 | 1074235821611000 | 1074236891306000 | 1069695000 | 310000000 | SHOW FULL COLUMNS FROM `performance_schema`.`table... | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 68 | 343 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 68 | 1 | 0 | 0 | NULL | NULL | 0 | 685053 | |
19302 | 142 | NULL | statement/abstract/Query | init_net_server_extension.cc:95 | 1074338744204000 | 1074338762222000 | 18018000 | 0 | NULL | NULL | NULL | phpmyadmin | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 685158 | |
19303 | 36 | 36 | statement/sql/show_grants | init_net_server_extension.cc:95 | 1074338599125000 | 1074338695351000 | 96226000 | 0 | SHOW GRANTS | 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... | SHOW GRANTS | mysql | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 685156 | |
19304 | 68 | 69 | statement/sql/select | init_net_server_extension.cc:95 | 1074338297339000 | 1074338406417000 | 109078000 | 38000000 | /*NOTRACK*/ SELECT 1 FROM `phpmyadmin`.`pma__track... | 603da55acfc576f0f0ddb63f3abfb2b341607f72dfe9c3a956... | SELECT ? FROM `phpmyadmin` . `pma__tracking` WHERE... | phpmyadmin | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 685155 | |
19305 | 10 | NULL | statement/sql/select | init_net_server_extension.cc:95 | 1074338615092000 | 1074338777547000 | 162455000 | 52000000 | SELECT * FROM `events_statements_current` LIMIT 0,... | 48a66f51b70d4dbcfae28baea5e7e549cd3303a632540a0923... | SELECT * FROM `events_statements_current` LIMIT ?,... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 | 685157 | |
19092 | 48 | 48 | statement/com/Quit | init_net_server_extension.cc:95 | 1063346706650000 | 1063346710150000 | 3500000 | 0 | NULL | NULL | NULL | mysql | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 674471 | |
19093 | 154 | 154 | statement/com/Quit | init_net_server_extension.cc:95 | 1063346582913000 | 1063346586773000 | 3860000 | 0 | NULL | NULL | NULL | phpmyadmin | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 674470 |
|