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 | 8344 | 4.80 s | 537.66 ms | 1.02 s | 37633 | 397884 | 0 | 4022 | |
192.168.30.20 | show_keys | 371 | 2.61 s | 116.20 ms | 140.83 ms | 558 | 6373 | 0 | 0 | |
192.168.30.20 | show_variables | 422 | 359.57 ms | 7.41 ms | 38.81 ms | 974 | 241724 | 0 | 422 | |
192.168.30.20 | show_tables | 875 | 349.94 ms | 2.76 ms | 197.01 ms | 1798 | 8228 | 0 | 0 | |
192.168.30.20 | show_fields | 395 | 300.60 ms | 3.97 ms | 134.24 ms | 7674 | 40078 | 0 | 0 | |
192.168.30.20 | set_option | 1243 | 99.32 ms | 8.65 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 243 | 81.01 ms | 16.41 ms | 2.84 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 1013 | 73.44 ms | 341.98 us | 17.19 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 460 | 37.01 ms | 258.12 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 1057 | 8.21 ms | 214.81 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_proc | 3 | 7.89 ms | 7.55 ms | 269.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_status | 1 | 5.40 ms | 5.40 ms | 116.00 us | 450 | 450 | 0 | 1 | |
192.168.30.20 | show_table_status | 8 | 4.90 ms | 1.06 ms | 3.40 ms | 0 | 14 | 0 | 0 | |
192.168.30.20 | show_warnings | 150 | 4.53 ms | 157.37 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 26 | 1.39 ms | 63.81 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 20 | 1.24 ms | 188.47 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 3 | 1.02 ms | 585.17 us | 591.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 20 | 1.01 ms | 127.66 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 1 | 972.81 us | 972.81 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 13 | 859.28 us | 469.40 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 1 | 419.70 us | 419.70 us | 51.00 us | 0 | 2 | 0 | 1 | |
192.168.30.20 | freturn | 30 | 367.64 us | 324.27 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 4 | 357.86 us | 131.98 us | 171.00 us | 36 | 36 | 0 | 4 | |
192.168.30.20 | jump_if_not | 188 | 127.58 us | 5.24 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 1 | 21.55 us | 21.55 us | 0 ps | 0 | 0 | 0 | 0 |
|