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 | 21902 | 9.44 s | 511.19 ms | 2.75 s | 101640 | 600919 | 0 | 9592 | |
192.168.30.20 | show_keys | 1036 | 1.43 s | 145.64 ms | 359.89 ms | 1473 | 24376 | 0 | 0 | |
192.168.30.20 | show_fields | 1402 | 1.35 s | 20.28 ms | 508.38 ms | 59501 | 302971 | 0 | 0 | |
192.168.30.20 | show_variables | 1535 | 1.33 s | 6.65 ms | 139.80 ms | 1534 | 880901 | 0 | 1535 | |
192.168.30.20 | show_tables | 1783 | 612.59 ms | 4.19 ms | 291.52 ms | 6116 | 21628 | 0 | 0 | |
192.168.30.20 | create_table | 2 | 385.05 ms | 192.63 ms | 3.22 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | set_option | 4318 | 337.56 ms | 6.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 2386 | 209.53 ms | 369.44 us | 54.92 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 697 | 121.11 ms | 2.08 ms | 68.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | insert | 2 | 69.54 ms | 40.07 ms | 2.02 ms | 0 | 0 | 2 | 0 | |
192.168.30.20 | show_grants | 848 | 66.12 ms | 1.46 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 1 | 54.27 ms | 54.27 ms | 468.00 us | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_binlogs | 98 | 20.60 ms | 14.70 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 2879 | 20.06 ms | 219.40 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 657 | 19.95 ms | 323.65 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 79 | 19.69 ms | 2.15 ms | 12.16 ms | 1 | 31 | 0 | 0 | |
192.168.30.20 | Prepare | 15 | 7.20 ms | 2.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 15 | 5.38 ms | 815.41 us | 1.55 ms | 9 | 21 | 0 | 6 | |
192.168.30.20 | show_slave_status | 19 | 3.12 ms | 1.50 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 18 | 2.55 ms | 1.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 19 | 1.97 ms | 827.87 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 7 | 1.22 ms | 464.21 us | 765.00 us | 63 | 63 | 0 | 7 | |
192.168.30.20 | Close stmt | 15 | 331.37 us | 43.95 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 30 | 204.83 us | 162.36 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 188 | 135.79 us | 7.24 us | 0 ps | 0 | 0 | 0 | 0 |
|