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 | 5653 | 2.54 s | 295.60 ms | 727.38 ms | 28588 | 193096 | 0 | 2896 | |
192.168.30.20 | create_table | 1 | 299.88 ms | 299.88 ms | 1.44 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_variables | 308 | 276.65 ms | 6.00 ms | 31.16 ms | 308 | 176561 | 0 | 308 | |
192.168.30.20 | show_fields | 283 | 262.05 ms | 2.56 ms | 100.90 ms | 12223 | 62149 | 0 | 0 | |
192.168.30.20 | show_tables | 534 | 189.29 ms | 4.40 ms | 99.04 ms | 528 | 1571 | 0 | 0 | |
192.168.30.20 | show_keys | 226 | 157.45 ms | 13.13 ms | 79.91 ms | 304 | 4028 | 0 | 0 | |
192.168.30.20 | set_option | 1134 | 111.67 ms | 5.73 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 2 | 90.79 ms | 51.39 ms | 261.00 us | 0 | 0 | 2 | 0 | |
192.168.30.20 | Init DB | 680 | 66.28 ms | 1.88 ms | 16.92 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | insert | 1 | 42.93 ms | 42.93 ms | 426.00 us | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_create_table | 138 | 29.30 ms | 2.13 ms | 70.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 41 | 23.89 ms | 4.78 ms | 16.15 ms | 0 | 36 | 0 | 0 | |
192.168.30.20 | show_grants | 242 | 21.11 ms | 340.15 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 4 | 9.84 ms | 9.35 ms | 3.33 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 760 | 6.33 ms | 227.33 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 124 | 3.94 ms | 160.55 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 17 | 3.49 ms | 2.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 2 | 1.65 ms | 1.49 ms | 716.00 us | 0 | 4 | 0 | 2 | |
192.168.30.20 | show_binlogs | 14 | 1.61 ms | 483.85 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 2 | 1.35 ms | 1.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_proc | 3 | 980.87 us | 549.14 us | 326.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 17 | 932.80 us | 133.73 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 8 | 562.39 us | 271.92 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 5 | 457.08 us | 142.92 us | 207.00 us | 45 | 45 | 0 | 5 | |
192.168.30.20 | Close stmt | 2 | 34.92 us | 23.20 us | 0 ps | 0 | 0 | 0 | 0 |
|