MySQL Bugs: #117644: Lock contention due to FLUSH PRIVILEGES

Bug #117644	Lock contention due to FLUSH PRIVILEGES
Submitted:	8 Mar 3:10
Reporter:	Abdelrahman Omran	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	8.0.37	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
We recently encountered an issue after executing "FLUSH PRIVILEGES" on a busy server that led to lock contention, which is not mentioned in the official documentation. If this is the intended behavior, it would be very helpful if the documentation for this statement explicitly notes that it acquires a global lock.

How to repeat:
Run "FLUSH PRIVILEGES" on a very busy server with many concurrent transactions.

Suggested fix:
Provide clearer information about the side effects of using this statement.