SELECT * FROM `x$host_summary_by_statement_type`
|
host | statement | total | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans | |
---|---|---|---|---|---|---|---|---|---|---|
192.168.30.20 | select | 146500 | 63937822131000 | 594325710000 | 20869654000000 | 362453 | 2704080 | 0 | 31816 | |
192.168.30.20 | show_fields | 4498 | 4577324288000 | 11287955000 | 1770984000000 | 182563 | 927907 | 0 | 0 | |
192.168.30.20 | show_variables | 4306 | 3863367354000 | 13354105000 | 386833000000 | 5409 | 2470762 | 0 | 4306 | |
192.168.30.20 | show_keys | 4843 | 3610385790000 | 79125275000 | 1845615000000 | 4433 | 46822 | 0 | 0 | |
192.168.30.20 | show_tables | 3875 | 1178365084000 | 12528589000 | 575259000000 | 18107 | 48324 | 0 | 0 | |
192.168.30.20 | set_option | 9315 | 514274656000 | 14143481000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 2316 | 505479310000 | 10825564000 | 387000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | alter_table | 2 | 380912845000 | 378785756000 | 806000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_table | 2 | 380599481000 | 211407460000 | 2859000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 5828 | 367712554000 | 1309311000 | 87005000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 2230 | 185503349000 | 8304885000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 3 | 134762323000 | 55831000000 | 2259000000 | 0 | 0 | 3 | 0 | |
192.168.30.20 | insert | 9 | 101089742000 | 38770679000 | 5872000000 | 0 | 0 | 7 | 0 | |
192.168.30.20 | freturn | 36109 | 77542967000 | 10790495000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 77 | 65632116000 | 47982965000 | 11734000000 | 37 | 274 | 0 | 0 | |
192.168.30.20 | jump_if_not | 68131 | 65629975000 | 2277956000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 2017 | 61772617000 | 735489000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 6290 | 41608490000 | 256863000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 80 | 33733161000 | 16268399000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 45 | 19646740000 | 15961578000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | set | 492 | 19013922000 | 1468807000 | 0 | 0 | 96 | 0 | 0 | |
192.168.30.20 | stmt | 21 | 9876973000 | 2653664000 | 0 | 0 | 21 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 42 | 8767697000 | 2037474000 | 6523000000 | 378 | 378 | 0 | 42 | |
192.168.30.20 | show_slave_status | 45 | 7822728000 | 3483124000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 16 | 4922895000 | 1950090000 | 0 | 0 | 0 | 0 | 0 |
|