Using an excessive amount of MySQL resources - Server Performance Warning

Показать описание

"Server Performance Warning!"

"Your site is using an excessive amount of MySQL resources! If you are unable to comply with these requests your account will be automatically deactivated by 11/07/2013 to maintain proper server performance."

This was the message my hosting provider, HostMonster, emailed to me.

I didn't have the slightest clue what it meant and after contacting HostMonster, it was evident that it was going to be completely up to me to resolve the problem on my own or face the consequence to having my site shut down.

Online investigation revealed that most of the information out there was aimed at someone with an understanding of MySQL databases, etc., which I didn't have. I'm completely capable of building a website and installing plugins etc., but this was an area that was outside my expertise. I didn't understand anything that was readily available online.

I found lots of references to the following terms, but none of it made sense to me enough to explain how I could figure it out and same my domain from suspension.

your site is using an excessive amount of MySQL resources,
site is using an excessive amount of MySQL resources,
using an excessive amount of MySQL resources,
optimize MySQL in c-panel,
excessive amount of MySQL resources,
excessive amount of resources,
excess MySQL tables,
excessive MySQL tables,
excessive use of CPU and Memory,
suspended hosting account,
hosting account suspended for excessive resources,
website suspended,
account suspended,
this account has been suspended,
why was my website suspended,
why was my hosting account suspended,
reduce the MySQL usage on my hosting account,
c-panel MySQL Usage,
MySQL usage in c-panel,

This video explains how I dealt with the problem and hopefully will provide the answers that you may be looking for in a similar situation.

Feel free to leave comments below and contact me if you have any questions.