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 | 139649 | 50595045922000 | 183871845000 | 21047383000000 | 240119 | 1953479 | 0 | 16701 | |
192.168.30.20 | create_table | 13 | 2649132612000 | 391922929000 | 6800000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_fields | 2406 | 2410145372000 | 6969719000 | 978430000000 | 86777 | 442284 | 0 | 0 | |
192.168.30.20 | show_keys | 2767 | 2208566200000 | 72118922000 | 1072541000000 | 2247 | 28494 | 0 | 0 | |
192.168.30.20 | show_variables | 2186 | 1995877273000 | 5198526000 | 182512000000 | 2186 | 1254449 | 0 | 2186 | |
192.168.30.20 | alter_table | 4 | 1452359022000 | 417759643000 | 599000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_tables | 2017 | 602535229000 | 4951510000 | 302052000000 | 13573 | 36487 | 0 | 0 | |
192.168.30.20 | show_create_table | 1229 | 288846715000 | 7498044000 | 1333000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | set_option | 4640 | 239013406000 | 5904417000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Init DB | 2947 | 160807742000 | 1930324000 | 33996000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | create_db | 3 | 129703621000 | 56233822000 | 2995000000 | 0 | 0 | 3 | 0 | |
192.168.30.20 | show_grants | 823 | 64471709000 | 897594000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | insert | 2 | 61541093000 | 36894690000 | 709000000 | 0 | 0 | 3 | 0 | |
192.168.30.20 | show_binlogs | 41 | 39414216000 | 27833323000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_warnings | 1046 | 31046208000 | 144971000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_master_status | 26 | 21706076000 | 14104560000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | jump_if_not | 21803 | 20837050000 | 972162000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | freturn | 11575 | 20410009000 | 2493957000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | Quit | 3097 | 19202682000 | 218307000 | 0 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_create_proc | 78 | 16413390000 | 3015086000 | 4016000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | show_table_status | 31 | 16235656000 | 3740545000 | 11949000000 | 0 | 32 | 0 | 0 | |
192.168.30.20 | set | 170 | 9645575000 | 1249572000 | 0 | 0 | 35 | 0 | 0 | |
192.168.30.20 | show_create_func | 66 | 7835554000 | 609046000 | 1003000000 | 0 | 0 | 0 | 0 | |
192.168.30.20 | stmt | 10 | 2778309000 | 1308974000 | 0 | 0 | 10 | 0 | 0 | |
192.168.30.20 | error | 16 | 2144116000 | 845203000 | 0 | 0 | 0 | 0 | 0 |
|