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 | 13586 | 5.75 s | 251.42 ms | 1.72 s | 73443 | 369684 | 0 | 5546 | |
192.168.30.20 | show_keys | 693 | 1.03 s | 89.18 ms | 236.70 ms | 1156 | 19114 | 0 | 0 | |
192.168.30.20 | show_fields | 951 | 898.26 ms | 5.24 ms | 343.34 ms | 40050 | 204102 | 0 | 0 | |
192.168.30.20 | show_variables | 880 | 788.81 ms | 38.23 ms | 81.04 ms | 1432 | 505015 | 0 | 880 | |
192.168.30.20 | show_tables | 904 | 328.64 ms | 4.80 ms | 152.51 ms | 2787 | 12127 | 0 | 0 | |
192.168.30.20 | set_option | 2204 | 213.63 ms | 7.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 2 | 140.75 ms | 93.45 ms | 2.41 ms | 0 | 0 | 2 | 0 | |
192.168.30.20 | Init DB | 1328 | 118.27 ms | 432.23 us | 29.27 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 470 | 79.31 ms | 1.30 ms | 504.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 482 | 36.24 ms | 375.02 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 394 | 11.90 ms | 207.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 1483 | 10.68 ms | 249.63 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 20 | 7.93 ms | 2.16 ms | 5.40 ms | 0 | 15 | 0 | 0 | |
192.168.30.20 | show_status | 1 | 6.50 ms | 6.50 ms | 398.00 us | 450 | 450 | 0 | 1 | |
192.168.30.20 | Execute | 11 | 4.87 ms | 542.72 us | 1.66 ms | 9 | 13 | 0 | 2 | |
192.168.30.20 | show_binlogs | 75 | 4.23 ms | 116.85 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 11 | 3.69 ms | 694.68 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 14 | 2.99 ms | 477.39 us | 1.24 ms | 126 | 126 | 0 | 14 | |
192.168.30.20 | error | 4 | 2.18 ms | 1.83 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 14 | 1.37 ms | 243.69 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 14 | 1.10 ms | 305.17 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 30 | 728.71 us | 686.34 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 11 | 344.18 us | 50.53 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 192 | 139.43 us | 9.77 us | 0 ps | 0 | 0 | 0 | 0 | |
background | select | 1 | 418.78 us | 418.78 us | 0 ps | 1 | 1 | 0 | 0 |
|