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 | 39554 | 22.43 s | 1.36 s | 5.04 s | 124209 | 940610 | 0 | 12911 | |
192.168.30.20 | show_keys | 2307 | 3.22 s | 172.50 ms | 859.74 ms | 2290 | 35965 | 0 | 0 | |
192.168.30.20 | show_fields | 2021 | 1.86 s | 7.02 ms | 767.69 ms | 68017 | 347920 | 0 | 0 | |
192.168.30.20 | show_variables | 1700 | 1.52 s | 14.59 ms | 148.65 ms | 1700 | 975632 | 0 | 1700 | |
192.168.30.20 | show_tables | 1977 | 880.46 ms | 13.85 ms | 440.93 ms | 21780 | 59975 | 0 | 0 | |
192.168.30.20 | set_option | 3910 | 254.33 ms | 6.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 22 | 219.42 ms | 208.38 ms | 7.56 ms | 23 | 188 | 0 | 0 | |
192.168.30.20 | show_create_table | 1034 | 208.83 ms | 6.63 ms | 87.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 2342 | 156.11 ms | 938.19 us | 34.76 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 976 | 72.79 ms | 322.60 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 1 | 53.77 ms | 53.77 ms | 710.00 us | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_warnings | 821 | 24.84 ms | 144.09 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 37989 | 24.02 ms | 592.60 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 2624 | 17.10 ms | 192.80 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 10662 | 11.97 ms | 336.54 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 33 | 11.10 ms | 2.95 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 8 | 7.26 ms | 5.76 ms | 6.34 ms | 72 | 72 | 0 | 8 | |
192.168.30.20 | Prepare | 4 | 2.98 ms | 1.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 4 | 2.11 ms | 926.79 us | 593.00 us | 0 | 8 | 0 | 4 | |
192.168.30.20 | show_slave_status | 8 | 1.57 ms | 789.65 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 1 | 1.18 ms | 1.18 ms | 0 ps | 0 | 1 | 0 | 0 | |
192.168.30.20 | set | 2 | 1.15 ms | 1.15 ms | 0 ps | 0 | 1 | 0 | 0 | |
192.168.30.20 | show_master_status | 8 | 877.50 us | 535.79 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 2 | 83.39 us | 44.01 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 4 | 44.53 us | 23.18 us | 0 ps | 0 | 0 | 0 | 0 |
|