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 | 50784 | 19053149684000 | 14880000 | 375180000 | 533553688000 | 6591297000000 | 164 | 1239 | 0 | 199712 | 998235 | 32 | 53707 | 19310 | 0 | 158 | 0 | 69865 | 0 | 158 | 91910 | 8303 | 25596 | 0 | |
statement/sql/create_table | 1 | 150943906000 | 150943906000 | 150943906000 | 150943906000 | 1751000000 | 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 | 2 | 713727863000 | 299112659000 | 356863931000 | 414615204000 | 2898000000 | 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 | 3952 | 1010947748000 | 51793000 | 255806000 | 3980095000 | 494194000000 | 3447 | 0 | 0 | 11643 | 52052 | 0 | 0 | 0 | 0 | 0 | 0 | 505 | 0 | 0 | 11643 | 505 | 0 | 0 | |
statement/sql/show_fields | 4524 | 4972286440000 | 64548000 | 1099090000 | 82886386000 | 1800867000000 | 118 | 0 | 0 | 255219 | 1290743 | 0 | 4406 | 0 | 0 | 0 | 0 | 4406 | 0 | 0 | 255219 | 4406 | 0 | 0 | |
statement/sql/show_keys | 2720 | 2022799704000 | 406588000 | 743676000 | 57108686000 | 966205000000 | 0 | 0 | 0 | 5584 | 42927 | 0 | 2720 | 0 | 0 | 0 | 0 | 2720 | 0 | 0 | 5584 | 2720 | 0 | 0 | |
statement/sql/show_variables | 4391 | 3753108385000 | 503830000 | 854727000 | 10770109000 | 391338000000 | 0 | 0 | 0 | 6597 | 2519909 | 0 | 4391 | 0 | 0 | 0 | 0 | 8782 | 0 | 0 | 0 | 0 | 4391 | 0 | |
statement/sql/show_status | 4 | 11904679000 | 513320000 | 2976169000 | 10212405000 | 349000000 | 0 | 0 | 0 | 1800 | 1800 | 0 | 4 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 4 | 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 | 81 | 3620390000 | 22173000 | 44696000 | 420924000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_slave_status | 81 | 4871123000 | 32277000 | 60137000 | 189089000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_grants | 1699 | 130053653000 | 46442000 | 76547000 | 605459000 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_create_table | 2182 | 482665258000 | 48728000 | 221203000 | 30026216000 | 1740000000 | 36 | 0 | 0 | 0 | 0 | 0 | 77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|