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 | 13277 | 8.00 s | 550.57 ms | 1.75 s | 133788 | 535556 | 0 | 6576 | |
192.168.30.20 | alter_table | 3 | 1.57 s | 543.73 ms | 5.26 ms | 0 | 0 | 988 | 0 | |
192.168.30.20 | show_keys | 499 | 1.46 s | 77.59 ms | 197.25 ms | 773 | 8921 | 0 | 0 | |
192.168.30.20 | show_fields | 752 | 800.44 ms | 4.56 ms | 318.05 ms | 25256 | 129218 | 0 | 0 | |
192.168.30.20 | show_variables | 781 | 738.39 ms | 5.32 ms | 71.65 ms | 1906 | 447790 | 0 | 781 | |
192.168.30.20 | create_table | 3 | 716.97 ms | 274.71 ms | 1.01 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_tables | 1452 | 509.94 ms | 3.37 ms | 241.40 ms | 2722 | 10188 | 0 | 0 | |
192.168.30.20 | insert | 3 | 338.53 ms | 144.98 ms | 3.39 ms | 0 | 0 | 1309 | 0 | |
192.168.30.20 | set_option | 3134 | 264.61 ms | 5.73 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 1768 | 177.19 ms | 717.45 us | 48.44 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 2 | 107.39 ms | 61.93 ms | 1.12 ms | 0 | 0 | 2 | 0 | |
192.168.30.20 | create_view | 1 | 75.97 ms | 75.97 ms | 569.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 312 | 56.14 ms | 1.49 ms | 85.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 566 | 47.42 ms | 348.20 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_user | 1 | 28.11 ms | 28.11 ms | 1.21 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | grant | 1 | 28.00 ms | 28.00 ms | 593.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 108 | 26.39 ms | 2.47 ms | 15.91 ms | 11 | 87 | 0 | 0 | |
192.168.30.20 | Quit | 2076 | 16.27 ms | 211.25 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | alter_user | 1 | 15.21 ms | 15.21 ms | 1.02 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 20150 | 11.87 ms | 1.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 4294 | 9.68 ms | 3.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 288 | 9.41 ms | 255.57 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 14 | 5.62 ms | 2.83 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 32 | 4.39 ms | 375.71 us | 2.07 ms | 288 | 288 | 0 | 32 | |
192.168.30.20 | show_binlogs | 56 | 3.94 ms | 365.72 us | 0 ps | 0 | 0 | 0 | 0 |
|