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 | 56346 | 24.54 s | 221.14 ms | 7.70 s | 146767 | 1245457 | 0 | 22569 | |
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 | 4328 | 4.54 s | 5.93 ms | 1.66 s | 202813 | 1030924 | 0 | 0 | |
192.168.30.20 | show_keys | 3233 | 3.56 s | 105.90 ms | 1.19 s | 4689 | 79588 | 0 | 0 | |
192.168.30.20 | show_variables | 3905 | 3.35 s | 7.15 ms | 354.24 ms | 3886 | 2240357 | 0 | 3905 | |
192.168.30.20 | show_tables | 3672 | 1.64 s | 232.58 ms | 916.41 ms | 30632 | 115526 | 0 | 0 | |
192.168.30.20 | set_option | 8269 | 513.31 ms | 26.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 2167 | 425.78 ms | 2.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 189 | 363.90 ms | 334.80 ms | 17.43 ms | 33 | 250 | 0 | 0 | |
192.168.30.20 | Init DB | 4965 | 325.55 ms | 1.52 ms | 70.81 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 1840 | 144.84 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 | 1866 | 54.80 ms | 191.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 5507 | 34.98 ms | 410.07 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 15237 | 13.12 ms | 499.42 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 4538 | 11.64 ms | 6.28 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 86 | 7.43 ms | 1.88 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 37 | 5.22 ms | 1.85 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 37 | 4.14 ms | 188.17 us | 1.32 ms | 10 | 66 | 0 | 28 | |
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 |
|