search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6k stars 977 forks source link

Stats tracking of errors returned by databases #757

Open dturner9000 opened 8 years ago

dturner9000 commented 8 years ago

Recently we had an application failing because of a database issue however the way the application filtered the database exception there was not enough information to quickly track the issue down. It would be helpful if we could query proxysql and see a digest of actual database errors with user, count, etc.

ovaistariq commented 8 years ago

It would be nice, if we had per_user stats table which maps the users defined in mysql_users and reports error count per user. It would be greatly helpful as David mentions to debug auth issues for example.

renecannao commented 8 years ago

Cross reference: https://www.pythian.com/blog/using-proxysql-validate-mysql-updates/#comment-9421331