tshoot_mysql_table-open-cache.md

group	subgroup	title	menu_title	menu_node	menu_order	functional_areas
installation-guide	20_other	Error 'MySQL server has gone away' during installation	Error 'MySQL server has gone away' during installation		505	Install System Setup

Details

During installation, the following message displays:

MySQL server has gone away

Solution

Set the value of table_open_cache{: target="_blank"} to a value of at least 250 as follows:

1. As a user with root privileges, open the MySQL configuration file in a text editor.

   Ubuntu 16: /etc/mysql/mysql.conf.d/mysqld.cnf

   Ubuntu earlier than 16: /etc/mysql/my.cnf

   CentOS: /etc/my.cnf

2. Search for an existing table_open_cache setting. If there is none, add one.

3. Set the value to at least 250:

   table_open_cache=250
   

4. Save your changes to my.cnf and exit the text editor.

5. As a user with root privileges, restart the MySQL service:

   Ubuntu: service mysql restart

   CentOS: service mysqld restart