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 | 1638 | 375678632000 | 799955000 | 155022000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 1638 | 188363168000 | 530053000 | 65537000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 1637 | 11772318000 | 86971000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 30011 | 13014879227000 | 511098814000 | 3681948000000 | 132531 | 1116491 | 0 | 15911 | |
root | alter_table | 8 | 3131051778000 | 432039776000 | 3567000000 | 0 | 0 | 0 | 0 | |
root | create_table | 7 | 1961030741000 | 610872923000 | 2597000000 | 0 | 0 | 0 | 0 | |
root | show_variables | 1891 | 1711727810000 | 6354110000 | 173139000000 | 4107 | 1084216 | 0 | 1891 | |
root | show_keys | 1530 | 1710069514000 | 79242097000 | 570865000000 | 1582 | 23493 | 0 | 0 | |
root | show_fields | 1687 | 1517365981000 | 3702090000 | 643281000000 | 57682 | 294904 | 0 | 0 | |
root | insert | 15 | 482665444000 | 46418651000 | 2022000000 | 0 | 0 | 26 | 0 | |
root | show_tables | 603 | 426911616000 | 4867886000 | 252921000000 | 4967 | 19330 | 0 | 0 | |
root | set_option | 5149 | 412211213000 | 10980976000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 201325208000 | 94395073000 | 199000000 | 0 | 0 | 3 | 0 | |
root | show_create_table | 874 | 162923217000 | 5482783000 | 994000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1206 | 109777681000 | 13027271000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 1497 | 90379677000 | 3077325000 | 5682000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 97 | 44785495000 | 2935941000 | 25156000000 | 112 | 596 | 0 | 0 | |
root | alter_user | 1 | 27754264000 | 27754264000 | 1475000000 | 0 | 0 | 0 | 0 | |
root | show_warnings | 783 | 25920990000 | 286800000 | 0 | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 20310748000 | 18289880000 | 421000000 | 900 | 900 | 0 | 2 | |
root | Quit | 1829 | 13824736000 | 262151000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 39 | 7938912000 | 3184100000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 70 | 7874985000 | 2019439000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 39 | 7283898000 | 867694000 | 2452000000 | 18 | 60 | 0 | 21 |
|