How to show that I've imposed limitations for queries per hour ?
Can't find anything online or notes. Would appreciate anybody's help on this.
MySQL 8.0 Reference Manual / ... / Setting Account Resource Limits (valid for 5.5+ at least).
The server stores resource limits for an account in the
usertable row corresponding to the account. The max_questions, max_updates, and max_connections columns store the per-hour limits, and the max_user_connections column stores the MAX_USER_CONNECTIONS limit.
SELECT CONCAT('\'', user, '\'', '@', '\'', host, '\'') account, max_questions, max_updates, max_connections, max_user_connections FROM mysql.user;