Monday, December 3, 2012
MySQL Database Size check
Found this gem online today and thought i would share. It shows the size in MB per database container for a MySQL database.
SELECT table_schema "Data Base Name",
sum( data_length + index_length ) / 1024 /
1024 "Data Base Size in MB",
sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ;
Subscribe to:
Post Comments (Atom)
Phoenix
I am resurrecting this tech blog for notes related to Azure Logic Apps with SAP.
-
While working on a project I was using a MsSQL 2012 database for my persistence layer but wanted to use a SQLITE in memory database for my u...
-
Redmine Install Process -- Download and install turnkey linux's redmine appliance http://www.turnkeylinux.org/redmine -- install up...
-
If you are a developer you probably have Visio but if you don’t https://www.draw.io/ is a great alternative and its free.
No comments:
Post a Comment