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 | 28357 | 15556597344000 | 917247223000 | 4021078000000 | 131363 | 1238812 | 0 | 10428 | |
192.168.30.20 | show_fields | 1282 | 1162434497000 | 5056002000 | 479631000000 | 47203 | 240698 | 0 | 0 | |
192.168.30.20 | show_keys | 1124 | 1140933968000 | 77910765000 | 407239000000 | 1133 | 18646 | 0 | 0 | |
192.168.30.20 | show_variables | 1203 | 1056003255000 | 8465749000 | 111527000000 | 1202 | 689493 | 0 | 1203 | |
192.168.30.20 | show_tables | 1956 | 672983770000 | 3398479000 | 330760000000 | 7203 | 18954 | 0 | 0 | |
192.168.30.20 | set_option | 4314 | 330114573000 | 6166829000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 2672 | 310184746000 | 59099876000 | 125863000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 579 | 218712144000 | 107412006000 | 347000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 3 | 168118239000 | 63515177000 | 277000000 | 0 | 0 | 3 | 0 | |
192.168.30.20 | show_grants | 1100 | 97317085000 | 2302639000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | grant | 2 | 94128840000 | 60940814000 | 648000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | alter_db | 1 | 66002108000 | 66002108000 | 2167000000 | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_table_status | 358 | 64441769000 | 2810517000 | 38476000000 | 0 | 115 | 0 | 0 | |
192.168.30.20 | create_user | 1 | 43907174000 | 43907174000 | 7417000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 62731 | 38407284000 | 406041000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | alter_user | 1 | 24154117000 | 24154117000 | 246000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 16151 | 23071022000 | 2122226000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 2955 | 22557425000 | 703692000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 509 | 15295964000 | 112380000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 24 | 10741082000 | 6214826000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 111 | 9155974000 | 1425500000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 41 | 8479878000 | 4738956000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | set | 156 | 5970326000 | 784807000 | 0 | 0 | 28 | 0 | 0 | |
192.168.30.20 | Execute | 24 | 5834559000 | 1842873000 | 2739000000 | 0 | 48 | 0 | 24 | |
192.168.30.20 | show_storage_engines | 47 | 4833456000 | 357424000 | 2115000000 | 423 | 423 | 0 | 47 |
|