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 | 69135 | 27.88 s | 585.11 ms | 8.81 s | 203286 | 2009224 | 0 | 24078 | |
192.168.30.20 | show_fields | 3960 | 3.96 s | 5.82 ms | 1.50 s | 179109 | 910627 | 0 | 0 | |
192.168.30.20 | show_variables | 3637 | 3.07 s | 5.84 ms | 316.62 ms | 3635 | 2087365 | 0 | 3637 | |
192.168.30.20 | show_keys | 3587 | 3.03 s | 91.20 ms | 1.29 s | 4050 | 69173 | 0 | 0 | |
192.168.30.20 | show_tables | 3360 | 1.49 s | 5.57 ms | 744.22 ms | 36485 | 103599 | 0 | 0 | |
192.168.30.20 | drop_db | 3 | 497.70 ms | 322.29 ms | 3.00 ms | 0 | 0 | 6 | 0 | |
192.168.30.20 | set_option | 7307 | 422.46 ms | 5.38 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 2017 | 417.26 ms | 14.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 4285 | 288.92 ms | 17.49 ms | 73.65 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_table | 1 | 179.46 ms | 179.46 ms | 3.58 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 2 | 96.38 ms | 53.23 ms | 4.15 ms | 0 | 0 | 2 | 0 | |
192.168.30.20 | show_grants | 1169 | 88.45 ms | 1.19 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 1774 | 53.03 ms | 156.91 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 38108 | 34.43 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 4887 | 31.43 ms | 307.28 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 10036 | 15.36 ms | 5.05 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 22 | 14.34 ms | 1.43 ms | 9.81 ms | 4 | 54 | 0 | 0 | |
192.168.30.20 | Prepare | 3 | 6.33 ms | 5.31 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 41 | 5.07 ms | 2.09 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 41 | 4.32 ms | 1.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 45 | 3.07 ms | 355.72 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 10 | 2.67 ms | 1.88 ms | 2.24 ms | 90 | 90 | 0 | 10 | |
192.168.30.20 | Execute | 3 | 1.29 ms | 812.36 us | 502.00 us | 0 | 6 | 0 | 3 | |
192.168.30.20 | stmt | 2 | 1.07 ms | 978.34 us | 0 ps | 0 | 2 | 0 | 0 | |
192.168.30.20 | error | 23 | 1.06 ms | 347.76 us | 0 ps | 0 | 0 | 0 | 0 |
|