I got this very interesting email from JustHost, my current hosting provider.
“Server Performance Warning for POKESOFT.NET”
It has come to our attention that your site is using an excessive amount of MySQL resources on your Just Host account. This is causing performance problems not only on your own website, but for other customers that are on this same server. When left unchecked, it can potentially cause crashes or service interruptions and lead to additional downtime.
Our research shows that server performance degrades when the MySQL usage is over 1000 tables and/or 3 GB on a single account or 1000 tables and/or 2 GB on a single database. In order to ensure optimal performance for your account and the others in your shared hosting environment, we request that you reduce the MySQL usage on your account to under these limits by 08/13/2014.
Your account information:
Total MySQL Database Size: 2148.60 MB
Total MySQL Tables: 191
Largest MySQL Database Size: 2123.55 MB
Largest MySQL Table Count: 83
Hmm, is my tables really this big? Having a poke around I found the culprit – this email is really useful! Otherwise I wouldn’t know there are a billion bots hitting my phpBB every second. Fortunately they all got stuck in the awaiting_approval queue, unfortunately this queue is in the database.
The whole phpBB was setup to test my SSO implementation, it doesn’t have any use, so I just delete the database and the files. Now I am running with only 25MB (still a bit big for vclib, not sure why…)
More email text can be found below:
We do understand that these databases may be old or unused, and that there are programs/scripts that may create new tables automatically. If you need assistance with removing content or help troubleshooting the reason for this problem we will be happy to assist you in doing so. After you have removed the unused or excessively large MySQL content you may request a rescan of the account, to establish whether or not you’re within acceptable limits.
In the event that your MySQL database content cannot feasibly be removed, separated across several accounts, compressed or optimized to be within these limits, we do offer an upgraded “Pro” hosting package that can accommodate bigger database needs. Pro accounts are moved to a server specifically configured for users needing higher limitations than those available in our standard hosting, and combine additional features with fewer customers per server. This is available via the Upgrades tab for purchase from your cPanel. If you have questions about this upgraded package, please contact our Support or Sales department.
Proper maintenance of your account will ensure the best performance for your website. If you are unable to comply with these requests your account will be automatically deactivated by 08/13/2014 to maintain proper server performance. Thank you for your help in resolving this issue.
Alternatively if you would like to increase the table count and size allowance, you may do so by upgrading to our PRO Package. This will migrate your account to one of our special PRO servers which allows for additional resource usage including MySQL. With the PRO Package your account can have up to 3,000 tables and size limits of 3GB per individual database and 5GB for all databases combined. Learn more about the PRO Package by clicking on the Upgrades Tab at the top of your Bluehost cPanel or contacting a member of our Sales team.
Per conditions stated in the Terms of Service (http://www.justhost.com/terms), this issue needs to be resolved:
7.03. Just Host does not set arbitrary limits on the amountof disk space a Subscriber can use for the Subscriber’s website, nor does Just Host charge additional fees based on an increased amount of storage used, provided the Subscriber’s use of storage complies with these Terms. Please note, however, that the Just Host service is designed to host websites. Just Host does NOT provide unlimited space for online storage, backups, or archiving of electronic files, documents, log files, etc., and any such prohibited use of the Services will result in the termination of Subscriber’s account, with or without notice. Accounts with a large number of files (inode count in excess of 200,000) can have an adverse affect on server performance. Similarly, accounts with an excessive number of MySQL/PostgreSQL tables (i.e., in excess of 1000 database tables) or of database size (i.e., in excess of 3GB total MySQL/PostgreSQL usage or 2GB MySQL/PostgreSQL usage in a single database) negatively
affect the performance of the server. Just Host may request that the number of files/inodes, database tables, or total database usage be reduced to ensure proper performance or may terminate the Subscriber’s account, with or without notice.
Terms of Service Compliance Department
1958 South 950 East
Provo, UT 84606
Phone line: (888) 755-7585 Option 5 | Fax line: 801-765-1992