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 | 3392924000 | 3392924000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 200 | 35371380000 | 618465000 | 14456000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 200 | 16295137000 | 530053000 | 6046000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 199 | 1147731000 | 20894000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 4008 | 2139504250000 | 342625343000 | 568670000000 | 15141 | 139895 | 0 | 2234 | |
root | create_table | 2 | 765884035000 | 610872923000 | 333000000 | 0 | 0 | 0 | 0 | |
root | insert | 14 | 436246793000 | 41694646000 | 1625000000 | 0 | 0 | 14 | 0 | |
root | show_keys | 195 | 281852939000 | 38907708000 | 80421000000 | 144 | 2193 | 0 | 0 | |
root | show_variables | 264 | 265896805000 | 5004170000 | 25586000000 | 264 | 151494 | 0 | 264 | |
root | show_fields | 185 | 188753477000 | 3702090000 | 75942000000 | 7191 | 36603 | 0 | 0 | |
root | set_option | 657 | 59035881000 | 10980976000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 46998378000 | 46998378000 | 84000000 | 0 | 0 | 1 | 0 | |
root | show_tables | 93 | 44102765000 | 2876918000 | 25054000000 | 935 | 3141 | 0 | 0 | |
root | show_grants | 178 | 27779966000 | 13027271000 | 0 | 0 | 0 | 0 | 0 | |
root | alter_user | 1 | 27754264000 | 27754264000 | 1475000000 | 0 | 0 | 0 | 0 | |
root | show_create_table | 95 | 25052233000 | 5482783000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 210 | 14305130000 | 737374000 | 2639000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 47 | 7428321000 | 786271000 | 3651000000 | 0 | 0 | 0 | 0 | |
root | Prepare | 6 | 4079769000 | 3184100000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 112 | 3545061000 | 76579000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 7 | 2733370000 | 2019439000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 243 | 1994824000 | 162673000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 6 | 1803062000 | 867694000 | 683000000 | 0 | 12 | 0 | 6 | |
root | show_slave_status | 2 | 728154000 | 690009000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 2 | 685839000 | 429264000 | 0 | 0 | 0 | 0 | 0 |
|