Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

flush user resource mysql

FLUSH USER_RESOURCES

Resets all per-hour user resource indicators to zero.

This operation requires the FLUSH_USER_RESOURCES or RELOAD privilege.

Resetting resource indicators enables clients that have reached their hourly 
connection, query, or update limits to resume activity immediately. 
FLUSH USER_RESOURCES does not apply to the limit on maximum simultaneous 
connections that is controlled by the max_user_connections system variable.

refrence :
https://dev.mysql.com/doc/refman/8.0/en/flush.html#flush-user-resources
 
PREVIOUS NEXT
Tagged: #flush #user #resource #mysql
ADD COMMENT
Topic
Name
8+9 =