How to change the value of innodb_log_file_size in MySQL/MariaDB

1. Connect to a Plesk server via SSH.

2. Stop MySQL. The command will differ depending on OS and installed MySQL version:

   # service mariadb stop
   
   # service mysql stop
   
   # service mysqld stop

3. Open MySQL configuration file my.cnf in any text editor. In this example, we are using the vi editor:

   • on CentOS/RHEL-based distributions

     # vi /etc/my.cnf

   • on Debian/Ubuntu-based distributions

     # vi /etc/mysql/my.cnf

4. Under the [mysqld] section, change the innodb_log_file_size value according to your needs (the default value is 48M):

   CONFIG_TEXT: [mysqld]
   <...>
   innodb_log_file_size=128M
   <...>

5. Move redo log files ib_logfile0 and ib_logfile1 to another directory. In this example, the files are move to /root:

   # mv /var/lib/mysql/ib_log* /root

6. Start MySQL/MariaDB:

   # service mariadb stop
   
   # service mysql stop
   
   # service mysqld stop

In Plesk for Windows, there are tow MySQL instances with their own configuration:

• Plesk SQL server for Plesk system databases (location %plesk_dir%MySQL\)
• MySQL server for customers' databases (location %plesk_dir%Databases\MySQL\)

1. Connect to a Plesk server via RDP.

2. Open MySQL configuration file my.ini in any text editor (Just paste the below path in Windows Explorer to open):

   • for Plesk SQL server:

     C:\> %plesk_dir%MySQL\my.ini

   • for MySQL server:

     C:\> %plesk_dir%Databases\MySQL\my.ini

3. Under the [mysqld] section, change the innodb_log_file_size value according to your needs (the default value is 10M):

   CONFIG_TEXT: innodb_log_file_size=128M

4. Remove the redo log files:

   • for Plesk SQL server:

     Browse to the folder %plesk_dir%MySQL\Data and delete the files ib_logfile0 and ib_logfile1.

   • for MySQL server:

     Browse to the folder %plesk_dir%Databases\MySQL\data and delete the files ib_logfile0 and ib_logfile1.

5. Start the Plesk SQL Server/MySQL57 service via Plesk Services Monitor or Windows Services.