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 | 22793 | 11.00 s | 221.14 ms | 3.24 s | 69356 | 678488 | 0 | 9239 | |
192.168.30.20 | drop_db | 26 | 4.97 s | 1.11 s | 22.82 ms | 0 | 0 | 68 | 0 | |
192.168.30.20 | show_keys | 1250 | 2.11 s | 105.90 ms | 473.02 ms | 1830 | 31202 | 0 | 0 | |
192.168.30.20 | show_fields | 1648 | 1.76 s | 5.93 ms | 650.91 ms | 75843 | 385731 | 0 | 0 | |
192.168.30.20 | show_variables | 1501 | 1.34 s | 7.15 ms | 139.55 ms | 1489 | 860965 | 0 | 1501 | |
192.168.30.20 | show_tables | 1483 | 771.23 ms | 232.58 ms | 493.67 ms | 11303 | 41087 | 0 | 0 | |
192.168.30.20 | set_option | 3357 | 236.38 ms | 26.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 833 | 169.20 ms | 2.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 1996 | 130.83 ms | 1.52 ms | 28.60 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 1 | 67.40 ms | 67.40 ms | 2.85 ms | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_grants | 787 | 64.84 ms | 826.25 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 711 | 21.56 ms | 191.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 82 | 15.21 ms | 2.29 ms | 9.24 ms | 0 | 10 | 0 | 0 | |
192.168.30.20 | Quit | 2231 | 14.08 ms | 290.68 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 33 | 4.15 ms | 1.88 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 19 | 3.54 ms | 1.85 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 6 | 3.44 ms | 3.28 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 19 | 1.94 ms | 162.28 us | 624.00 us | 0 | 38 | 0 | 19 | |
192.168.30.20 | show_storage_engines | 15 | 1.90 ms | 275.08 us | 993.00 us | 135 | 135 | 0 | 15 | |
192.168.30.20 | show_master_status | 12 | 900.80 us | 583.80 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 63 | 872.42 us | 811.68 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 12 | 613.02 us | 60.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 475 | 265.89 us | 5.68 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 19 | 199.72 us | 30.35 us | 0 ps | 0 | 0 | 0 | 0 | |
background | select | 1 | 1.12 ms | 1.12 ms | 0 ps | 1 | 1 | 0 | 0 |
|