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 | 115723 | 61286576078000 | 13195000 | 529597000 | 758044163000 | 15053075000000 | 158 | 1411 | 0 | 379633 | 3855447 | 94 | 80201 | 22009 | 0 | 1 | 0 | 133329 | 28 | 1 | 276491 | 10696 | 34566 | 0 | |
statement/sql/create_table | 25 | 3208671220000 | 34662736000 | 128346848000 | 249514068000 | 14520000000 | 0 | 582 | 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 | 32 | 9541221555000 | 83582678000 | 298163173000 | 585909179000 | 30367000000 | 0 | 15 | 1907 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/update | 1 | 19362507000 | 19362507000 | 19362507000 | 19362507000 | 3992000000 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/insert | 29 | 899039083000 | 14091513000 | 31001347000 | 87374118000 | 54477000000 | 0 | 0 | 1293 | 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 | 2 | 57178000000 | 25494640000 | 28589000000 | 31683360000 | 59000000 | 0 | 0 | 2 | 0 | 2 | 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 | 5807 | 2680518390000 | 54021000 | 461601000 | 8920463000 | 1320489000000 | 4365 | 0 | 0 | 53232 | 157301 | 0 | 0 | 0 | 0 | 0 | 0 | 1442 | 0 | 0 | 53232 | 1442 | 0 | 0 | |
statement/sql/show_fields | 5487 | 5149766334000 | 72944000 | 938539000 | 17510618000 | 2085050000000 | 51 | 0 | 0 | 195818 | 1000682 | 0 | 5436 | 0 | 0 | 0 | 0 | 5436 | 0 | 0 | 195818 | 5436 | 0 | 0 | |
statement/sql/show_keys | 5563 | 5377366389000 | 405790000 | 966630000 | 153177575000 | 2050339000000 | 0 | 0 | 0 | 5549 | 95701 | 0 | 5563 | 0 | 0 | 0 | 0 | 5563 | 0 | 0 | 5549 | 5563 | 0 | 0 | |
statement/sql/show_variables | 5005 | 4219285299000 | 469191000 | 843014000 | 9723823000 | 441810000000 | 0 | 0 | 0 | 6092 | 2871274 | 0 | 5005 | 0 | 0 | 0 | 0 | 10010 | 0 | 0 | 0 | 0 | 5005 | 0 | |
statement/sql/show_status | 2 | 48243537000 | 801372000 | 24121768000 | 47442165000 | 449000000 | 0 | 0 | 0 | 900 | 900 | 0 | 2 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 2 | 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 | 10335905000 | 24075000 | 137812000 | 5285966000 | 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 | 12755771000 | 32890000 | 170076000 | 5862409000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_grants | 2198 | 192115751000 | 44289000 | 87404000 | 14559439000 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_create_table | 2733 | 557779351000 | 47961000 | 204090000 | 12135269000 | 1645000000 | 25 | 3 | 0 | 0 | 0 | 4 | 153 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|