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 | 156961 | 1.74 m | 1.48 s | 23.17 s | 552978 | 3953924 | 0 | 52445 | |
192.168.30.20 | show_fields | 8687 | 8.80 s | 9.93 ms | 3.60 s | 303035 | 1548819 | 0 | 0 | |
192.168.30.20 | show_keys | 9799 | 8.30 s | 107.10 ms | 3.91 s | 10021 | 156201 | 0 | 0 | |
192.168.30.20 | show_variables | 7476 | 7.48 s | 666.19 ms | 662.61 ms | 8572 | 4289985 | 0 | 7476 | |
192.168.30.20 | show_tables | 8283 | 3.11 s | 4.87 ms | 1.56 s | 102039 | 294336 | 0 | 0 | |
192.168.30.20 | create_table | 6 | 2.10 s | 1.17 s | 8.50 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | insert | 36 | 982.00 ms | 46.67 ms | 4.30 ms | 0 | 0 | 30 | 0 | |
192.168.30.20 | show_create_table | 4391 | 941.70 ms | 5.55 ms | 637.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | set_option | 17370 | 758.32 ms | 3.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 12 | 629.37 ms | 86.07 ms | 5.96 ms | 0 | 0 | 11 | 0 | |
192.168.30.20 | Init DB | 9901 | 536.47 ms | 1.12 ms | 103.66 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 2362 | 191.23 ms | 1.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 164218 | 121.24 ms | 2.48 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 3526 | 113.89 ms | 1.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 11568 | 73.58 ms | 558.25 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 184 | 65.13 ms | 1.85 ms | 40.16 ms | 103 | 968 | 0 | 0 | |
192.168.30.20 | freturn | 40951 | 47.84 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 109 | 29.35 ms | 15.05 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_status | 2 | 25.48 ms | 24.98 ms | 242.00 us | 900 | 900 | 0 | 2 | |
192.168.30.20 | show_create_proc | 54 | 13.92 ms | 2.78 ms | 4.20 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 44 | 6.54 ms | 533.96 us | 1.08 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 24 | 5.50 ms | 2.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 53 | 5.48 ms | 473.65 us | 2.90 ms | 477 | 477 | 0 | 53 | |
192.168.30.20 | show_slave_status | 80 | 4.74 ms | 645.17 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 49 | 4.72 ms | 2.44 ms | 0 ps | 0 | 0 | 0 | 0 |
|