Bug #33510 Report user-aggregated data in mysqldumpslow
Submitted: 25 Dec 2007 21:39
Reporter: Todd Farmer (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:all OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[25 Dec 2007 21:39] Todd Farmer
It is difficult to obtain per-user metrics when attempting to diagnose database performance issues in a shared hosting environment.  The slow query log can assist, but frequently is cluttered with a number of poorly optimized queries.  It could be useful to provide per-user aggregated data as output from mysqldumpslow to identify specific accounts that are most problematic.

How to repeat:

Suggested fix:
Modify mysqldumpslow to include an option to aggregate information per user account rather than per SQL statement.

Modified script attached.
[25 Dec 2007 21:40] Todd Farmer
Modified mysqldumpslow, includes -u option to aggregate user statistics

Attachment: mysqldumpslow.sh (application/octet-stream, text), 7.16 KiB.