Understanding mysql errors on BlueHost

Unlimited Shared hosting & Unlimited Disk Space from $5.95 - Dreamhost
Solid Managed VPS with 4 IP's from $60 - Liquid Web
Lightning Fast Dedicated Servers & 1GB RAM from $149 - Liquid Web
#1 Domain Registration with WHOIS Privacy - Just $9.95

The review of this web host was started by KenYN on 2008-12-18 12:15:30:

I believe this is a site admin question rather than a mysql one…

My BlueHost-hosted sites are giving a "This Account Has Been Suspended" error. I phoned them up last night and they said that they were getting a performance error from mysql on my main account (under 3000PV per day), so they re-enabled my CPanel, I checked my phpMyAdmin and found one unindexed table for the IP To Country plugin has grown to half a million entries - there’s no code to purge their cache table!

I flushed the table, BH turned everything back on, but my account got suspended again about 8 hours later.

Bog-standard WordPress 2.5 code with just a few other plugins like Subscribe To Comments seems to be enough to produce errors. Anyone got any suggestions as to how to debug such a site? Understand the log messages? One thing I noticed looking in other error logs was that there was a series of "Zend Optimiser has failed" errors.

Oh, and I’ve not added anything new to the blog in the last week. I have about 1,300 posts and 4,000 active comments, so it’s not a huge DB by any measure.

Join in on the original post at DP, read more affiliate reviews of web hosts or view our recommended web hosts.