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 | 58459 | 25.27 s | 221.14 ms | 7.98 s | 150829 | 1278029 | 0 | 23465 | |
192.168.30.20 | drop_db | 26 | 4.97 s | 1.11 s | 22.82 ms | 0 | 0 | 68 | 0 | |
192.168.30.20 | show_fields | 4506 | 4.73 s | 5.93 ms | 1.73 s | 211515 | 1075124 | 0 | 0 | |
192.168.30.20 | show_keys | 3362 | 3.64 s | 105.90 ms | 1.23 s | 4871 | 82812 | 0 | 0 | |
192.168.30.20 | show_variables | 4060 | 3.48 s | 7.15 ms | 367.59 ms | 4041 | 2329327 | 0 | 4060 | |
192.168.30.20 | show_tables | 3803 | 1.69 s | 232.58 ms | 936.30 ms | 31498 | 118594 | 0 | 0 | |
192.168.30.20 | set_option | 8596 | 530.76 ms | 26.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 2255 | 442.26 ms | 2.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 198 | 364.85 ms | 334.80 ms | 17.92 ms | 33 | 250 | 0 | 0 | |
192.168.30.20 | Init DB | 5165 | 338.93 ms | 1.52 ms | 73.81 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 1904 | 149.90 ms | 826.25 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 2 | 112.81 ms | 67.40 ms | 2.90 ms | 0 | 0 | 2 | 0 | |
192.168.30.20 | show_warnings | 1942 | 56.96 ms | 191.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 5729 | 36.27 ms | 410.07 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 17589 | 14.63 ms | 499.42 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 4813 | 11.90 ms | 6.28 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 93 | 7.91 ms | 1.88 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 41 | 5.52 ms | 1.85 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 41 | 4.46 ms | 188.17 us | 1.41 ms | 10 | 74 | 0 | 32 | |
192.168.30.20 | error | 16 | 3.82 ms | 3.28 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 30 | 3.40 ms | 275.08 us | 1.71 ms | 270 | 270 | 0 | 30 | |
192.168.30.20 | stmt | 7 | 1.58 ms | 627.56 us | 0 ps | 0 | 7 | 0 | 0 | |
192.168.30.20 | set | 14 | 1.05 ms | 592.71 us | 0 ps | 0 | 7 | 0 | 0 | |
192.168.30.20 | show_master_status | 17 | 1.05 ms | 583.80 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 17 | 866.40 us | 71.14 us | 0 ps | 0 | 0 | 0 | 0 |
|