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 | 35310 | 13.47 s | 298.00 ms | 4.56 s | 142428 | 1089561 | 0 | 17694 | |
192.168.30.20 | show_fields | 2351 | 2.30 s | 4.93 ms | 857.15 ms | 108282 | 550928 | 0 | 0 | |
192.168.30.20 | show_variables | 2336 | 1.94 s | 5.71 ms | 204.49 ms | 2727 | 1339268 | 0 | 2336 | |
192.168.30.20 | show_keys | 1678 | 1.79 s | 78.22 ms | 582.61 ms | 2412 | 42864 | 0 | 0 | |
192.168.30.20 | show_tables | 3053 | 1.16 s | 3.66 ms | 582.81 ms | 11453 | 45819 | 0 | 0 | |
192.168.30.20 | set_option | 6241 | 456.72 ms | 5.41 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 3911 | 327.49 ms | 429.11 us | 82.39 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_table | 1 | 280.01 ms | 280.01 ms | 4.13 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 1215 | 209.24 ms | 3.20 ms | 292.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 1802 | 140.05 ms | 1.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 2 | 120.17 ms | 67.38 ms | 2.35 ms | 0 | 0 | 2 | 0 | |
192.168.30.20 | Quit | 4341 | 31.17 ms | 238.53 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 1033 | 29.43 ms | 168.94 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 21 | 18.80 ms | 2.40 ms | 12.80 ms | 6 | 56 | 0 | 0 | |
192.168.30.20 | flush | 1 | 17.65 ms | 17.65 ms | 2.84 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 41 | 8.75 ms | 485.19 us | 2.85 ms | 20 | 66 | 0 | 23 | |
192.168.30.20 | Prepare | 41 | 7.42 ms | 525.46 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_proc | 8 | 5.63 ms | 4.59 ms | 363.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_engine_status | 3 | 5.12 ms | 4.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 36 | 4.90 ms | 369.42 us | 2.30 ms | 324 | 324 | 0 | 36 | |
192.168.30.20 | show_binlogs | 51 | 4.60 ms | 1.68 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 35 | 4.08 ms | 2.96 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 30 | 2.84 ms | 503.32 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | alter_table | 2 | 2.53 ms | 2.33 ms | 1.13 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 30 | 1.67 ms | 164.09 us | 0 ps | 0 | 0 | 0 | 0 |
|