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 | 103505 | 42.06 s | 221.14 ms | 13.97 s | 258538 | 2127951 | 0 | 41625 | |
192.168.30.20 | show_fields | 7980 | 8.33 s | 5.97 ms | 3.03 s | 376372 | 1912649 | 0 | 0 | |
192.168.30.20 | show_variables | 7271 | 6.15 s | 7.15 ms | 653.53 ms | 7251 | 4172315 | 0 | 7271 | |
192.168.30.20 | show_keys | 6025 | 5.33 s | 105.90 ms | 2.16 s | 8465 | 144856 | 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 | 6710 | 2.82 s | 232.58 ms | 1.48 s | 55549 | 203157 | 0 | 0 | |
192.168.30.20 | set_option | 15329 | 906.47 ms | 26.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 3997 | 768.83 ms | 2.79 ms | 68.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 9136 | 604.79 ms | 1.52 ms | 133.43 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 519 | 407.19 ms | 334.80 ms | 41.56 ms | 33 | 274 | 0 | 0 | |
192.168.30.20 | show_grants | 3330 | 259.46 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 | 3496 | 101.90 ms | 191.96 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 10221 | 65.94 ms | 522.88 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 50164 | 35.49 ms | 738.87 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 8513 | 14.60 ms | 6.28 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 172 | 12.68 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 | 26 | 4.17 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 |
|