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.
:)
.
.
.
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;
:)
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.
ReplyDeletehttps://play.google.com/store/apps/details?id=com.webapps.webapps