How to change MySQL/MariaDB innodb_log_file_size value?

You might be a long way to find innodb_log_file_size values in MySQL/MariaDB.

For Linux users:

Step 1: Use SSH to get connect Plesk server

Step 2: Now stop the service of MySQL and choose the command by selecting the version MySQL or OS:

Step 3: Use text editor vi editor to open the file MySQL configuration:

The ubuntu-based distribution in Debian:

The RHEL-based distribution in CentOS:

Step 4: As per our requirement, you can make changes in innodb_file_size in the section of [mysqld]. Sometimes, you won’t see the file there so, better go add it new in the same section:

Step 5: You need to move two files such as ib_logfile1 and ib_logfile0 directly to the directory of your choice.

To the root, you can move them:

Step 6: You would have stopped the MySQL service at starting now restart again using the command:

For Windows server:

Here comes the question:

Where you will be finding the customer database in the MySQL server? Check-in Again, where you will be finding the Plesk system database in the Plesk SQL server? Check-in Step 1: Use RDP, to connect Plesk server. You can see the MySQL configuration file only by using the text editor:

Plesk SQL server:

MySQL server:

Step 2: Make changes in the file innodb_log_file_size in the section [mysqld]:

Step 3: Start removing the redo log files in

MySQL server: Move on to the folder %plesk_dir%Databases\MySQL\data and start deleting the file ib_logfile0 and ib_logfile1

Plesk SQL server: To delete the file ib_logfile0 and ib_logfile1, go to the folder %plesk_dir%MySQL\Data

Step 4: Use the Plesk server monitor or Windows services to start MySQL57 or Plesk SQL Server.