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 | 12700 | 5.42 s | 114.39 ms | 1.56 s | 54842 | 492449 | 0 | 5406 | |
192.168.30.20 | show_keys | 732 | 963.94 ms | 138.84 ms | 254.27 ms | 960 | 14927 | 0 | 0 | |
192.168.30.20 | show_fields | 983 | 886.88 ms | 6.36 ms | 348.82 ms | 37569 | 191471 | 0 | 0 | |
192.168.30.20 | show_variables | 850 | 721.33 ms | 11.59 ms | 76.20 ms | 848 | 487774 | 0 | 850 | |
192.168.30.20 | show_tables | 750 | 273.94 ms | 4.08 ms | 126.10 ms | 4122 | 13674 | 0 | 0 | |
192.168.30.20 | set_option | 1807 | 143.36 ms | 6.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 1113 | 88.73 ms | 739.32 us | 21.19 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 491 | 82.37 ms | 833.26 us | 1.51 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 494 | 37.52 ms | 828.81 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 398 | 11.73 ms | 162.04 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 26 | 9.56 ms | 7.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 1209 | 8.36 ms | 218.33 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 72 | 7.95 ms | 349.98 us | 4.42 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 34 | 5.27 ms | 998.29 us | 2.28 ms | 306 | 306 | 0 | 34 | |
192.168.30.20 | jump_if_not | 1666 | 1.43 ms | 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 | freturn | 219 | 254.88 us | 7.58 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 | error | 1 | 34.31 us | 34.31 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 |
|