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 | 1644 | 381714615000 | 1325919000 | 155067000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1644 | 219123199000 | 28644664000 | 93303000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1643 | 12595853000 | 50450000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 74027 | 25536081345000 | 815548989000 | 9859450000000 | 197351 | 1214079 | 0 | 11528 | |
root | show_keys | 1019 | 1567745752000 | 94838578000 | 358784000000 | 1280 | 15915 | 0 | 0 | |
root | show_variables | 1279 | 1167663218000 | 6889023000 | 114441000000 | 1275 | 733096 | 0 | 1279 | |
root | create_table | 4 | 1057105302000 | 350272483000 | 3324000000 | 0 | 0 | 0 | 0 | |
root | show_fields | 1125 | 1022050651000 | 3797688000 | 416856000000 | 41021 | 209281 | 0 | 0 | |
root | set_option | 5181 | 823541625000 | 435484389000 | 0 | 0 | 0 | 0 | 0 | |
root | show_tables | 913 | 642479390000 | 4648127000 | 400228000000 | 5188 | 17084 | 0 | 0 | |
root | create_db | 12 | 321706953000 | 64943844000 | 626000000 | 0 | 0 | 7 | 0 | |
root | show_create_table | 549 | 93259531000 | 758503000 | 363000000 | 0 | 0 | 0 | 0 | |
root | Init DB | 1366 | 93038376000 | 2264915000 | 7147000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1087 | 92049466000 | 360168000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 119 | 84944190000 | 3225308000 | 57577000000 | 2 | 148 | 0 | 0 | |
root | grant | 2 | 66731461000 | 38713522000 | 1377000000 | 0 | 0 | 0 | 0 | |
root | insert | 2 | 66172276000 | 34777785000 | 929000000 | 0 | 0 | 2 | 0 | |
root | drop_db | 1 | 59691520000 | 59691520000 | 473000000 | 0 | 0 | 0 | 0 | |
root | alter_user | 2 | 45045356000 | 30257987000 | 843000000 | 0 | 0 | 0 | 0 | |
root | revoke_all | 1 | 44350590000 | 44350590000 | 289000000 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 55644 | 37787537000 | 379943000 | 0 | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 31234735000 | 31234735000 | 1301000000 | 0 | 0 | 0 | 0 | |
root | freturn | 17233 | 19148225000 | 1057317000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 95 | 18041730000 | 11148674000 | 0 | 0 | 0 | 0 | 0 |
|