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 | 9529 | 5.70 s | 207.11 ms | 1.47 s | 35151 | 347417 | 0 | 3719 | |
192.168.30.20 | show_keys | 489 | 1.55 s | 105.90 ms | 198.65 ms | 721 | 11574 | 0 | 0 | |
192.168.30.20 | show_fields | 627 | 684.32 ms | 4.34 ms | 261.17 ms | 26863 | 136820 | 0 | 0 | |
192.168.30.20 | show_variables | 562 | 542.22 ms | 7.15 ms | 52.85 ms | 550 | 322021 | 0 | 562 | |
192.168.30.20 | show_tables | 582 | 189.56 ms | 3.49 ms | 88.92 ms | 4419 | 15925 | 0 | 0 | |
192.168.30.20 | set_option | 1365 | 120.23 ms | 26.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 318 | 65.93 ms | 2.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 802 | 49.95 ms | 1.52 ms | 10.68 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 349 | 29.32 ms | 824.89 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 257 | 8.01 ms | 191.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 30 | 6.60 ms | 2.29 ms | 4.14 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 906 | 5.80 ms | 290.68 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 3 | 3.34 ms | 3.28 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 15 | 3.19 ms | 1.85 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 12 | 2.82 ms | 1.88 ms | 0 ps | 0 | 0 | 0 | 0 | |
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 | Execute | 15 | 1.51 ms | 143.43 us | 498.00 us | 0 | 30 | 0 | 15 | |
192.168.30.20 | show_master_status | 6 | 726.45 us | 583.80 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 6 | 310.99 us | 60.77 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 15 | 171.70 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 |
|