Knowledgebase

MySQL Server Overload

A MySQL server overload happens when your query requires more resources than what is available on the server.  The overload will impact the server performance for all sites that are on the server.  More information on the exact query can be found in the appropriate log files.

Resolving a MySQL Overload may require a bit of research or help from a web developer. Many times, an overload can be caused by a form on your site being spammed or simply needing updated or even optimized.  Similarly, this can be caused by an outdated, or not optimized, CMS (content management system). Updating your CMS (Joomla, WordPress, etc) and making sure the plugins are up to date and optimized are a great way help avoid a MySQL server overload.

In order to help resolve a MySQL Server overload  that is caused by an non-optimized MySQL database you can try the following.

One of the common ways to avoid or even fix this type of issue is to optimize the MySQL database tables.  In order to ensure that your database tables are optimized please do the following.

1. Click on the phpMyAdmin section of your control panel.

selectphpmyadmin

 

 

 

 

 

2. Click on the database that you want to optimize from the list on the left.  This should take you to the “structure” tab  of the database selected.

Selectdatabase

3. Select the check-box for each of the tables that you wish to optimize, you can use select all as well.

tableselection

4. Now that the tables are chosen you can select the drop down menu that says and choose ‘Optimize table”

Dropdownopt

 

Once that is chosen the optimization process will run. The results will be displayed in a new screen.

Other ways to insure your MySQL queries do not cause an overload include updating your content management systems (WordPress, Joomla, etc) and the related plugins. Disabling and removing any unused plugins will help out as well. You may even want to download plugins that specifically help with database optimization for your current CMS.

Other ways to prevent an MySQL Server Overload

1.When installing new plugins or other applications be sure to only install the newest versions. Ensuring that all applications and plugins are updated will ensure they not only have less vulnerabilities but also that they use resources more efficiently.

2. Regularly optimize all SQL queries and databases that your site is utilizing.

3. Try to index tables in a way that would allow the database server to look up rows quicker. This may require the assistance of a web developer as this takes some expertise in doing.

Here are some links for additional assistance on MySQL database optimization.

https://dev.mysql.com/doc/refman/5.5/en/optimization.html

http://www.databasejournal.com/features/mysql/article.php/1382791/Optimizing-MySQL-Queries-and-Indexes.htm

Was this answer helpful?

 Print this Article

Also Read

What is Mysql?

MySQL is a Relational Database Management System. A relational database adds speed and...

How do I add a mysql database in Cpanel?

To create a MySQL database: - Go to 'Manage Mysql' under the database header in Cpanel - In the...

What is the default mysql port?

3306 is the default mysql port.

What is the mysql host name?

Always use 'localhost' whenever asked

How can I access mysql database remotely?

Under the mysql header in Cpanel, select 'manage mysql' Then scroll down to the 'access hosts'...

Powered by WHMCompleteSolution