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 | 11451 | 5.71 s | 532.73 ms | 1.45 s | 51276 | 398685 | 0 | 4523 | |
192.168.30.20 | show_keys | 635 | 1.14 s | 107.50 ms | 227.29 ms | 912 | 13251 | 0 | 0 | |
192.168.30.20 | show_fields | 795 | 755.83 ms | 3.41 ms | 295.92 ms | 32512 | 165624 | 0 | 0 | |
192.168.30.20 | show_variables | 767 | 683.89 ms | 4.42 ms | 71.48 ms | 767 | 440195 | 0 | 767 | |
192.168.30.20 | show_tables | 758 | 260.01 ms | 3.08 ms | 123.18 ms | 2868 | 10952 | 0 | 0 | |
192.168.30.20 | alter_table | 5 | 239.27 ms | 55.73 ms | 1.30 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | set_option | 1861 | 150.87 ms | 5.98 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 1087 | 89.36 ms | 344.18 us | 22.41 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 395 | 79.37 ms | 11.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 1 | 70.88 ms | 70.88 ms | 58.00 us | 0 | 0 | 1 | 0 | |
192.168.30.20 | alter_db | 1 | 36.76 ms | 36.76 ms | 288.00 us | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_grants | 388 | 27.92 ms | 271.42 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 342 | 10.30 ms | 121.05 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 1240 | 8.86 ms | 206.08 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 13 | 4.16 ms | 764.37 us | 2.92 ms | 0 | 10 | 0 | 0 | |
192.168.30.20 | show_binlog_events | 4 | 3.70 ms | 3.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 33 | 2.63 ms | 704.40 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 17 | 1.35 ms | 258.80 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 17 | 1.21 ms | 281.53 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 15 | 1.21 ms | 391.67 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 8 | 1.07 ms | 302.61 us | 497.00 us | 72 | 72 | 0 | 8 | |
background | select | 1 | 1.05 ms | 1.05 ms | 0 ps | 1 | 1 | 0 | 0 |
|