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 | 19346 | 7.69 s | 251.42 ms | 2.40 s | 104229 | 526553 | 0 | 8187 | |
192.168.30.20 | show_keys | 1029 | 1.35 s | 89.18 ms | 349.18 ms | 1721 | 27232 | 0 | 0 | |
192.168.30.20 | show_fields | 1396 | 1.31 s | 5.24 ms | 499.90 ms | 59106 | 301081 | 0 | 0 | |
192.168.30.20 | show_variables | 1319 | 1.16 s | 38.23 ms | 121.52 ms | 2423 | 756959 | 0 | 1319 | |
192.168.30.20 | show_tables | 1277 | 446.95 ms | 4.80 ms | 206.95 ms | 3741 | 16757 | 0 | 0 | |
192.168.30.20 | set_option | 3155 | 283.26 ms | 7.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 3 | 186.29 ms | 93.45 ms | 2.50 ms | 0 | 0 | 3 | 0 | |
192.168.30.20 | Init DB | 1917 | 170.62 ms | 432.23 us | 42.19 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 692 | 117.24 ms | 1.41 ms | 1.08 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 702 | 51.94 ms | 375.02 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 591 | 17.68 ms | 207.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 2117 | 15.36 ms | 249.63 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 24 | 9.12 ms | 2.16 ms | 6.11 ms | 0 | 82 | 0 | 0 | |
192.168.30.20 | show_status | 2 | 7.67 ms | 6.50 ms | 544.00 us | 900 | 900 | 0 | 2 | |
192.168.30.20 | show_binlogs | 97 | 5.42 ms | 116.85 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 11 | 4.87 ms | 542.72 us | 1.66 ms | 9 | 13 | 0 | 2 | |
192.168.30.20 | Prepare | 11 | 3.69 ms | 694.68 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 19 | 3.68 ms | 477.39 us | 1.57 ms | 171 | 171 | 0 | 19 | |
192.168.30.20 | error | 7 | 2.27 ms | 1.83 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 21 | 2.07 ms | 243.69 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 21 | 1.57 ms | 305.17 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 180 | 889.05 us | 686.34 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 1328 | 834.83 us | 29.66 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 11 | 344.18 us | 50.53 us | 0 ps | 0 | 0 | 0 | 0 | |
background | select | 1 | 418.78 us | 418.78 us | 0 ps | 1 | 1 | 0 | 0 |
|