find table size in mysql

Different Ways of Finding Table Size In Mysql Server

Finding Table Size in MySQL Server using the SQL queries.

If you’re worried about your database to find the table size, So this can be possible using the SQL queries.

Check Out : How To Check Slow Queries In Mysql

I have already database which i installed from MySQL dump data to test these queries.

Our Database name is employees and there are 6 tables.

Queries 1 :

You can find size of all tables in all database using the below command

Check Out : How To Check Users in Mysql Server

Queries 2 :

You can check the table status of a database by below command.

show table status from employees;

Queries 3 :

Check Out : Mysql Error “Too Many Connections”

Run the below queries to find out the largest table in the database.

Queries 4 :

If you want to check the table count on all the databases, So run the query which showed in a picture.

You’re done

Sponsored

LEAVE A REPLY

Please enter your comment!
Please enter your name here

nine − 5 =