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 | 8723 | 4.51 s | 1.21 s | 1.08 s | 36128 | 304243 | 0 | 4705 | |
192.168.30.20 | show_keys | 254 | 661.48 ms | 80.18 ms | 89.69 ms | 441 | 4961 | 0 | 0 | |
192.168.30.20 | show_variables | 396 | 333.82 ms | 3.43 ms | 35.10 ms | 396 | 227304 | 0 | 396 | |
192.168.30.20 | show_fields | 359 | 329.68 ms | 3.14 ms | 128.21 ms | 15320 | 77887 | 0 | 0 | |
192.168.30.20 | show_table_status | 68 | 321.04 ms | 192.19 ms | 7.20 ms | 51 | 233 | 0 | 0 | |
192.168.30.20 | show_tables | 916 | 197.31 ms | 2.85 ms | 89.59 ms | 1084 | 2814 | 0 | 0 | |
192.168.30.20 | set_option | 1744 | 136.41 ms | 5.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 1129 | 108.54 ms | 365.47 us | 32.74 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 534 | 44.54 ms | 753.95 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 183 | 38.95 ms | 8.06 ms | 242.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 1202 | 9.26 ms | 169.11 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 173 | 4.96 ms | 72.69 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 8 | 3.49 ms | 2.45 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 5 | 2.17 ms | 1.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 8 | 2.01 ms | 1.05 ms | 1.28 ms | 0 | 16 | 0 | 8 | |
192.168.30.20 | error | 30 | 1.73 ms | 406.39 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 5 | 1.29 ms | 953.92 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 14 | 823.51 us | 76.54 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 1 | 517.60 us | 517.60 us | 424.00 us | 9 | 9 | 0 | 1 | |
192.168.30.20 | Close stmt | 8 | 71.43 us | 28.24 us | 0 ps | 0 | 0 | 0 | 0 | |
background | select | 1 | 1.14 ms | 1.14 ms | 0 ps | 1 | 1 | 0 | 0 |
|