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 | 83292 | 39863740990000 | 20502000 | 478602000 | 612570106000 | 13322125000000 | 120 | 2043 | 0 | 270544 | 2816319 | 37 | 71732 | 24322 | 0 | 6 | 0 | 104645 | 6 | 6 | 228377 | 10409 | 36320 | 0 | |
statement/sql/create_table | 1 | 193552426000 | 193552426000 | 193552426000 | 193552426000 | 2638000000 | 0 | 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 | 4 | 100124186000 | 2353587000 | 25031046000 | 61383871000 | 1359000000 | 1 | 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 | 2 | 45780818000 | 155655000 | 22890409000 | 45625163000 | 1623000000 | 1 | 0 | 2 | 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 | 4625 | 1514973560000 | 74381000 | 327561000 | 7753516000 | 734587000000 | 3754 | 0 | 0 | 37081 | 127393 | 0 | 0 | 0 | 0 | 0 | 0 | 871 | 0 | 0 | 37081 | 871 | 0 | 0 | |
statement/sql/show_fields | 6266 | 8546681836000 | 77789000 | 1363977000 | 8300609000 | 3013873000000 | 41 | 0 | 0 | 316645 | 1606440 | 0 | 6225 | 0 | 0 | 0 | 0 | 6225 | 0 | 0 | 316645 | 6225 | 0 | 0 | |
statement/sql/show_keys | 4312 | 4320743764000 | 430441000 | 1002027000 | 91224024000 | 1934064000000 | 0 | 0 | 0 | 6895 | 101253 | 0 | 4312 | 0 | 0 | 0 | 0 | 4312 | 0 | 0 | 6895 | 4312 | 0 | 0 | |
statement/sql/show_variables | 5613 | 5702708518000 | 543697000 | 1015982000 | 15222812000 | 551188000000 | 0 | 0 | 0 | 5605 | 3220833 | 0 | 5613 | 0 | 0 | 0 | 0 | 11226 | 0 | 0 | 0 | 0 | 5613 | 0 | |
statement/sql/show_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_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 | 38 | 2191124000 | 25169000 | 57661000 | 393035000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_slave_status | 38 | 3711455000 | 32712000 | 97669000 | 1678371000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_grants | 2674 | 225317859000 | 38926000 | 84262000 | 1997720000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_create_table | 3140 | 771495532000 | 53660000 | 245699000 | 2354400000 | 1502000000 | 20 | 0 | 0 | 0 | 0 | 0 | 122 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|