Skip to content

Latest commit

 

History

History
41 lines (26 loc) · 1.03 KB

tshoot_mysql_table-open-cache.md

File metadata and controls

41 lines (26 loc) · 1.03 KB
layout group subgroup title menu_title menu_node menu_order version github_link
default
install_trouble
20_other
Error 'MySQL server has gone away' during installation
Error 'MySQL server has gone away' during installation
505
2.0
install-gde/trouble/tshoot_mysql_table-open-cache.md

Details

During installation, the following message displays:

MySQL server has gone away

Solution

Set the value of table_open_cache 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: /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