![]() |
Source: http://imgs.xkcd.com/store/imgs/actual_size_200.png |
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:
Here’s how:
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 size
Database 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?
Get Blog Updates via Email!
Enter your email address:
Delivered by FeedBurner


pingthis();
Everything posted on Miguel Guhlin’s blogs/wikis are his personal opinion and do not necessarily represent the views of his employer(s) or its clients. Read Full Disclosure