Those of you who use MySQL in a multi-user environment are probably disappointed by it’s lack of per user usage statistics. For example in Linux there are BSD process accounting for CPU usage and IO accounting for disk usage tracking. Most applications like apache, ftp servers and mail servers provide some sort of usage statistics as well. But MySQL is the great anonymizer.
Not anymore, thanks to the people at Percona for their microslow patch and Google for the UserTableMonitoring patch.
Latest version of the patches can be found here but at the time of this writing they are against MySQL 5.0.62 and the current MySQL version is 5.0.67. So I tweaked the patches to apply cleanly to MySQL 5.0.67 and placed them for download: microslow, userstats, microslow+userstats.