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 | 14289 | 6.00 s | 251.42 ms | 1.81 s | 76968 | 390162 | 0 | 5820 | |
192.168.30.20 | show_keys | 738 | 1.09 s | 89.18 ms | 251.91 ms | 1233 | 20436 | 0 | 0 | |
192.168.30.20 | show_fields | 1015 | 954.10 ms | 5.24 ms | 364.68 ms | 42610 | 217154 | 0 | 0 | |
192.168.30.20 | show_variables | 935 | 834.80 ms | 38.23 ms | 86.07 ms | 1487 | 536585 | 0 | 935 | |
192.168.30.20 | show_tables | 948 | 347.14 ms | 4.80 ms | 161.05 ms | 2954 | 13124 | 0 | 0 | |
192.168.30.20 | set_option | 2309 | 223.44 ms | 7.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 2 | 140.75 ms | 93.45 ms | 2.41 ms | 0 | 0 | 2 | 0 | |
192.168.30.20 | Init DB | 1396 | 125.65 ms | 432.23 us | 31.13 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 502 | 84.94 ms | 1.30 ms | 991.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 512 | 38.39 ms | 375.02 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 421 | 12.74 ms | 207.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 1553 | 11.20 ms | 249.63 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 20 | 7.93 ms | 2.16 ms | 5.40 ms | 0 | 15 | 0 | 0 | |
192.168.30.20 | show_status | 1 | 6.50 ms | 6.50 ms | 398.00 us | 450 | 450 | 0 | 1 | |
192.168.30.20 | Execute | 11 | 4.87 ms | 542.72 us | 1.66 ms | 9 | 13 | 0 | 2 | |
192.168.30.20 | show_binlogs | 76 | 4.28 ms | 116.85 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 11 | 3.69 ms | 694.68 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 16 | 3.42 ms | 477.39 us | 1.45 ms | 144 | 144 | 0 | 16 | |
192.168.30.20 | error | 4 | 2.18 ms | 1.83 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 14 | 1.37 ms | 243.69 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 14 | 1.10 ms | 305.17 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 105 | 817.02 us | 686.34 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 760 | 516.20 us | 11.03 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 11 | 344.18 us | 50.53 us | 0 ps | 0 | 0 | 0 | 0 | |
background | select | 1 | 418.78 us | 418.78 us | 0 ps | 1 | 1 | 0 | 0 |
|