MySQL exceeded the ' max_questions ' resource record

Recent hive Meta Mysql often error ' user ' has exceeded the ' max_questions ' resource (current value:10000)

Workaround: Increase the max_questions settings, modify the user table directly, and then flush the permissions flush privileges.

Explore:

max_questions/max_updatestime limit per hour for resource usage, in secondsMax_connections: The number of sessions that the user is allowed to open per hourMax_user_connections: The number of sessions that the user allows to open simultaneouslyTo make these four restrictions effective, you need to add the following four seed sentences when creating a user or authorizing a user: Max_questions:with max_queries_per_hour nmax_updates:with Max_updates_per_ HOUR Nmax_connections:with Max_connections_per_hour nmax_user_connections:max_user_connections

MySQL exceeded the ' max_questions ' resource record