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 | 2096 | 485525400000 | 2330265000 | 199787000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 2096 | 242791953000 | 530053000 | 84628000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 2095 | 14845430000 | 86971000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 38842 | 16233489743000 | 511098814000 | 4757812000000 | 174168 | 1472796 | 0 | 20197 | |
root | alter_table | 8 | 3131051778000 | 432039776000 | 3567000000 | 0 | 0 | 0 | 0 | |
root | show_variables | 2415 | 2165050880000 | 6354110000 | 221730000000 | 4625 | 1384593 | 0 | 2415 | |
root | create_table | 8 | 2157052218000 | 610872923000 | 2702000000 | 0 | 0 | 0 | 0 | |
root | show_keys | 1966 | 2018977582000 | 79242097000 | 732704000000 | 2078 | 31730 | 0 | 0 | |
root | show_fields | 2216 | 1993940945000 | 3702090000 | 847715000000 | 74959 | 383399 | 0 | 0 | |
root | show_tables | 759 | 539781715000 | 4867886000 | 319791000000 | 6680 | 25685 | 0 | 0 | |
root | set_option | 6546 | 511674529000 | 10980976000 | 0 | 0 | 0 | 0 | 0 | |
root | insert | 15 | 482665444000 | 46418651000 | 2022000000 | 0 | 0 | 26 | 0 | |
root | create_db | 5 | 314470488000 | 94395073000 | 383000000 | 0 | 0 | 5 | 0 | |
root | show_create_table | 1148 | 208030349000 | 5482783000 | 1563000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 1563 | 137930712000 | 13027271000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 1914 | 113240725000 | 3077325000 | 6352000000 | 0 | 0 | 0 | 0 | |
root | show_table_status | 105 | 52206928000 | 2935941000 | 29625000000 | 120 | 650 | 0 | 0 | |
root | show_warnings | 1006 | 32744744000 | 286800000 | 0 | 0 | 0 | 0 | 0 | |
root | alter_user | 1 | 27754264000 | 27754264000 | 1475000000 | 0 | 0 | 0 | 0 | |
root | show_status | 2 | 20310748000 | 18289880000 | 421000000 | 900 | 900 | 0 | 2 | |
root | Quit | 2349 | 17484375000 | 262151000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 90 | 9039953000 | 2019439000 | 0 | 0 | 0 | 0 | 0 | |
root | Prepare | 45 | 8732297000 | 3184100000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 45 | 8242065000 | 867694000 | 2748000000 | 18 | 72 | 0 | 27 |
|