SELECT * FROM `x$user_summary_by_statement_type`
|
user | statement | total | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans | |
---|---|---|---|---|---|---|---|---|---|---|
background | select | 1 | 2604161000 | 2604161000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 1028 | 242819102000 | 1325919000 | 98932000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1028 | 120406704000 | 571681000 | 41051000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1027 | 7843626000 | 47599000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 18316 | 9654551388000 | 815548989000 | 2530968000000 | 97005 | 594145 | 0 | 7127 | |
root | show_keys | 612 | 1199132474000 | 94838578000 | 219336000000 | 812 | 9768 | 0 | 0 | |
root | show_variables | 748 | 699904394000 | 6889023000 | 68596000000 | 746 | 428743 | 0 | 748 | |
root | set_option | 3242 | 691590986000 | 435484389000 | 0 | 0 | 0 | 0 | 0 | |
root | show_fields | 661 | 619178412000 | 3797688000 | 252420000000 | 24259 | 123744 | 0 | 0 | |
root | create_table | 2 | 523948986000 | 350272483000 | 3007000000 | 0 | 0 | 0 | 0 | |
root | show_tables | 598 | 431098752000 | 3444090000 | 268678000000 | 3256 | 10790 | 0 | 0 | |
root | create_db | 11 | 304240267000 | 64943844000 | 626000000 | 0 | 0 | 6 | 0 | |
root | show_table_status | 94 | 72155327000 | 3225308000 | 48975000000 | 0 | 104 | 0 | 0 | |
root | Init DB | 862 | 62335137000 | 2264915000 | 5197000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 689 | 58205288000 | 309401000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 316 | 53020574000 | 683107000 | 200000000 | 0 | 0 | 0 | 0 | |
root | insert | 1 | 34777785000 | 34777785000 | 523000000 | 0 | 0 | 1 | 0 | |
root | jump_if_not | 29127 | 19210264000 | 311886000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 65 | 16360189000 | 11148674000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 8237 | 11230891000 | 1057317000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 283 | 8295347000 | 67960000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 1164 | 8098784000 | 206960000 | 0 | 0 | 0 | 0 | 0 | |
root | show_slave_status | 58 | 6007140000 | 255125000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 58 | 3959880000 | 153833000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 26 | 3379822000 | 719677000 | 0 | 0 | 0 | 0 | 0 |
|