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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29 | 1 | 1 | statement/sql/select | srv_session.cc:1107 | 1514704737000 | 1515896216000 | 1191479000 | 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 | |
270 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 16330544514000 | 16330602064000 | 57550000 | 20000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1049 | 42000 | Unknown database 'phpmyadmin' | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 3376 | |
271 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 16321435091000 | 16321479260000 | 44169000 | 16000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1049 | 42000 | Unknown database 'phpmyadmin' | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 3369 | |
272 | 31 | 32 | statement/sql/select | init_net_server_extension.cc:95 | 16371639265000 | 16372526599000 | 887334000 | 643000000 | SELECT DISTINCT `PARTITION_NAME` FROM `information... | 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | superpos | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 3414 | |
273 | 18 | 19 | statement/sql/show_keys | init_net_server_extension.cc:95 | 16382178480000 | 16384794456000 | 2615976000 | 2208000000 | SHOW INDEXES FROM `mysql`.`user` | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 2 | 66 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 1 | 0 | 0 | NULL | NULL | 0 | 3431 | |
274 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 16346150617000 | 16346198381000 | 47764000 | 17000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1049 | 42000 | Unknown database 'phpmyadmin' | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 3401 | |
277 | 18 | NULL | statement/sql/show_keys | init_net_server_extension.cc:95 | 16384810174000 | 16385553744000 | 743570000 | 598000000 | SHOW INDEXES FROM `mysql`.`user` | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 3438 | |
278 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 16351497401000 | 16351561529000 | 64128000 | 23000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1049 | 42000 | Unknown database 'phpmyadmin' | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 3411 | |
279 | 10 | NULL | statement/sql/select | init_net_server_extension.cc:95 | 16385331152000 | 16385573881000 | 242729000 | 106000000 | 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 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 | 3439 |
|