How to change the innodb_log_file_size value in MySQL/MariaDB

Applicable to:

How to change the value of innodb_log_file_size in MySQL/MariaDB?

Changing the innodb_log_file_size value on Linux

Connect to a Plesk server via SSH.
Stop the MySQL service. The command will differ depending on an OS and installed MySQL version:

# service mariadb stop

# service mysql stop

# service mysqld stop
Open the MySQL configuration file my.cnf in a 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
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
<...>
Move the redo log files ib_logfile0 and ib_logfile1 to another directory. In this example, the files are moved to /root:

# mv /var/lib/mysql/ib_log* /root
Start the MySQL service:

# service mariadb start

# service mysql start

# service mysqld start

Changing the innodb_log_file_size value on Windows Server

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\)

Connect to a Plesk server via RDP.
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
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
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.
Start the Plesk SQL Server/MySQL57 service via Plesk Services Monitor or Windows Services.