Unsettled Christianity

Gloria Dei homo vivens – St Irenaeus
March 17th, 2014 by Joel Watts

@GoDaddy, MYSQL database sizes, and how to fix them

Like all real bloggers, I self-host and as such, there are times that I have to do my own repair. One of these times happened last night.

I received an email threat from GoDaddy stating that my database size for this blog was 3000mb. I was limited to 1000mb. They were going to kill this blog on March 30 if I did not correct it.

So, I went searching. I mean, I have 6 years of material here. I couldn’t just let it die. And I may have said some unnice things about GoDaddy.

Then, I found the answer.

If you use, and you do, the Akismet plugin to kill spam, you might think you are deleting spam comments, especially if you click the button that says “delete spam.” Here’s the problem. You aren’t deleting everything.

In the space of 5 years of self-hosting, I’ve brought along with me about 2880mb’s worth of deleted spam comments.

So, this is what you do.

Go to your phpAdmin. In GoDaddy, this is much simpler than it used to be.

So a SQL query:

select * from wp_commentmeta where meta_key like “%akismet_%”

If you noticed a huge amount, it may be time to delete.

Do another query.

delete from wp_commentmeta where meta_key like “%akismet_%”

Right now, my database is sitting at about 120mb.

You see the difference there, right? This is not GoDaddy’s fault, as some forums said. This is Akismet’s issue, but the user should be able to fix it.

Also, get this plugin. It helps to discard useless junk from your database, but it will not delete the metadata, such as Akismet.

Joel Watts
Watts holds a MA in Theological Studies from United Theological Seminary. He is currently a Ph.D. student at the University of the Free State, analyzing Paul’s model of atonement in Galatians, as well as seeking an MA in Clinical Mental Health at Adams State University. He is the author of Mimetic Criticism of the Gospel of Mark: Introduction and Commentary (Wipf and Stock, 2013), a co-editor and contributor to From Fear to Faith: Stories of Hitting Spiritual Walls (Energion, 2013), and Praying in God's Theater, Meditations on the Book of Revelation (Wipf and Stock, 2014).

Leave a Reply, Please!

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: