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 | 47404 | 21.76 s | 831.35 ms | 7.12 s | 125320 | 979337 | 0 | 10808 | |
192.168.30.20 | show_keys | 1091 | 1.60 s | 348.01 ms | 425.55 ms | 1140 | 12172 | 0 | 0 | |
192.168.30.20 | show_fields | 1240 | 1.21 s | 6.62 ms | 482.58 ms | 45171 | 229782 | 0 | 0 | |
192.168.30.20 | show_variables | 1150 | 1.09 s | 30.55 ms | 113.24 ms | 2254 | 659974 | 0 | 1150 | |
192.168.30.20 | show_tables | 1503 | 415.44 ms | 10.47 ms | 210.46 ms | 7503 | 23728 | 0 | 0 | |
192.168.30.20 | set_option | 3209 | 158.40 ms | 3.81 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 608 | 142.40 ms | 5.91 ms | 1.54 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 2001 | 117.87 ms | 312.76 us | 29.97 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 2 | 99.54 ms | 50.69 ms | 161.00 us | 0 | 0 | 2 | 0 | |
192.168.30.20 | show_grants | 905 | 70.29 ms | 168.06 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 176 | 30.51 ms | 846.14 us | 17.97 ms | 0 | 33 | 0 | 0 | |
192.168.30.20 | show_create_proc | 239 | 26.56 ms | 2.68 ms | 1.93 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_status | 2 | 21.41 ms | 20.91 ms | 219.00 us | 900 | 900 | 0 | 2 | |
192.168.30.20 | show_master_status | 27 | 20.42 ms | 19.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 214 | 20.24 ms | 970.84 us | 1.35 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 533 | 16.89 ms | 137.85 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 2206 | 16.76 ms | 218.32 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 15859 | 16.31 ms | 621.39 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 81 | 12.83 ms | 5.15 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 7532 | 11.53 ms | 323.44 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | set | 166 | 9.21 ms | 2.93 ms | 0 ps | 0 | 33 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 50 | 6.01 ms | 491.21 us | 3.31 ms | 450 | 450 | 0 | 50 | |
192.168.30.20 | stmt | 8 | 4.92 ms | 3.02 ms | 0 ps | 0 | 8 | 0 | 0 | |
192.168.30.20 | error | 28 | 2.72 ms | 1.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 12 | 2.72 ms | 1.67 ms | 0 ps | 0 | 0 | 0 | 0 |
|