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 | 6413 | 2.97 s | 114.39 ms | 825.94 ms | 31246 | 267582 | 0 | 2866 | |
192.168.30.20 | show_keys | 334 | 528.80 ms | 138.84 ms | 121.62 ms | 454 | 6990 | 0 | 0 | |
192.168.30.20 | show_fields | 496 | 434.71 ms | 6.36 ms | 172.68 ms | 17449 | 88971 | 0 | 0 | |
192.168.30.20 | show_variables | 416 | 371.17 ms | 11.59 ms | 37.84 ms | 414 | 238700 | 0 | 416 | |
192.168.30.20 | show_tables | 399 | 123.30 ms | 2.90 ms | 55.78 ms | 1733 | 5919 | 0 | 0 | |
192.168.30.20 | set_option | 956 | 78.50 ms | 6.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 580 | 48.35 ms | 676.68 us | 12.29 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 250 | 41.86 ms | 833.26 us | 1.51 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 276 | 22.69 ms | 828.81 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 14 | 8.76 ms | 7.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 71 | 7.86 ms | 349.98 us | 4.37 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 191 | 5.82 ms | 162.04 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 31 | 5.00 ms | 998.29 us | 2.16 ms | 279 | 279 | 0 | 31 | |
192.168.30.20 | Quit | 643 | 4.53 ms | 218.33 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 754 | 845.41 us | 406.53 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 1 | 707.61 us | 707.61 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 1 | 167.53 us | 167.53 us | 36.00 us | 0 | 2 | 0 | 1 | |
192.168.30.20 | freturn | 99 | 112.67 us | 7.58 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 1 | 7.40 us | 7.40 us | 0 ps | 0 | 0 | 0 | 0 | |
background | select | 1 | 3.92 ms | 3.92 ms | 0 ps | 1 | 1 | 0 | 0 |
|