SELECT * FROM `x$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 | 21742 | 8339747130000 | 117088609000 | 2953135000000 | 58459 | 623697 | 0 | 7906 | |
192.168.30.20 | show_fields | 1164 | 1227877685000 | 4292613000 | 446221000000 | 57122 | 289931 | 0 | 0 | |
192.168.30.20 | show_variables | 1102 | 1018148892000 | 6843194000 | 99550000000 | 2227 | 632506 | 0 | 1102 | |
192.168.30.20 | show_keys | 909 | 898556003000 | 69961058000 | 337260000000 | 1207 | 18932 | 0 | 0 | |
192.168.30.20 | show_tables | 1017 | 365857822000 | 5606695000 | 171882000000 | 8898 | 27816 | 0 | 0 | |
192.168.30.20 | set_option | 2364 | 133573766000 | 5046648000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 582 | 125263820000 | 4221947000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 1408 | 93269259000 | 1967922000 | 23636000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 557 | 45150051000 | 1558269000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 137 | 17943732000 | 937153000 | 9603000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 530 | 16644375000 | 215587000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 1570 | 10063012000 | 209357000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 2667 | 3061837000 | 228823000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 16 | 2471659000 | 1086696000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 441 | 2320698000 | 742761000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 1 | 2018406000 | 2018406000 | 1958000000 | 9 | 9 | 0 | 1 | |
192.168.30.20 | Execute | 16 | 1517644000 | 144612000 | 448000000 | 0 | 32 | 0 | 16 | |
192.168.30.20 | show_binlogs | 21 | 1432262000 | 170328000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 3 | 1050858000 | 567736000 | 343000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 3 | 782656000 | 650716000 | 0 | 0 | 3 | 0 | 0 | |
192.168.30.20 | set | 6 | 713784000 | 618603000 | 0 | 0 | 3 | 0 | 0 | |
192.168.30.20 | error | 10 | 465099000 | 60666000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 16 | 143962000 | 20486000 | 0 | 0 | 0 | 0 | 0 | |
background | select | 1 | 1227064000 | 1227064000 | 0 | 1 | 1 | 0 | 0 |
|