flushall release transaction mysql code example

Example: 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