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 | 158144 | 1.75 m | 1.48 s | 23.35 s | 556975 | 3981064 | 0 | 52697 | |
192.168.30.20 | show_fields | 8748 | 8.86 s | 9.93 ms | 3.63 s | 304789 | 1557819 | 0 | 0 | |
192.168.30.20 | show_keys | 9876 | 8.36 s | 107.10 ms | 3.95 s | 10085 | 157126 | 0 | 0 | |
192.168.30.20 | show_variables | 7527 | 7.53 s | 666.19 ms | 666.91 ms | 8623 | 4319259 | 0 | 7527 | |
192.168.30.20 | show_tables | 8339 | 3.13 s | 4.87 ms | 1.58 s | 102709 | 296327 | 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 | 4421 | 947.43 ms | 5.55 ms | 637.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | set_option | 17487 | 765.94 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 | 9966 | 540.05 ms | 1.12 ms | 104.31 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 2378 | 192.54 ms | 1.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 164807 | 121.62 ms | 2.48 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 3551 | 114.74 ms | 1.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 11646 | 74.27 ms | 558.25 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 187 | 65.99 ms | 1.85 ms | 40.68 ms | 103 | 970 | 0 | 0 | |
192.168.30.20 | freturn | 41052 | 47.94 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 | Prepare | 24 | 5.50 ms | 2.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 53 | 5.48 ms | 473.65 us | 2.90 ms | 477 | 477 | 0 | 53 | |
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 |
|