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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
599424 | 130 | 130 | statement/sql/select | mysqld.cc:940 | 1348492801378100000 | 1348492802112900000 | 734800000 | 0 | SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`SCHEMAT... | 1f48aa4f42708aa18fadb902aea7f892 | SELECT COUNT ( * ) FROM `INFORMATION_SCHEMA` . `SC... | information_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 8 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
599426 | 5 | NULL | statement/sql/select | mysqld.cc:940 | 1348492809097400000 | NULL | NULL | 0 | SELECT * FROM `events_statements_current` LIMIT 0... | NULL | NULL | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
599427 | 4 | 4 | statement/sql/select | mysqld.cc:940 | 1348492683064500000 | 1348492683150700000 | 86200000 | 0 | SELECT USER() | 912155a01c21a0fbb7092da1641dc3c9 | SELECT SYSTEM_USER ( ) | mysql | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | |
599429 | 4 | 4 | statement/sql/select | mysqld.cc:940 | 1348492751169600000 | 1348492751252100000 | 82500000 | 0 | SELECT USER() | 912155a01c21a0fbb7092da1641dc3c9 | SELECT SYSTEM_USER ( ) | mysql | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL |