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 | 8204 | 5.62 s | 803.17 ms | 1.17 s | 36434 | 268523 | 0 | 3686 | |
192.168.30.20 | show_keys | 411 | 1.76 s | 83.40 ms | 155.32 ms | 595 | 7650 | 0 | 0 | |
192.168.30.20 | show_fields | 511 | 480.08 ms | 3.76 ms | 201.11 ms | 17368 | 88795 | 0 | 0 | |
192.168.30.20 | show_variables | 491 | 444.82 ms | 5.13 ms | 47.47 ms | 1616 | 281519 | 0 | 491 | |
192.168.30.20 | show_tables | 672 | 227.35 ms | 5.98 ms | 107.61 ms | 1186 | 3857 | 0 | 0 | |
192.168.30.20 | set_option | 1400 | 158.82 ms | 12.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 947 | 93.39 ms | 701.80 us | 25.14 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 1 | 80.44 ms | 80.44 ms | 7.75 ms | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_table_status | 14 | 53.01 ms | 43.03 ms | 8.09 ms | 7 | 55 | 0 | 0 | |
192.168.30.20 | show_create_table | 251 | 47.08 ms | 1.35 ms | 366.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 397 | 36.42 ms | 289.35 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 1062 | 7.46 ms | 230.26 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | set | 152 | 7.36 ms | 1.57 ms | 0 ps | 0 | 26 | 0 | 0 | |
192.168.30.20 | show_warnings | 212 | 6.75 ms | 106.31 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 3000 | 3.45 ms | 277.94 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 22 | 3.43 ms | 2.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 12 | 2.89 ms | 818.30 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 12 | 2.34 ms | 367.45 us | 689.00 us | 0 | 24 | 0 | 12 | |
192.168.30.20 | freturn | 860 | 1.91 ms | 915.50 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 13 | 1.86 ms | 690.49 us | 961.00 us | 117 | 117 | 0 | 13 | |
192.168.30.20 | show_create_func | 1 | 1.82 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 1 | 1.61 ms | 1.61 ms | 0 ps | 0 | 1 | 0 | 0 | |
192.168.30.20 | show_master_status | 9 | 981.16 us | 439.20 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 9 | 828.05 us | 257.84 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 5 | 561.64 us | 372.89 us | 0 ps | 0 | 0 | 0 | 0 |
|