database tuning on wp

While doing some domain reconfigurations with my hoster, I today realized that the mySQL database, which powers this blog, was waaaayyyyy to big: 115MB instead of a designated 100MB. Also, this blog has been a bit slow in the past as it always took more than a few seconds to load.

So I googled for an faq on database tuning and came across this neat plugin, which unfortunately isn’t available in English, only German. However, what it does is checking the database for obsolete or double entries, and – the best option: it changes the indices and adds alternative indices which result in a faster access of the database (+ some other nice goodies). The direct result is that wordpress instantly loads much faster. Sweet :-)

And then of course there are the statistics. Stats entries, which took up 96 MB alone. Aiii…… maybe I should only use those external site stats services (sitemeter, etc.) instead of stats-plugins for wp.

Deleting edata is such an alleviating feeling.

Posted by

Hi, I am an engineer who freelances in water & sanitation-related IT projects at Saniblog.org. You'll also find me on Twitter @jke and Google+.

1 comment » Write a comment

  1. Just what I was looking for to tune my database just yesterday! Looks like I’ll have to dig out my high school german books and dictionary though to understand what the site says. That or turn to trusted Babelfish.

    Thanks for the heads up!