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 | 6967 | 3.84 s | 630.63 ms | 949.54 ms | 29115 | 269382 | 0 | 3172 | |
192.168.30.20 | show_keys | 331 | 993.22 ms | 234.90 ms | 120.04 ms | 498 | 7679 | 0 | 0 | |
192.168.30.20 | show_fields | 475 | 482.61 ms | 4.87 ms | 181.74 ms | 20961 | 106625 | 0 | 0 | |
192.168.30.20 | show_variables | 413 | 390.15 ms | 5.54 ms | 39.86 ms | 413 | 237041 | 0 | 413 | |
192.168.30.20 | show_table_status | 41 | 238.07 ms | 229.24 ms | 4.47 ms | 69 | 309 | 0 | 0 | |
192.168.30.20 | show_tables | 548 | 186.40 ms | 6.84 ms | 86.12 ms | 3291 | 14498 | 0 | 0 | |
192.168.30.20 | set_option | 1131 | 101.00 ms | 5.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 703 | 59.33 ms | 351.41 us | 15.31 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 227 | 44.33 ms | 1.99 ms | 313.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 338 | 28.27 ms | 503.50 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 195 | 6.65 ms | 473.50 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 762 | 5.60 ms | 261.05 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 37 | 3.54 ms | 694.28 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 11 | 1.74 ms | 437.41 us | 852.00 us | 9 | 13 | 0 | 2 | |
192.168.30.20 | Prepare | 11 | 1.40 ms | 388.04 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 2 | 1.28 ms | 1.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 5 | 1.10 ms | 658.21 us | 815.00 us | 45 | 45 | 0 | 5 | |
192.168.30.20 | jump_if_not | 388 | 725.76 us | 278.69 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 51 | 477.41 us | 427.83 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 5 | 466.76 us | 336.18 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 2 | 384.87 us | 340.30 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 11 | 83.66 us | 11.90 us | 0 ps | 0 | 0 | 0 | 0 | |
background | select | 1 | 3.90 ms | 3.90 ms | 0 ps | 1 | 1 | 0 | 0 |
|