Would you like to learn how to check the size of a MySQL table in Megabytes? In this tutorial, we are going to show you how to use the MySQL command-line to verify the size of a table.
• Ubuntu 18.04
• Ubuntu 19.04
• MySQL 8.0.18
Equipment list
The following section presents the list of equipment used to create this tutorial.
As an Amazon Associate, I earn from qualifying purchases.
Related tutorial – MySQL
On this page, we offer quick access to a list of tutorials related to MySQL.
Tutorial MySQL – Check the size of all tables from a Database
Access the MySQL command-line.
Check the size of all tables from a MySQL Database.
Here is the command output:
In our example, we verified the size of all tables from a MySQL database named DATABASE-A.
Keep in mind that you need to replace the database name DATABASE-A by your desired database name.
Tutorial MySQL – Check the size of a specific table from a Database
Access the MySQL command-line.
Check the size of a specific table from a specific MySQL database.
Here is the command output:
In our example, we verified the size of a table named TABLE-A from a database named DATABASE-A.
Keep in mind that you need to replace the database name DATABASE-A by your desired database name.
Keep in mind that you need to replace the table name TABLE-A by your desired table name.
