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 | 50694 | 19090277908000 | 270684678000 | 6308923000000 | 194085 | 1735241 | 0 | 19881 | |
192.168.30.20 | alter_table | 18 | 6944789943000 | 538816339000 | 3768000000 | 0 | 0 | 19 | 0 | |
192.168.30.20 | show_fields | 2861 | 2701989410000 | 4490432000 | 1051469000000 | 123314 | 627656 | 0 | 0 | |
192.168.30.20 | show_variables | 2948 | 2570634594000 | 7495092000 | 264377000000 | 2925 | 1690346 | 0 | 2948 | |
192.168.30.20 | show_keys | 2084 | 2467033209000 | 142710816000 | 726113000000 | 3058 | 44641 | 0 | 0 | |
192.168.30.20 | create_table | 13 | 2385027070000 | 317241470000 | 6536000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_tables | 3156 | 1221338885000 | 5519520000 | 618011000000 | 14148 | 47635 | 0 | 0 | |
192.168.30.20 | set_option | 6909 | 512846583000 | 7215705000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 4365 | 359698731000 | 1345551000 | 85454000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 1468 | 264486591000 | 7139948000 | 965000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 4 | 217171198000 | 72963689000 | 2623000000 | 0 | 0 | 4 | 0 | |
192.168.30.20 | show_grants | 1936 | 150065634000 | 1141138000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | insert | 2 | 90405443000 | 51435439000 | 3545000000 | 0 | 0 | 19 | 0 | |
192.168.30.20 | show_table_status | 147 | 48555328000 | 3168181000 | 26868000000 | 154 | 842 | 0 | 0 | |
192.168.30.20 | show_warnings | 1287 | 40641421000 | 191898000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 4591 | 33056772000 | 871768000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 51 | 6956586000 | 1994273000 | 4292000000 | 459 | 459 | 0 | 51 | |
192.168.30.20 | Prepare | 38 | 6034500000 | 1205755000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 87 | 5722281000 | 444560000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 38 | 5238955000 | 362629000 | 1607000000 | 0 | 76 | 0 | 38 | |
192.168.30.20 | show_slave_status | 36 | 4164555000 | 781600000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 36 | 2865778000 | 628870000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 55 | 2197239000 | 390407000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 75 | 410466000 | 337728000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 38 | 386631000 | 28778000 | 0 | 0 | 0 | 0 | 0 |
|