SELECT * FROM `events_statements_summary_global_by_event_name`
|
EVENT_NAME | COUNT_STAR | SUM_TIMER_WAIT | MIN_TIMER_WAIT | AVG_TIMER_WAIT | MAX_TIMER_WAIT | SUM_LOCK_TIME | SUM_ERRORS | SUM_WARNINGS | SUM_ROWS_AFFECTED | SUM_ROWS_SENT | SUM_ROWS_EXAMINED | SUM_CREATED_TMP_DISK_TABLES | SUM_CREATED_TMP_TABLES | SUM_SELECT_FULL_JOIN | SUM_SELECT_FULL_RANGE_JOIN | SUM_SELECT_RANGE | SUM_SELECT_RANGE_CHECK | SUM_SELECT_SCAN | SUM_SORT_MERGE_PASSES | SUM_SORT_RANGE | SUM_SORT_ROWS | SUM_SORT_SCAN | SUM_NO_INDEX_USED | SUM_NO_GOOD_INDEX_USED | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
statement/sql/select | 33444 | 14818010293000 | 17710000 | 443069000 | 961271043000 | 4252581000000 | 101 | 611 | 0 | 162139 | 1352310 | 40 | 35851 | 11140 | 0 | 4 | 0 | 44823 | 4 | 4 | 116605 | 4610 | 17170 | 0 | |
statement/sql/create_table | 9 | 1092327276000 | 184725000 | 121369697000 | 303656436000 | 4331000000 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/create_index | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/alter_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/update | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/insert | 4 | 161109588000 | 2000509000 | 40277397000 | 54341271000 | 2189000000 | 1 | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/insert_select | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/delete | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/truncate | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/drop_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/drop_index | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_databases | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_tables | 3025 | 1138393985000 | 71391000 | 376328000 | 12145468000 | 603057000000 | 2374 | 0 | 0 | 7049 | 21510 | 0 | 0 | 0 | 0 | 0 | 0 | 651 | 0 | 0 | 7049 | 651 | 0 | 0 | |
statement/sql/show_fields | 1535 | 1416237568000 | 129160000 | 922630000 | 29371273000 | 612775000000 | 8 | 0 | 0 | 55054 | 280904 | 0 | 1527 | 0 | 0 | 0 | 0 | 1527 | 0 | 0 | 55054 | 1527 | 0 | 0 | |
statement/sql/show_keys | 1479 | 2002597366000 | 404555000 | 1354021000 | 133731238000 | 533187000000 | 0 | 0 | 0 | 1529 | 19215 | 0 | 1479 | 0 | 0 | 0 | 0 | 1479 | 0 | 0 | 1529 | 1479 | 0 | 0 | |
statement/sql/show_variables | 1632 | 1433348724000 | 493746000 | 878277000 | 16168148000 | 146869000000 | 0 | 0 | 0 | 2174 | 935424 | 0 | 1632 | 0 | 0 | 0 | 0 | 3264 | 0 | 0 | 0 | 0 | 1632 | 0 | |
statement/sql/show_status | 1 | 14914376000 | 14914376000 | 14914376000 | 14914376000 | 93000000 | 0 | 0 | 0 | 450 | 450 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | |
statement/sql/show_engine_logs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_engine_status | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_engine_mutex | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_processlist | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_master_status | 75 | 4849256000 | 22819000 | 64656000 | 213468000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_slave_status | 75 | 7233989000 | 31417000 | 96453000 | 286076000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_grants | 1376 | 122795427000 | 21306000 | 89240000 | 2108244000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_create_table | 749 | 147535226000 | 47427000 | 196976000 | 7407505000 | 844000000 | 2 | 1 | 0 | 0 | 0 | 1 | 42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|