Large table sizes can fill database disk volumes, cause downtime, affect data integrity and negatively impact database management tasks. This document will guide you through the steps to identify and troubleshoot large database tables.
At the MySQL prompt, run the following query. You must substitute "
exampledb" with your database name. To determine the database name please review Working with databases - Viewing database information.