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 | 27567 | 15.28 s | 917.25 ms | 3.92 s | 126639 | 1202951 | 0 | 10073 | |
192.168.30.20 | show_keys | 1087 | 1.12 s | 77.91 ms | 395.70 ms | 1090 | 17731 | 0 | 0 | |
192.168.30.20 | show_fields | 1232 | 1.12 s | 5.06 ms | 462.44 ms | 45479 | 231886 | 0 | 0 | |
192.168.30.20 | show_variables | 1151 | 1.02 s | 8.47 ms | 106.96 ms | 1150 | 659666 | 0 | 1151 | |
192.168.30.20 | show_tables | 1883 | 641.97 ms | 3.40 ms | 314.25 ms | 6892 | 17973 | 0 | 0 | |
192.168.30.20 | set_option | 4176 | 321.22 ms | 6.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 2587 | 303.72 ms | 59.10 ms | 124.35 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 554 | 214.89 ms | 107.41 ms | 273.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 3 | 168.12 ms | 63.52 ms | 277.00 us | 0 | 0 | 3 | 0 | |
192.168.30.20 | grant | 2 | 94.13 ms | 60.94 ms | 648.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 1061 | 94.07 ms | 2.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | alter_db | 1 | 66.00 ms | 66.00 ms | 2.17 ms | 0 | 0 | 1 | 0 | |
192.168.30.20 | show_table_status | 355 | 61.00 ms | 2.81 ms | 36.09 ms | 0 | 109 | 0 | 0 | |
192.168.30.20 | create_user | 1 | 43.91 ms | 43.91 ms | 7.42 ms | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 62182 | 38.14 ms | 406.04 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | alter_user | 1 | 24.15 ms | 24.15 ms | 246.00 us | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 16076 | 23.00 ms | 2.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 2863 | 21.70 ms | 703.69 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 486 | 14.60 ms | 112.38 us | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 24 | 10.74 ms | 6.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 108 | 8.96 ms | 1.43 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 39 | 8.33 ms | 4.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
192.168.30.20 | set | 156 | 5.97 ms | 784.81 us | 0 ps | 0 | 28 | 0 | 0 | |
192.168.30.20 | Execute | 24 | 5.83 ms | 1.84 ms | 2.74 ms | 0 | 48 | 0 | 24 | |
192.168.30.20 | show_storage_engines | 45 | 4.68 ms | 357.42 us | 2.05 ms | 405 | 405 | 0 | 45 |
|