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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16515 | 20 | NULL | statement/sql/select | init_net_server_extension.cc:95 | 852941113629000 | 852941233272000 | 119643000 | 0 | SELECT (COUNT(DB_first_level) DIV 100) * 100 from ... | e8b67e76bb58f62c704e6904b349719537675fef0a968c067b... | SELECT ( COUNT ( `DB_first_level` ) DIV ? ) * ? FR... | 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 | 245897 | |
16516 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 852889965565000 | 852890012452000 | 46887000 | 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 | 245881 | |
16517 | 10 | NULL | statement/sql/select | init_net_server_extension.cc:95 | 852941114481000 | 852941262390000 | 147909000 | 79000000 | 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 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 | 245898 | |
29 | 1 | 1 | statement/sql/select | srv_session.cc:1107 | 1548896892000 | 1549995253000 | 1098361000 | 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 | |
16510 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 852701724731000 | 852701797394000 | 72663000 | 45000000 | 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 | 245798 | |
16511 | 31 | 32 | statement/sql/select | init_net_server_extension.cc:95 | 852937494090000 | 852938443769000 | 949679000 | 310000000 | SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 38 | 191 | 0 | 3 | 1 | 0 | 0 | 0 | 3 | 0 | 0 | 76 | 2 | 1 | 0 | NULL | NULL | 0 | 245893 | |
16514 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 852827546959000 | 852827600011000 | 53052000 | 18000000 | 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 | 245860 |
|