Browse them and determine which one suits your system best. Keep in mind, for Linux the file extension is. They are called my-huge.ini, my-innodb-heavy-4G.ini, my-large.ini et cetera and they can be found in the default MySQL directory. MySQL provides sample configuration files within its package. If you are not using the InnoDB database tables try to change this, in view of the fact that you are getting the Warning: MySQL server has gone away - apparently meaning that your setup is resource intensive. Note: It is assumed here that you are using the InnoDB database tables, as Drupal is a resource intensive application. If you are running an older version of MySQL then you should replace table_open_cache with table_cache.
Important: table_cache was renamed to table_open_cache in MySQL 5.1.3 ( Changes in MySQL 5.1.3). Important: Remember to keep backup files before you do anything! You will also have to reload the MySQL service after making changes to these configuration files. You must modify the following resource specifications if they are available in your original configuration file, or add them to the configuration file if they are not already specified (because some are not present by default) : Resources allowed by the default configuration are normally insufficient to run a resource-intensive application.
INCREASE CONNECTION TIMEOUT SEQUEL PRO TRIAL
Here is a step by step guide, equally valid for your Linux server as well as any local Windows MySQL installation you may be using as a trial installation along with your local Drupal installation.
INCREASE CONNECTION TIMEOUT SEQUEL PRO HOW TO
Also, it is easy to resolve, if you know how to proceed. Allowing the necessary resources to MySQL resolves this issue most of the time.
This dreaded MySQL error and subsequent Warning is due, except in rare cases, to a lack of resources available to MySQL, such as required for the operation of your Drupal installation.