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 | 128438 | 57077128936000 | 1004601167000 | 18005145000000 | 394343 | 3162498 | 0 | 35201 | |
192.168.30.20 | alter_table | 23 | 9597987819000 | 580765964000 | 31768000000 | 0 | 0 | 56 | 0 | |
192.168.30.20 | show_fields | 6073 | 6130953862000 | 8686882000 | 2422607000000 | 237557 | 1210539 | 0 | 0 | |
192.168.30.20 | drop_db | 35 | 6037186894000 | 949045589000 | 34314000000 | 0 | 0 | 83 | 0 | |
192.168.30.20 | show_variables | 5750 | 5243430123000 | 15570615000 | 510780000000 | 5748 | 3299933 | 0 | 5750 | |
192.168.30.20 | show_keys | 5529 | 5073205257000 | 106948671000 | 2106829000000 | 6224 | 95309 | 0 | 0 | |
192.168.30.20 | create_table | 21 | 3962123501000 | 367683092000 | 34661000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_tables | 6408 | 2409940818000 | 7783792000 | 1148645000000 | 50967 | 153669 | 0 | 0 | |
192.168.30.20 | set_option | 14699 | 919585901000 | 9092088000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 16 | 712706185000 | 72328507000 | 4864000000 | 0 | 0 | 14 | 0 | |
192.168.30.20 | Init DB | 8443 | 626877096000 | 1159910000 | 155240000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_table | 2988 | 600745653000 | 3983319000 | 2269000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | insert | 19 | 531984644000 | 59180596000 | 5527000000 | 0 | 0 | 86 | 0 | |
192.168.30.20 | show_grants | 3388 | 276169684000 | 1120561000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 2632 | 86240075000 | 1228996000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 88041 | 82700083000 | 1217878000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 9911 | 67858708000 | 698212000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 291 | 50913425000 | 1757374000 | 28610000000 | 71 | 357 | 0 | 0 | |
192.168.30.20 | freturn | 14647 | 34380448000 | 1824840000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | set | 444 | 19157528000 | 932764000 | 0 | 0 | 122 | 0 | 0 | |
192.168.30.20 | stmt | 72 | 16179424000 | 2158937000 | 0 | 0 | 72 | 0 | 0 | |
192.168.30.20 | show_binlogs | 196 | 13861231000 | 693027000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_storage_engines | 66 | 8734464000 | 478683000 | 4040000000 | 594 | 594 | 0 | 66 | |
192.168.30.20 | Prepare | 17 | 6189893000 | 4454274000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_slave_status | 66 | 4983614000 | 247881000 | 0 | 0 | 0 | 0 | 0 |
|