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.user table. I see this is included in the SHOW GRANTS output.
SHOW GRANTS for 'dba'@'%'; +--------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for dba@% | +--------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'dba'@'%' IDENTIFIED BY PASSWORD '*CAABA4CFB7E71E51477E0658FC2D2BBA1267E669' WITH MAX_USER_CONNECTIONS 10 | +--------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec)
The documentation includes details that you can flush the resource limits, however I have found no way to monitor the current usage.
I welcome any feedback from the MySQL Community.