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 | 4521 | 2.15 s | 114.39 ms | 596.43 ms | 21593 | 194791 | 0 | 2024 | |
192.168.30.20 | show_keys | 231 | 412.80 ms | 138.84 ms | 82.60 ms | 318 | 4972 | 0 | 0 | |
192.168.30.20 | show_fields | 343 | 306.28 ms | 4.78 ms | 120.79 ms | 12525 | 63846 | 0 | 0 | |
192.168.30.20 | show_variables | 288 | 267.89 ms | 11.59 ms | 26.46 ms | 286 | 165228 | 0 | 288 | |
192.168.30.20 | show_tables | 301 | 91.09 ms | 2.89 ms | 41.32 ms | 1320 | 4620 | 0 | 0 | |
192.168.30.20 | set_option | 703 | 59.23 ms | 6.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 422 | 33.89 ms | 676.68 us | 8.71 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 172 | 28.01 ms | 679.26 us | 777.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 201 | 16.82 ms | 828.81 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 11 | 8.57 ms | 7.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 56 | 6.35 ms | 349.98 us | 3.59 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 131 | 3.92 ms | 82.64 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 469 | 3.42 ms | 218.33 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 20 | 3.17 ms | 998.29 us | 1.30 ms | 180 | 180 | 0 | 20 | |
192.168.30.20 | Prepare | 1 | 707.61 us | 707.61 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 296 | 558.94 us | 406.53 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 | 39 | 41.48 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 |
|