In this Tutorial i will describe how to get database size in MB.Its very important script when you want list of all available database in mysql server with size in MB based on current logged-in user.
The data_length + index_length is equal to the total table size.
data_length – store the real data.
index_length – store the table index.
below is the SQL script to list out the entire databases size
SELECT table_schema "scg_insights_app", SUM( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema
Above code gives each database record from your MySQL scheme for the current logged in user.The size of database is sum of the data and index length to show a grand total.
Latest posts by Parvez (see all)
- Angular Growl – Awesome notification System in Angular - May 27, 2015
- Angular tutorial : Simple Example of Modal Box with HTTP service - May 24, 2015
- Angular Loading spinner or Preloading image with finally - May 21, 2015