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 | 131720 | 1.47 m | 1.48 s | 19.59 s | 462417 | 3286542 | 0 | 44336 | |
192.168.30.20 | show_fields | 7232 | 7.32 s | 9.93 ms | 3.00 s | 250932 | 1282700 | 0 | 0 | |
192.168.30.20 | show_keys | 8175 | 7.09 s | 107.10 ms | 3.26 s | 8316 | 129922 | 0 | 0 | |
192.168.30.20 | show_variables | 6224 | 6.35 s | 666.19 ms | 551.06 ms | 7320 | 3571442 | 0 | 6224 | |
192.168.30.20 | show_tables | 6985 | 2.61 s | 4.87 ms | 1.31 s | 85703 | 247809 | 0 | 0 | |
192.168.30.20 | create_table | 6 | 2.10 s | 1.17 s | 8.50 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | insert | 32 | 978.21 ms | 46.67 ms | 2.32 ms | 0 | 0 | 30 | 0 | |
192.168.30.20 | show_create_table | 3654 | 777.00 ms | 4.32 ms | 563.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | set_option | 14642 | 634.27 ms | 3.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 9 | 464.71 ms | 86.07 ms | 5.70 ms | 0 | 0 | 8 | 0 | |
192.168.30.20 | Init DB | 8328 | 448.45 ms | 1.12 ms | 86.82 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 1980 | 158.69 ms | 570.61 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 145762 | 107.27 ms | 2.48 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 2929 | 94.02 ms | 1.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 9752 | 63.02 ms | 558.25 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 140 | 49.85 ms | 1.85 ms | 29.97 ms | 103 | 873 | 0 | 0 | |
192.168.30.20 | freturn | 36528 | 43.25 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 102 | 28.91 ms | 15.05 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_status | 2 | 25.48 ms | 24.98 ms | 242.00 us | 900 | 900 | 0 | 2 | |
192.168.30.20 | show_create_proc | 54 | 13.92 ms | 2.78 ms | 4.20 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 44 | 6.54 ms | 533.96 us | 1.08 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 48 | 5.06 ms | 473.65 us | 2.69 ms | 432 | 432 | 0 | 48 | |
192.168.30.20 | Prepare | 18 | 4.63 ms | 2.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 45 | 4.59 ms | 2.44 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 67 | 4.19 ms | 1.79 ms | 0 ps | 0 | 0 | 0 | 0 |
|