Shulou(Shulou.com)06/02 Report--

There is a problem:

Default maximum allowable packet is too small, warning InnoDB log file is too small, alarm message occurs

Solution: 1. Modify the database configuration:

Vim / etc/my.cnf

Add the following under [mysqld]:

Innodb_log_file_size = 2G

Innodb_file_per_table = ON

Max_allowed_packet = 512m

Note:

There is a certain proportion of the size value set in this, you can not set the value at will, you can refer to the official documentation or installation tutorial to set it, otherwise it will be wrong!

two。 Restart the database

Systemctl resatrt mysqld

Netstat-ntap | grep 3306

Systemctl status mysqld

3. Web page verification

Refer to the official documentation:

Https://confluence.atlassian.com/confkb/exceeds-max-allowed-packet-for-mysql-179443425.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.