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 | 225084 | 1.50 m | 387.50 ms | 34.60 s | 409099 | 2900743 | 0 | 29352 | |
192.168.30.20 | show_fields | 3957 | 4.35 s | 34.76 ms | 1.83 s | 143528 | 731334 | 0 | 0 | |
192.168.30.20 | show_variables | 3782 | 4.20 s | 89.39 ms | 536.14 ms | 4334 | 2170028 | 0 | 3782 | |
192.168.30.20 | show_keys | 4488 | 3.32 s | 36.06 ms | 1.90 s | 3657 | 46517 | 0 | 0 | |
192.168.30.20 | show_tables | 3801 | 1.78 s | 27.74 ms | 954.44 ms | 20560 | 54066 | 0 | 0 | |
192.168.30.20 | set_option | 8501 | 602.19 ms | 7.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 1993 | 558.38 ms | 14.77 ms | 515.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_table | 2 | 500.97 ms | 299.88 ms | 5.10 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 5361 | 438.41 ms | 15.00 ms | 94.30 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 1667 | 215.64 ms | 8.18 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 3 | 139.55 ms | 51.39 ms | 1.54 ms | 0 | 0 | 3 | 0 | |
192.168.30.20 | insert | 2 | 95.44 ms | 52.51 ms | 7.06 ms | 0 | 0 | 2 | 0 | |
192.168.30.20 | show_binlogs | 73 | 92.50 ms | 45.79 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 1782 | 70.98 ms | 4.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 116 | 50.62 ms | 4.78 ms | 34.72 ms | 1 | 73 | 0 | 0 | |
192.168.30.20 | jump_if_not | 34373 | 39.85 ms | 1.88 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 5719 | 39.47 ms | 315.43 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 16887 | 36.78 ms | 9.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_proc | 107 | 28.32 ms | 5.79 ms | 5.05 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 92 | 22.23 ms | 9.35 ms | 4.25 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 21 | 19.18 ms | 13.78 ms | 0 ps | 0 | 21 | 0 | 0 | |
192.168.30.20 | set | 42 | 15.35 ms | 13.70 ms | 0 ps | 0 | 21 | 0 | 0 | |
192.168.30.20 | show_slave_status | 45 | 12.81 ms | 2.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 22 | 10.21 ms | 2.82 ms | 6.21 ms | 198 | 198 | 0 | 22 | |
192.168.30.20 | Prepare | 9 | 6.67 ms | 2.86 ms | 0 ps | 0 | 0 | 0 | 0 |
|