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 | 8972 | 5.56 s | 319.01 ms | 1.09 s | 34096 | 214626 | 0 | 3439 | |
192.168.30.20 | show_keys | 577 | 1.23 s | 107.10 ms | 203.20 ms | 606 | 9921 | 0 | 0 | |
192.168.30.20 | show_fields | 504 | 469.01 ms | 5.27 ms | 191.31 ms | 17716 | 90553 | 0 | 0 | |
192.168.30.20 | show_variables | 419 | 363.48 ms | 4.04 ms | 36.31 ms | 419 | 240485 | 0 | 419 | |
192.168.30.20 | show_tables | 604 | 194.05 ms | 2.20 ms | 96.55 ms | 6784 | 20209 | 0 | 0 | |
192.168.30.20 | set_option | 1264 | 52.28 ms | 2.24 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 255 | 51.23 ms | 2.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 684 | 35.36 ms | 199.02 us | 8.11 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 175 | 13.09 ms | 274.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 195 | 5.61 ms | 91.73 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 839 | 5.27 ms | 254.83 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 7 | 2.91 ms | 2.44 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 15 | 2.68 ms | 898.96 us | 1.67 ms | 0 | 67 | 0 | 0 | |
192.168.30.20 | show_binlogs | 11 | 2.58 ms | 2.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 2 | 2.51 ms | 2.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 4 | 1.90 ms | 1.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 1 | 527.59 us | 527.59 us | 0 ps | 0 | 1 | 0 | 0 | |
192.168.30.20 | set | 2 | 487.30 us | 485.77 us | 0 ps | 0 | 1 | 0 | 0 | |
192.168.30.20 | Execute | 2 | 468.89 us | 370.08 us | 68.00 us | 0 | 4 | 0 | 2 | |
192.168.30.20 | freturn | 26 | 428.66 us | 400.72 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 51 | 418.95 us | 339.58 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 4 | 210.93 us | 69.95 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 1 | 103.96 us | 103.96 us | 62.00 us | 9 | 9 | 0 | 1 | |
192.168.30.20 | Close stmt | 2 | 11.19 us | 6.37 us | 0 ps | 0 | 0 | 0 | 0 | |
background | select | 1 | 992.26 us | 992.26 us | 0 ps | 1 | 1 | 0 | 0 |
|