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 | 49458 | 20213854629000 | 268449560000 | 6759695000000 | 167691 | 840837 | 0 | 11152 | |
192.168.30.20 | show_keys | 1611 | 1786851347000 | 113916127000 | 592776000000 | 1701 | 27145 | 0 | 0 | |
192.168.30.20 | show_fields | 1803 | 1739228482000 | 4570036000 | 678212000000 | 70984 | 361643 | 0 | 0 | |
192.168.30.20 | show_variables | 1609 | 1384742088000 | 6069692000 | 141308000000 | 1608 | 923461 | 0 | 1609 | |
192.168.30.20 | show_tables | 1627 | 725531915000 | 16624629000 | 337052000000 | 16737 | 49891 | 0 | 0 | |
192.168.30.20 | set_option | 3460 | 237339995000 | 6722600000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 944 | 233205165000 | 9395623000 | 8416000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_table | 1 | 225973345000 | 225973345000 | 3819000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 1959 | 134126577000 | 392575000 | 31340000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 137 | 67526730000 | 3136153000 | 45136000000 | 69 | 347 | 0 | 0 | |
192.168.30.20 | create_db | 1 | 58743628000 | 58743628000 | 2219000000 | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_grants | 693 | 53131635000 | 298322000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 786 | 24387530000 | 296750000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 2288 | 14685181000 | 175316000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 3646 | 3567155000 | 769202000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | change_db | 70 | 3312446000 | 280355000 | 29000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 14 | 3193074000 | 2586337000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 15 | 2985862000 | 937773000 | 1726000000 | 135 | 135 | 0 | 15 | |
192.168.30.20 | show_binlogs | 31 | 2685331000 | 605301000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 608 | 2500609000 | 817118000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 2 | 1678754000 | 1422486000 | 0 | 0 | 2 | 0 | 0 | |
192.168.30.20 | set | 4 | 1616954000 | 1378142000 | 0 | 0 | 2 | 0 | 0 | |
192.168.30.20 | show_slave_status | 14 | 1492552000 | 561154000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 4 | 133751000 | 42218000 | 0 | 0 | 0 | 0 | 0 | |
background | select | 1 | 943162000 | 943162000 | 0 | 1 | 1 | 0 | 0 |
|