Tuesday, 7 March 2017
MySQL : Find databases size
MySQL : Find databases size
In this post we will know how to find out the databases size in the MySQL server.
MySQL Select Query to find database sizes :-
SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;The above query will list out all the database names and the sizes in MB which are in the MySQL Server. The output will be as shown below
In SQLYog editor :-
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment