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)
-
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...
-
I recently installed windows 10 preview on an old laptop (Dell Precision) which has an Nvidia Quadro 3000M video card. After running window...
No comments:
Post a Comment