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 | 93896 | 37237302615000 | 18487000 | 396580000 | 768702097000 | 11688983000000 | 1 | 2274 | 0 | 301758 | 2539837 | 16 | 77524 | 26162 | 0 | 2 | 0 | 115754 | 4 | 2 | 244742 | 10983 | 41171 | 0 | |
statement/sql/create_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/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 | 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_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 | 4192 | 1078563869000 | 63471000 | 257290000 | 5602526000 | 465810000000 | 3938 | 0 | 0 | 15653 | 37626 | 0 | 0 | 0 | 0 | 0 | 0 | 254 | 0 | 0 | 15653 | 254 | 0 | 0 | |
statement/sql/show_fields | 7356 | 7828891981000 | 444536000 | 1064286000 | 6450786000 | 2728001000000 | 0 | 0 | 0 | 418257 | 2114739 | 0 | 7356 | 0 | 0 | 0 | 0 | 7356 | 0 | 0 | 418257 | 7356 | 0 | 0 | |
statement/sql/show_keys | 5271 | 3881989874000 | 415362000 | 736480000 | 88847964000 | 1847231000000 | 0 | 0 | 0 | 9159 | 75988 | 0 | 5271 | 0 | 0 | 0 | 0 | 5271 | 0 | 0 | 9159 | 5271 | 0 | 0 | |
statement/sql/show_variables | 7393 | 6114772216000 | 584097000 | 827102000 | 8537486000 | 657117000000 | 0 | 0 | 0 | 7392 | 4243519 | 0 | 7393 | 0 | 0 | 0 | 0 | 14786 | 0 | 0 | 0 | 0 | 7393 | 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 | 5 | 2409506000 | 25526000 | 481901000 | 2132183000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_slave_status | 5 | 2781290000 | 44061000 | 556258000 | 1842130000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_grants | 2360 | 170731331000 | 41226000 | 72343000 | 1103246000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_create_table | 3735 | 750461035000 | 48209000 | 200926000 | 2392343000 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 201 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|