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 | 88940 | 29.52 s | 381.62 ms | 11.79 s | 210696 | 1471444 | 0 | 14238 | |
192.168.30.20 | create_table | 10 | 2.92 s | 952.14 ms | 6.06 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_keys | 1204 | 2.07 s | 104.42 ms | 452.00 ms | 1396 | 19643 | 0 | 0 | |
192.168.30.20 | show_variables | 1450 | 1.41 s | 36.05 ms | 130.26 ms | 1449 | 831082 | 0 | 1450 | |
192.168.30.20 | show_fields | 1341 | 1.27 s | 5.04 ms | 519.59 ms | 48657 | 248247 | 0 | 0 | |
192.168.30.20 | show_tables | 2851 | 1.11 s | 5.51 ms | 602.84 ms | 7129 | 21299 | 0 | 0 | |
192.168.30.20 | set_option | 5187 | 427.96 ms | 16.05 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 6 | 313.15 ms | 87.57 ms | 654.00 us | 0 | 0 | 6 | 0 | |
192.168.30.20 | Init DB | 3286 | 302.07 ms | 421.03 us | 76.18 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 664 | 122.97 ms | 2.02 ms | 1.29 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 1431 | 122.32 ms | 339.56 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 138 | 75.75 ms | 4.93 ms | 50.48 ms | 0 | 116 | 0 | 0 | |
192.168.30.20 | insert | 2 | 42.69 ms | 40.03 ms | 1.05 ms | 0 | 0 | 2 | 0 | |
192.168.30.20 | show_binlogs | 71 | 38.42 ms | 17.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 3622 | 28.76 ms | 244.73 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 587 | 18.33 ms | 239.62 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 21754 | 16.23 ms | 288.99 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 68 | 11.09 ms | 3.88 ms | 1.12 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_proc | 80 | 10.76 ms | 1.39 ms | 1.63 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 8251 | 8.61 ms | 1.88 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 42 | 8.06 ms | 1.51 ms | 4.12 ms | 378 | 378 | 0 | 42 | |
192.168.30.20 | show_slave_status | 68 | 6.00 ms | 456.84 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 9 | 5.09 ms | 3.97 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 68 | 4.92 ms | 1.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 16 | 4.23 ms | 2.29 ms | 0 ps | 0 | 16 | 0 | 0 |
|