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 | 1993270838000 | 1996675505000 | 3404667000 | 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 | |
2454 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 125158004631000 | 125158047019000 | 42388000 | 14000000 | 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 | 39965 | |
2455 | 25 | 26 | statement/sql/show_fields | init_net_server_extension.cc:95 | 125808351623000 | 125810110619000 | 1758996000 | 521000000 | 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 | 40224 | |
2468 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 125774882269000 | 125774944128000 | 61859000 | 21000000 | 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 | 40197 | |
2469 | 10 | 10 | statement/sql/select | init_net_server_extension.cc:95 | 125796130282000 | 125796375610000 | 245328000 | 49000000 | SELECT * FROM `table_lock_waits_summary_by_table` ... | 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... | SELECT * FROM `table_lock_waits_summary_by_table` ... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 | 40214 | |
2470 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 125782704593000 | 125782770077000 | 65484000 | 24000000 | 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 | 40205 | |
2471 | 87 | 87 | statement/sql/select | init_net_server_extension.cc:95 | 125908633938000 | 125908730935000 | 96997000 | 42000000 | SELECT `COMMENT` FROM `information_schema`.`ENGINE... | 15da2ac5321783445612727df537cde176602ae2b426c30e53... | SELECT `COMMENT` FROM `information_schema` . `ENGI... | information_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 | 40306 | |
2472 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 125881978098000 | 125882038899000 | 60801000 | 21000000 | 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 | 40274 | |
2473 | 10 | NULL | statement/sql/select | init_net_server_extension.cc:95 | 125923733473000 | 125923912381000 | 178908000 | 60000000 | 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 | 40311 |
|