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 | 25994 | 10.45 s | 366.45 ms | 3.49 s | 51692 | 383184 | 0 | 4306 | |
192.168.30.20 | show_keys | 574 | 625.41 ms | 69.93 ms | 199.69 ms | 472 | 4853 | 0 | 0 | |
192.168.30.20 | show_fields | 514 | 487.57 ms | 6.19 ms | 197.33 ms | 21100 | 107168 | 0 | 0 | |
192.168.30.20 | show_variables | 510 | 442.38 ms | 8.83 ms | 45.23 ms | 510 | 292719 | 0 | 510 | |
192.168.30.20 | show_tables | 540 | 130.14 ms | 2.84 ms | 59.95 ms | 2388 | 5829 | 0 | 0 | |
192.168.30.20 | create_db | 1 | 109.45 ms | 109.45 ms | 3.11 ms | 0 | 0 | 1 | 0 | |
192.168.30.20 | set_option | 1259 | 85.01 ms | 7.61 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 260 | 60.31 ms | 5.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 759 | 47.58 ms | 348.20 us | 12.49 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 240 | 17.71 ms | 219.90 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 9532 | 11.51 ms | 1.93 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 5078 | 8.85 ms | 963.21 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 239 | 7.06 ms | 147.04 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 854 | 5.12 ms | 119.41 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 14 | 3.76 ms | 1.99 ms | 2.94 ms | 0 | 2 | 0 | 0 | |
192.168.30.20 | error | 12 | 3.29 ms | 1.89 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 17 | 2.78 ms | 1.26 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 3 | 2.25 ms | 2.05 ms | 0 ps | 0 | 3 | 0 | 0 | |
192.168.30.20 | set | 6 | 2.15 ms | 2.01 ms | 0 ps | 0 | 3 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 9 | 1.06 ms | 398.24 us | 653.00 us | 81 | 81 | 0 | 9 | |
192.168.30.20 | show_slave_status | 5 | 904.56 us | 728.50 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 2 | 797.16 us | 733.41 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 5 | 478.87 us | 344.34 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 2 | 172.92 us | 91.89 us | 51.00 us | 0 | 4 | 0 | 2 | |
192.168.30.20 | Close stmt | 2 | 14.14 us | 8.29 us | 0 ps | 0 | 0 | 0 | 0 |
|