Hi all , in this post i am going to show you how to check current mysql database size, below queries are tested on Mysql 5.5.8
Just fire below queries on your mysql db you will have your results ready on terminal.
For calculating db size 2 things should be considered
- Data length
- Index length
###Checking for full database size on server :-
###Checking in details with each table size in single schema :-
For checking the database size in MB just remove one ‘/1024’ from quries.
Happy coding.. :)