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 | 17845 | 7189018180000 | 253471353000 | 2219691000000 | 74346 | 412809 | 0 | 5802 | |
192.168.30.20 | show_keys | 670 | 1277720918000 | 83254877000 | 223194000000 | 1056 | 12709 | 0 | 0 | |
192.168.30.20 | show_fields | 887 | 808878519000 | 2824813000 | 308252000000 | 38003 | 193226 | 0 | 0 | |
192.168.30.20 | show_variables | 876 | 725115679000 | 5583985000 | 80212000000 | 876 | 502719 | 0 | 876 | |
192.168.30.20 | show_table_status | 130 | 594789775000 | 568437353000 | 14240000000 | 107 | 738 | 0 | 0 | |
192.168.30.20 | show_tables | 968 | 355256227000 | 3356534000 | 167435000000 | 3295 | 12379 | 0 | 0 | |
192.168.30.20 | set_option | 2262 | 220461177000 | 8257182000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 1380 | 139688447000 | 597153000 | 37298000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 436 | 72364737000 | 724334000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_grants | 647 | 50855872000 | 276115000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_binlogs | 57 | 15669629000 | 12486444000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 407 | 11812718000 | 58568000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 1507 | 11461480000 | 413821000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 33 | 3220139000 | 256520000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 33 | 2624868000 | 489408000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Prepare | 3 | 2497775000 | 2093710000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 898 | 2377890000 | 361109000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 772 | 1974219000 | 406495000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | error | 35 | 1896893000 | 430407000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 6 | 847824000 | 390378000 | 428000000 | 54 | 54 | 0 | 6 | |
192.168.30.20 | Execute | 3 | 827827000 | 373483000 | 175000000 | 0 | 6 | 0 | 3 | |
192.168.30.20 | stmt | 1 | 624493000 | 624493000 | 0 | 0 | 1 | 0 | 0 | |
192.168.30.20 | set | 2 | 593515000 | 591939000 | 0 | 0 | 1 | 0 | 0 | |
192.168.30.20 | Close stmt | 3 | 40163000 | 28352000 | 0 | 0 | 0 | 0 | 0 | |
background | select | 1 | 723705000 | 723705000 | 0 | 1 | 1 | 0 | 0 |
|