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 | 15635 | 13.82 s | 1.11 s | 2.21 s | 130632 | 790471 | 0 | 7734 | |
192.168.30.20 | show_keys | 695 | 1.72 s | 104.05 ms | 291.67 ms | 797 | 10271 | 0 | 0 | |
192.168.30.20 | create_table | 4 | 873.71 ms | 251.89 ms | 8.01 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_fields | 844 | 849.92 ms | 4.83 ms | 363.45 ms | 20725 | 106787 | 0 | 0 | |
192.168.30.20 | show_variables | 631 | 607.81 ms | 5.02 ms | 59.85 ms | 628 | 361501 | 0 | 631 | |
192.168.30.20 | show_tables | 1528 | 547.64 ms | 4.94 ms | 279.25 ms | 3940 | 14524 | 0 | 0 | |
192.168.30.20 | set_option | 3344 | 277.77 ms | 6.59 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 1900 | 184.43 ms | 451.97 us | 48.17 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 2 | 147.75 ms | 81.50 ms | 3.12 ms | 0 | 0 | 2 | 0 | |
192.168.30.20 | grant | 4 | 125.93 ms | 41.72 ms | 1.53 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 399 | 99.92 ms | 10.76 ms | 1.50 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | alter_user | 3 | 81.53 ms | 43.58 ms | 2.25 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 816 | 71.44 ms | 411.46 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 37 | 44.72 ms | 16.37 ms | 18.72 ms | 12 | 115 | 0 | 0 | |
192.168.30.20 | create_user | 1 | 37.87 ms | 37.87 ms | 3.36 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 62628 | 35.17 ms | 2.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | revoke_all | 1 | 31.03 ms | 31.03 ms | 379.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 16018 | 17.69 ms | 1.87 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 2231 | 17.33 ms | 178.36 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 124 | 16.73 ms | 412.15 us | 8.19 ms | 1116 | 1116 | 0 | 124 | |
192.168.30.20 | show_binlogs | 119 | 9.41 ms | 1.89 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 212 | 7.16 ms | 145.62 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 43 | 5.05 ms | 2.78 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 20 | 4.85 ms | 1.86 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | revoke | 1 | 3.81 ms | 3.81 ms | 153.00 us | 0 | 0 | 0 | 0 |
|