SELECT * FROM `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 | 8848 | 3.82 s | 114.39 ms | 1.11 s | 40381 | 355656 | 0 | 3874 | |
192.168.30.20 | show_keys | 502 | 644.12 ms | 138.84 ms | 177.71 ms | 666 | 10165 | 0 | 0 | |
192.168.30.20 | show_fields | 692 | 616.56 ms | 6.36 ms | 242.42 ms | 25655 | 130759 | 0 | 0 | |
192.168.30.20 | show_variables | 581 | 501.43 ms | 11.59 ms | 52.26 ms | 579 | 333410 | 0 | 581 | |
192.168.30.20 | show_tables | 541 | 185.32 ms | 2.98 ms | 84.67 ms | 2703 | 9171 | 0 | 0 | |
192.168.30.20 | set_option | 1304 | 101.65 ms | 6.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 799 | 64.27 ms | 676.68 us | 15.87 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 349 | 57.65 ms | 833.26 us | 1.51 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 360 | 28.23 ms | 828.81 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 17 | 8.92 ms | 7.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 270 | 8.01 ms | 162.04 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 71 | 7.86 ms | 349.98 us | 4.37 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 875 | 6.13 ms | 218.33 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 31 | 5.00 ms | 998.29 us | 2.16 ms | 279 | 279 | 0 | 31 | |
192.168.30.20 | jump_if_not | 1211 | 1.18 ms | 406.53 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 1 | 707.61 us | 707.61 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 159 | 191.85 us | 7.58 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 1 | 167.53 us | 167.53 us | 36.00 us | 0 | 2 | 0 | 1 | |
192.168.30.20 | Close stmt | 1 | 7.40 us | 7.40 us | 0 ps | 0 | 0 | 0 | 0 | |
background | select | 1 | 3.92 ms | 3.92 ms | 0 ps | 1 | 1 | 0 | 0 |
|