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 | 6673 | 4.74 s | 565.92 ms | 949.26 ms | 42971 | 277727 | 0 | 3159 | |
192.168.30.20 | show_keys | 326 | 910.21 ms | 142.27 ms | 130.08 ms | 383 | 5887 | 0 | 0 | |
192.168.30.20 | show_variables | 434 | 425.47 ms | 4.03 ms | 41.52 ms | 434 | 248864 | 0 | 434 | |
192.168.30.20 | show_fields | 402 | 418.99 ms | 6.29 ms | 173.96 ms | 13673 | 69966 | 0 | 0 | |
192.168.30.20 | show_tables | 816 | 247.94 ms | 1.76 ms | 128.84 ms | 3759 | 18010 | 0 | 0 | |
192.168.30.20 | create_db | 2 | 133.97 ms | 91.60 ms | 869.00 us | 0 | 0 | 2 | 0 | |
192.168.30.20 | set_option | 1714 | 92.66 ms | 8.58 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 189 | 52.10 ms | 10.18 ms | 1.29 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 913 | 50.47 ms | 253.70 us | 13.66 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 281 | 21.97 ms | 150.14 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 1143 | 9.02 ms | 247.51 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 13 | 9.02 ms | 1.53 ms | 5.89 ms | 33 | 250 | 0 | 0 | |
192.168.30.20 | show_warnings | 162 | 5.61 ms | 402.58 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 59 | 4.80 ms | 706.28 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 11 | 3.69 ms | 3.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 10 | 2.32 ms | 1.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 15 | 1.76 ms | 213.92 us | 836.00 us | 135 | 135 | 0 | 15 | |
192.168.30.20 | freturn | 117 | 1.69 ms | 1.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 10 | 1.60 ms | 406.95 us | 414.00 us | 9 | 11 | 0 | 1 | |
192.168.30.20 | show_slave_status | 18 | 1.20 ms | 259.16 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 18 | 861.91 us | 344.38 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 785 | 752.51 us | 6.58 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 10 | 84.75 us | 20.52 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_hosts | 1 | 40.59 us | 40.59 us | 0 ps | 0 | 0 | 0 | 0 | |
background | select | 1 | 1.34 ms | 1.34 ms | 0 ps | 1 | 1 | 0 | 0 |
|