Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
Description
It is well known within the MySQL community that the outputs of information_schema.tables is inaccurate as the data is based on statistics. This was solved in MySQL by implementing the IS.FILES table which allows us to see the total number of extents used by a particular data file.
While we can SSH into the underlying database to check the actual storage used by the data file, for users who do not have SSH access to the host (ex. Cloud Databases) they are unable to get an accurate depiction of the storage used by their tables even after updating their table statistics