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 | 1999060413000 | 2001426151000 | 2365738000 | 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 | |
8294 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 532429577812000 | 532429717038000 | 139226000 | 46000000 | 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 | 126965 | |
8295 | 26 | 27 | statement/sql/show_fields | init_net_server_extension.cc:95 | 532474577455000 | 532475467530000 | 890075000 | 323000000 | 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 | 38 | 193 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 38 | 1 | 0 | 0 | NULL | NULL | 0 | 126982 | |
8296 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 532510206470000 | 532510263654000 | 57184000 | 19000000 | 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 | 126989 | |
8297 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 532511304597000 | 532511356764000 | 52167000 | 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 | 126993 | |
8298 | 22 | 23 | statement/sql/show_keys | init_net_server_extension.cc:95 | 532553727729000 | 532554578605000 | 850876000 | 478000000 | SHOW INDEXES FROM `performance_schema`.`table_lock... | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 3 | 17 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 1 | 0 | 0 | NULL | NULL | 0 | 127021 | |
8299 | 9 | 9 | statement/sql/show_variables | init_net_server_extension.cc:95 | 532546625419000 | 532553586893000 | 6961474000 | 538000000 | SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | SHOW SESSION VARIABLES LIKE ? | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 574 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 | 127009 | |
8300 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 532523659885000 | 532523699696000 | 39811000 | 15000000 | 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 | 126999 | |
8301 | 10 | NULL | statement/sql/select | init_net_server_extension.cc:95 | 532554591255000 | 532554766711000 | 175456000 | 47000000 | 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 | 127022 |
|