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 | 65513 | 24101731113000 | 14880000 | 367892000 | 533553688000 | 8583331000000 | 183 | 1609 | 0 | 246034 | 1235908 | 48 | 69143 | 25080 | 0 | 198 | 0 | 90218 | 0 | 198 | 106226 | 10776 | 33069 | 0 | |
statement/sql/create_table | 2 | 303851813000 | 150943906000 | 151925906000 | 152907907000 | 3975000000 | 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 | 1378049009000 | 285275866000 | 344512252000 | 414615204000 | 5370000000 | 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 | 5041 | 1310122930000 | 51793000 | 259893000 | 3980095000 | 645896000000 | 4361 | 0 | 0 | 14634 | 65600 | 0 | 0 | 0 | 0 | 0 | 0 | 680 | 0 | 0 | 14634 | 680 | 0 | 0 | |
statement/sql/show_fields | 5945 | 6499494732000 | 64548000 | 1093270000 | 82886386000 | 2336623000000 | 141 | 0 | 0 | 339562 | 1717045 | 0 | 5804 | 0 | 0 | 0 | 0 | 5804 | 0 | 0 | 339562 | 5804 | 0 | 0 | |
statement/sql/show_keys | 3554 | 2565624189000 | 406588000 | 721897000 | 57108686000 | 1257576000000 | 0 | 0 | 0 | 7402 | 56485 | 0 | 3554 | 0 | 0 | 0 | 0 | 3554 | 0 | 0 | 7402 | 3554 | 0 | 0 | |
statement/sql/show_variables | 5768 | 4900897048000 | 503830000 | 849670000 | 10770109000 | 510952000000 | 0 | 0 | 0 | 7974 | 3310139 | 0 | 5768 | 0 | 0 | 0 | 0 | 11536 | 0 | 0 | 0 | 0 | 5768 | 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 | 96 | 4204083000 | 21946000 | 43792000 | 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 | 96 | 5791976000 | 31365000 | 60333000 | 189089000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_grants | 2210 | 196348855000 | 46442000 | 88845000 | 28395286000 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
statement/sql/show_create_table | 2864 | 623692757000 | 48728000 | 217769000 | 30026216000 | 2029000000 | 40 | 0 | 0 | 0 | 0 | 0 | 93 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|