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 | 7155 | 3219412039000 | 117088609000 | 1078528000000 | 22390 | 250254 | 0 | 2931 | |
192.168.30.20 | show_fields | 447 | 498169910000 | 3394716000 | 177071000000 | 22335 | 113313 | 0 | 0 | |
192.168.30.20 | show_variables | 429 | 422604188000 | 6843194000 | 40240000000 | 429 | 246246 | 0 | 429 | |
192.168.30.20 | show_keys | 324 | 391852133000 | 53323061000 | 126115000000 | 474 | 6937 | 0 | 0 | |
192.168.30.20 | show_tables | 437 | 121911534000 | 2680145000 | 57409000000 | 3058 | 10046 | 0 | 0 | |
192.168.30.20 | set_option | 1012 | 53528110000 | 5046648000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 222 | 46390981000 | 1141830000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 604 | 37919166000 | 1967922000 | 10665000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 289 | 25488401000 | 1558269000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 68 | 9833684000 | 937153000 | 5302000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 204 | 6620889000 | 215587000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 670 | 4418165000 | 209357000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 1136 | 2122223000 | 228823000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 9 | 1999845000 | 1086696000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 189 | 1908968000 | 742761000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_func | 3 | 1050858000 | 567736000 | 343000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 12 | 943381000 | 170328000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Execute | 9 | 898776000 | 144612000 | 259000000 | 0 | 18 | 0 | 9 | |
192.168.30.20 | stmt | 1 | 650716000 | 650716000 | 0 | 0 | 1 | 0 | 0 | |
192.168.30.20 | set | 2 | 619692000 | 618603000 | 0 | 0 | 1 | 0 | 0 | |
192.168.30.20 | error | 8 | 369122000 | 60666000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Close stmt | 9 | 80186000 | 20486000 | 0 | 0 | 0 | 0 | 0 | |
background | select | 1 | 1227064000 | 1227064000 | 0 | 1 | 1 | 0 | 0 |
|