Applicable to:
- Plesk for Linux
Question
How to increase a value of the variable innodb_log_file_size?
Answer
Depending on the operation system, path to the configuration files and services names might vary. Check the following article to find the proper configuration file: Plesk for Linux services logs and configuration files
In the example above, MariaDB 10.1 on Centos 7 is being used.
-
Log into the server via SSH.
-
Use any text editor to open
/etc/my.cnffile -
Under
[mysqld]section, add the following line:CONFIG_TEXT: innodb_log_file_size=128MB
-
Move the old log files away:
# mv /var/lib/mysql/ib_logfile0 /root/
# mv /var/lib/mysql/ib_logfile1 /root/ -
Restart Database server:
# service mariadb restart
Comments
0 comments
Please sign in to leave a comment.