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

Tonight we are going to make a change to open the MySQL bin-log log.

After shutting down the database, modify the parameter file and add it under mysqld (be sure to add it under mysqld) to open the binlog log of mysql

[mysqld]

Log-bin=mysql-bin

Start the database after modifying the parameters, but the database cannot be started. Report an error:

Refer to the error log and send the following message:

See server memory found to be less than 4G

Modify the parameter file to change 4G to 2G

Innodb_buffer_pool_size = 2G

Restart the database and start successfully.

Through the process of error reporting here, do not panic when you report an error, use a variety of logs to locate the problem, and then analyze the problem to find the exact cause.

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.