Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Wednesday, July 9, 2014

Calculating MySQL Database size.

So Guys, how do you calculate the size of your databases on db server using a simple & single query..
.
.
.
Well this thing is easily achievable by a simple query. For this you need to query information_schema, which will result you the database size and other information.


   SELECT table_schema "DB Name", ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 1) "DB Size in GB" 
   FROM   information_schema.tables GROUP  BY table_schema;

:)

1 comment:

  1. Thanks for sharing this Information, Got to learn new things from your Blog on Android.The freeware version of Web app that comes with monitoring status of server and worldwide locations.
    https://play.google.com/store/apps/details?id=com.webapps.webapps

    ReplyDelete