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 | 102065 | 41.48 s | 221.14 ms | 13.78 s | 254756 | 2088755 | 0 | 41060 | |
192.168.30.20 | show_fields | 7870 | 8.22 s | 5.97 ms | 2.99 s | 371523 | 1887980 | 0 | 0 | |
192.168.30.20 | show_variables | 7166 | 6.07 s | 7.15 ms | 644.45 ms | 7146 | 4112045 | 0 | 7166 | |
192.168.30.20 | show_keys | 5933 | 5.28 s | 105.90 ms | 2.13 s | 8354 | 142763 | 0 | 0 | |
192.168.30.20 | drop_db | 26 | 4.97 s | 1.11 s | 22.82 ms | 0 | 0 | 68 | 0 | |
192.168.30.20 | show_tables | 6616 | 2.78 s | 232.58 ms | 1.46 s | 54815 | 200879 | 0 | 0 | |
192.168.30.20 | set_option | 15114 | 894.47 ms | 26.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 3942 | 759.43 ms | 2.79 ms | 68.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 9010 | 596.53 ms | 1.52 ms | 131.45 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 516 | 406.89 ms | 334.80 ms | 41.40 ms | 33 | 274 | 0 | 0 | |
192.168.30.20 | show_grants | 3281 | 255.65 ms | 826.25 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 4 | 220.23 ms | 67.40 ms | 3.02 ms | 0 | 0 | 4 | 0 | |
192.168.30.20 | show_warnings | 3446 | 100.46 ms | 191.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 10075 | 65.05 ms | 522.88 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 48714 | 34.70 ms | 738.87 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 8338 | 14.47 ms | 6.28 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 168 | 12.45 ms | 1.88 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 54 | 6.83 ms | 1.85 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 54 | 6.05 ms | 368.94 us | 1.90 ms | 10 | 100 | 0 | 45 | |
192.168.30.20 | set | 164 | 5.75 ms | 592.71 us | 0 ps | 0 | 32 | 0 | 0 | |
192.168.30.20 | error | 25 | 4.14 ms | 3.28 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 33 | 3.68 ms | 275.08 us | 1.84 ms | 297 | 297 | 0 | 33 | |
192.168.30.20 | show_slave_status | 32 | 1.66 ms | 87.15 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 7 | 1.58 ms | 627.56 us | 0 ps | 0 | 7 | 0 | 0 | |
192.168.30.20 | show_master_status | 32 | 1.56 ms | 583.80 us | 0 ps | 0 | 0 | 0 | 0 |
|