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 | 67413 | 39.80 s | 1.36 s | 8.73 s | 220392 | 1655487 | 0 | 23058 | |
192.168.30.20 | show_keys | 4518 | 4.85 s | 172.50 ms | 1.63 s | 4235 | 69033 | 0 | 0 | |
192.168.30.20 | alter_table | 10 | 4.45 s | 561.46 ms | 1.28 ms | 0 | 0 | 4 | 0 | |
192.168.30.20 | show_fields | 3891 | 3.56 s | 7.02 ms | 1.47 s | 128954 | 659862 | 0 | 0 | |
192.168.30.20 | show_variables | 3212 | 2.88 s | 14.59 ms | 282.13 ms | 3210 | 1843331 | 0 | 3212 | |
192.168.30.20 | create_table | 8 | 1.68 s | 302.13 ms | 4.06 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_tables | 3496 | 1.60 s | 13.85 ms | 797.08 ms | 39875 | 112792 | 0 | 0 | |
192.168.30.20 | show_create_table | 1877 | 479.44 ms | 49.08 ms | 255.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | set_option | 6947 | 435.85 ms | 6.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | insert | 8 | 298.30 ms | 65.02 ms | 3.02 ms | 0 | 0 | 58 | 0 | |
192.168.30.20 | Init DB | 4225 | 276.24 ms | 938.19 us | 58.52 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 47 | 251.56 ms | 208.38 ms | 12.06 ms | 37 | 272 | 0 | 0 | |
192.168.30.20 | show_grants | 1611 | 121.19 ms | 623.91 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 1 | 53.77 ms | 53.77 ms | 710.00 us | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_warnings | 1529 | 48.35 ms | 466.84 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 54099 | 37.00 ms | 592.60 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 4693 | 31.58 ms | 1.18 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 14561 | 16.22 ms | 336.54 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 61 | 12.87 ms | 2.95 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 12 | 7.80 ms | 5.76 ms | 6.61 ms | 108 | 108 | 0 | 12 | |
192.168.30.20 | Prepare | 7 | 3.66 ms | 1.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 7 | 2.42 ms | 926.79 us | 673.00 us | 0 | 14 | 0 | 7 | |
192.168.30.20 | show_slave_status | 18 | 2.19 ms | 789.65 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 18 | 1.30 ms | 535.79 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 1 | 1.18 ms | 1.18 ms | 0 ps | 0 | 1 | 0 | 0 |
|