Get 30% off your WordPress Hosting with code WPSAVE10. Launch Faster. Save More!
  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

What does "MySQL server has gone away" mean? - SIRSTEVEHQ CP

The most common reason for the MySQL server has gone away error is that the query timed out and the connection is closed. This can happen when a MySQL query times out (i.e. a slow query).

We'd recommend running a MySQL check/optimization through phpMyAdmin to try and help with this error, to do this:

  1. Sign in to the database you wish to optimise via phpMyAdmin.
  2. Select the database from the left-hand side menu. 
  3. Select the tables you wish to optimise or select 'Check all'.
  4. From the 'With selected:' dropdown menu, select 'Optimize table'.

The 'OPTIMIZE TABLE' query that's run reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the table.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I create a MySQL database in SIRSTEVEHQ CP?

You can create MySQL databases in seconds directly from your SIRSTEVEHQ CP. This option is...

How do I manage my Microsoft SQL database? - SIRSTEVEHQ CP

We recommend using SQL Server Management Studio (SSMS) for managing your Microsoft SQL databases....

How do I download or back up my MySQL Database? - SIRSTEVEHQ CP

There are various ways to export your MySQL databases for safe keeping or transfer. The first...

Can I set my database hostname as 'localhost'? - SIRSTEVEHQ CP

The answer to this question depends on the platform type that you are using at SIRSTEVEHQ!...

How do I check MySQL Database sizes across packages in SIRSTEVEHQ CP?

SIRSTEVEHQ provides an easy way to monitor and view all MySQL database sizes across all packages...