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 | 17186 | 9.85 s | 604.72 ms | 2.53 s | 105253 | 645697 | 0 | 8792 | |
192.168.30.20 | alter_table | 9 | 3.76 s | 630.07 ms | 2.32 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_keys | 630 | 2.13 s | 100.48 ms | 240.90 ms | 997 | 12023 | 0 | 0 | |
192.168.30.20 | create_table | 9 | 1.88 s | 319.65 ms | 8.30 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_variables | 1022 | 956.29 ms | 6.59 ms | 95.08 ms | 2694 | 585914 | 0 | 1022 | |
192.168.30.20 | show_fields | 833 | 773.86 ms | 4.78 ms | 324.91 ms | 27685 | 141661 | 0 | 0 | |
192.168.30.20 | show_tables | 1741 | 564.65 ms | 6.21 ms | 285.87 ms | 3084 | 10748 | 0 | 0 | |
192.168.30.20 | set_option | 3428 | 309.90 ms | 7.57 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 2255 | 217.18 ms | 584.54 us | 57.47 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 4 | 111.12 ms | 57.64 ms | 861.00 us | 0 | 0 | 2 | 0 | |
192.168.30.20 | insert | 2 | 90.36 ms | 69.55 ms | 2.76 ms | 0 | 0 | 3 | 0 | |
192.168.30.20 | show_grants | 949 | 79.53 ms | 299.70 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 445 | 77.01 ms | 1.58 ms | 125.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 96 | 28.31 ms | 2.27 ms | 18.50 ms | 1 | 36 | 0 | 0 | |
192.168.30.20 | Quit | 2364 | 18.52 ms | 252.63 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 100 | 13.83 ms | 6.29 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 371 | 13.35 ms | 202.35 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 28 | 4.21 ms | 461.01 us | 2.00 ms | 252 | 252 | 0 | 28 | |
192.168.30.20 | show_slave_status | 32 | 3.79 ms | 321.06 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_proc | 2 | 3.25 ms | 3.00 ms | 807.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 2 | 3.05 ms | 2.72 ms | 455.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 32 | 2.91 ms | 324.70 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 58 | 2.84 ms | 384.14 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 14 | 2.26 ms | 354.26 us | 718.00 us | 9 | 19 | 0 | 5 | |
192.168.30.20 | Prepare | 14 | 2.16 ms | 499.90 us | 0 ps | 0 | 0 | 0 | 0 |
|