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 | 52738 | 22.20 s | 481.59 ms | 7.14 s | 533760 | 1882333 | 0 | 30360 | |
192.168.30.20 | drop_db | 26 | 5.29 s | 1.13 s | 42.55 ms | 0 | 0 | 68 | 0 | |
192.168.30.20 | show_variables | 2646 | 2.46 s | 19.87 ms | 228.62 ms | 2639 | 1518069 | 0 | 2646 | |
192.168.30.20 | show_tables | 7254 | 1.83 s | 7.16 ms | 845.71 ms | 12139 | 34520 | 0 | 0 | |
192.168.30.20 | show_keys | 807 | 1.39 s | 78.65 ms | 293.57 ms | 1258 | 19025 | 0 | 0 | |
192.168.30.20 | show_fields | 1167 | 1.10 s | 9.12 ms | 440.77 ms | 46308 | 236196 | 0 | 0 | |
192.168.30.20 | set_option | 12637 | 921.60 ms | 6.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 7094 | 735.15 ms | 2.51 ms | 194.99 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_table | 2 | 353.57 ms | 190.39 ms | 3.43 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 2846 | 271.93 ms | 983.26 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 1271 | 101.78 ms | 8.25 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 595 | 100.76 ms | 1.39 ms | 293.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 519 | 72.17 ms | 2.81 ms | 39.64 ms | 12 | 222 | 0 | 0 | |
192.168.30.20 | Quit | 8893 | 68.53 ms | 297.46 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | insert | 1 | 48.41 ms | 48.41 ms | 2.69 ms | 0 | 0 | 7 | 0 | |
192.168.30.20 | create_db | 1 | 44.35 ms | 44.35 ms | 49.00 us | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_warnings | 526 | 15.93 ms | 277.20 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 236 | 10.32 ms | 1.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 17 | 6.28 ms | 2.86 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 52 | 4.53 ms | 425.79 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 18 | 3.96 ms | 1.89 ms | 2.81 ms | 162 | 162 | 0 | 18 | |
192.168.30.20 | Execute | 17 | 3.52 ms | 810.23 us | 1.22 ms | 0 | 34 | 0 | 17 | |
192.168.30.20 | jump_if_not | 3914 | 3.38 ms | 956.22 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 52 | 3.19 ms | 162.18 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 604 | 2.15 ms | 1.28 ms | 0 ps | 0 | 0 | 0 | 0 |
|