Someone recently asked a question on the MoodleMayhem.org email list:
I need to find out what the current database size is of my Moodle. Can someone tell me where that is located and how I can find it? Thanks.
Wow, what a great question! The answer, of course, wasn't as hard as I would have imagined:
From the link above (I'm stealing it for my notes here!):
I tried it on an existing database and came up with the following result for our MSTATEKS2011 MySQL database:
MySQL Database sizeDatabase size is: 1298885483 bytesorDatabase size is: 2 GB
That sure beats downloading the SQLdump file you can make using a tool like PHPMyAdmin, SQLYog or NavicatLite.
You will have to know what values go here:
Those might look like this generally:
What a nifty trick! To do this before, I was simply doing a SQLDump using a MySQL dbase tool...this was MUCH faster. What would it take to display multiple database sizes in a list?