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 | 81100 | 34.87 s | 525.15 ms | 10.38 s | 279901 | 2227625 | 0 | 37793 | |
192.168.30.20 | show_fields | 6722 | 7.11 s | 6.87 ms | 2.54 s | 348943 | 1771109 | 0 | 0 | |
192.168.30.20 | show_variables | 6176 | 5.36 s | 10.47 ms | 546.60 ms | 6173 | 3544058 | 0 | 6176 | |
192.168.30.20 | show_keys | 4234 | 3.88 s | 96.05 ms | 1.52 s | 7777 | 128171 | 0 | 0 | |
192.168.30.20 | show_tables | 5783 | 2.27 s | 4.99 ms | 1.15 s | 37589 | 160825 | 0 | 0 | |
192.168.30.20 | set_option | 12721 | 750.02 ms | 7.06 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 3377 | 655.13 ms | 3.79 ms | 226.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 7854 | 531.79 ms | 2.17 ms | 116.02 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_table | 2 | 328.49 ms | 171.76 ms | 2.63 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 4 | 235.94 ms | 70.61 ms | 4.65 ms | 0 | 0 | 4 | 0 | |
192.168.30.20 | show_grants | 2851 | 215.10 ms | 1.07 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 2982 | 88.04 ms | 722.28 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 83 | 65.12 ms | 3.25 ms | 40.65 ms | 134 | 1054 | 0 | 0 | |
192.168.30.20 | Quit | 8541 | 57.74 ms | 291.25 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 16 | 7.42 ms | 5.97 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 35 | 6.65 ms | 2.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 4 | 5.46 ms | 4.47 ms | 2.42 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 58 | 4.07 ms | 444.59 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_proc | 3 | 3.69 ms | 3.37 ms | 2.66 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 58 | 2.71 ms | 359.36 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 3 | 2.09 ms | 1.25 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 15 | 1.78 ms | 533.00 us | 635.00 us | 135 | 135 | 0 | 15 | |
192.168.30.20 | Execute | 3 | 360.84 us | 139.97 us | 81.00 us | 1 | 7 | 0 | 3 | |
192.168.30.20 | freturn | 2 | 300.81 us | 294.65 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 10 | 232.48 us | 210.78 us | 0 ps | 0 | 0 | 0 | 0 |
|