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.

Tutorial MySQL - Check the size of all tables from a Database

Access the MySQL command-line.

Copy to Clipboard

Check the size of all tables from a MySQL Database.

Copy to Clipboard

Here is the command output:

Copy to Clipboard

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.

Copy to Clipboard

Check the size of a specific table from a specific MySQL database.

Copy to Clipboard

Here is the command output:

Copy to Clipboard

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.