Monitoring Mysql

Monitoring MySQL resource limits

Ronald Bradford
October 28, 2009

I have for the first time seen a client implement MySQL Resource Limits . I got the following error tying to connect to the database. $ mysql -udba -p ERROR 1226 (42000): User 'dba' has exceeded the 'max_user_connections' resource (current value: 10) I see from the documentation the ability to see the limits in the mysql.

Databases MySQL Open Source Uncategorized

Monitoring MySQL – The error log

Ronald Bradford
September 16, 2009

It is important that you monitor the MySQL error log. There are a few different options available for defining the details of the log. If not specified the default is [datadir]/[hostname].