How to get the size of a table?

Posts regarding the MySQL database server
Post Reply
mister_v
Posts: 188
Joined: Thu Mar 04, 2010 9:19 pm

How to get the size of a table?

Post by mister_v »

Hello,

how do I get the size of a table in MB?

Is there a query you can use?
chris
Site Admin
Posts: 194
Joined: Mon Jul 21, 2008 9:52 am

Re: How to get the size of a table?

Post by chris »

You can get size of any table with the following query:

Code: Select all

SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB'
FROM information_schema.TABLES 
WHERE table_schema = "$DB_NAME" AND table_name = "$TABLE_NAME";
just replace $DB_NAME with the name of the database and $TABLE_NAME with the name of the table.
Post Reply