I woke up this morning to the following:
WordPress database error: [Can’t open file: ‘poliblog_comments.MYI’ (errno: 144)]
SELECT COUNT(*) FROM poliblog_comments WHERE comment_approved = ‘0′WordPress database error: [Can’t open file: ‘poliblog_comments.MYI’ (errno: 144)]
SELECT COUNT(comment_ID) FROM poliblog_comments WHERE comment_approved = ’spam’
While the blog was displaying, anything like up to calls to the comments section of the database was screwed up. Luckily I was able to use the “Repair” command in MySql to fix the problem.
Anybody out there have any idea what the problem was/what might have caused it? I am guessing some sort of comment spam attack, but if so, this is the first time I have ever seen a result like this.
Sphere: Related Content
This might be helpful:
http://geeklog.blogspot.com/2006/10/mysql-error-144-and-apache-performance.html
Comment by Anon — Thursday, December 28, 2024 @ 9:02 am
Yep, that makes sense. The database probably shrank considerably as a result of the repair command. If it had anything to do with spam, it would be that any deleted data is not fully deleted, just flagged as deleted, until repair is done.
OTOH this implies that you’ll run out of space again, and that perhaps space is tighter on the server than it ought to be.
Or something could simply have been corrupt and that was enough to fix it.
Comment by Jay — Thursday, December 28, 2024 @ 11:30 am
I was able to clear out some spam-related entries in the database, which gave me quite a bit more space, so hopefully that will do the trick.
I had some Spam Karma 2 entries that I thought I had deleted, but had not. I stopped using SK because it took up so much database space.
Comment by Dr. Steven Taylor — Thursday, December 28, 2024 @ 12:21 pm