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 | 159248 | 1.77 m | 1.48 s | 23.51 s | 561273 | 4012319 | 0 | 53021 | |
192.168.30.20 | show_fields | 8830 | 8.95 s | 9.93 ms | 3.66 s | 307686 | 1572632 | 0 | 0 | |
192.168.30.20 | show_keys | 9950 | 8.41 s | 107.10 ms | 3.97 s | 10176 | 158544 | 0 | 0 | |
192.168.30.20 | show_variables | 7597 | 7.60 s | 666.19 ms | 673.86 ms | 8693 | 4359418 | 0 | 7597 | |
192.168.30.20 | show_tables | 8407 | 3.16 s | 4.87 ms | 1.59 s | 103462 | 298596 | 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 | 36 | 982.00 ms | 46.67 ms | 4.30 ms | 0 | 0 | 30 | 0 | |
192.168.30.20 | show_create_table | 4461 | 956.04 ms | 5.55 ms | 637.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | set_option | 17637 | 772.58 ms | 3.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 12 | 629.37 ms | 86.07 ms | 5.96 ms | 0 | 0 | 11 | 0 | |
192.168.30.20 | Init DB | 10050 | 544.76 ms | 1.12 ms | 105.19 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 2400 | 194.23 ms | 1.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 165345 | 121.89 ms | 2.48 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 3586 | 115.84 ms | 1.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 11746 | 74.84 ms | 558.25 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 190 | 66.32 ms | 1.85 ms | 40.86 ms | 103 | 970 | 0 | 0 | |
192.168.30.20 | freturn | 41127 | 48.04 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 110 | 29.40 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 | 54 | 5.57 ms | 473.65 us | 2.95 ms | 486 | 486 | 0 | 54 | |
192.168.30.20 | Prepare | 24 | 5.50 ms | 2.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 81 | 4.79 ms | 645.17 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 49 | 4.72 ms | 2.44 ms | 0 ps | 0 | 0 | 0 | 0 |
|