I have received a notification that my shared hosting account is about to be suspended due to excessive usage of the mysql service. what should i do to prevent it?

Answer by: George Kaloyanov, Aplus.Net Knowledge Base Support

You have two options to prevent your account from being suspended due to excessive SQL service usage. You can either upgrade your service plan, or optimize your scripts to decrease the SQL service usage.

Note: With Unix-based plans (Personal Unix, Business Class Unix, Pro Unix or eCommerce Unix), you can check your MySQL usage through the Usage Meter tool available in the Aplus.Net Control Panel.

I. Upgrading your plan:

Aplus.Net monitors the daily average number of SQL queries that your website generates. Since your website generates more SQL queries than allowed with your current hosting plan you should consider an upgrade. The notification email that you received from Aplus.Net states the exact number of SQL queries that your website generates daily, as well as the service plan that we suggest you upgrade to.

Aplus.Net’s shared hosting plans SQL query limitations are as follows:

Aplus.Net Unix-based hosting plans:

Unix-based plans:

Personal Unix – 128 / daily

Business Class Unix – 256K / daily

Pro Unix – 512K / daily

eCommerce Unix – 1024K / daily

Please contact our friendly Sales Department to request an upgrade. Sales Representatives are available 24/7 toll free, at (877) 275-8763 or (858) 410-6929 for International callers.

II. Decreasing your SQL queries and SQL connections:

Review your scripts that generate SQL queries and try to minimize the number of SQL queries as much as possible.
Some scripts might leave the SQL connection open after the query has been processed. You should check your script coding and make sure you close all your SQL connections appropriately. Aplus.Net allows 5 simultaneous connections to the MySQL server on our Unix-based hosting servers.
Optimize your Database configuration. A common reason for unnecessary SQL service load is a database that executes a sort each time a query is submitted.