Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
None
Description
Customer has had issues when querying tables such as information_schema.innodb_buffer_page and a few others that have the potential to cause production downtime in high concurrency environments.
A variable such as super_only_risky_tables to only allow super or root users to query these tables could help negate this risk.
Having this variable enabled makes the tables inaccessible for non super users.
Another option is a specific grant that does the same thing such as GRANT VERBOSE SCHEMA etc