MySQL – Calculating Disk Usage Per Database
The answer usually lies within /var/lib/mysql/[DATABASE]. But the answer can also be found in, you guessed it, information_schema! ð Here’s an one-liner for you, that displays database sizes in megabytes (nice long float() included) If gigabytes are more your thing, run the following: Example output: Query on ð¾
How To: Save Disk Space, Bandwidth and Load Time on Website Images Using Smushit.com
If you are a web developer you know the importance of disk space, bandwidth and load time when it comes to images. And it will become increasingly important latter when web 2.0 becomes standard among with HTML5. You need a way to compress the images, and I don’t mean resizing the image, which can also…