Change the innodb_log_file_size value in MySQL/MariaDB

Home > Change the innodb_log_file_size value in MySQL/MariaDB
 

Change the innodb_log_file_size value in MySQL/MariaDB with assistance from our in-house experts.

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Service.

Let’s take a look at how our Support Team recently helped out a customer with changing the innodb_log_file_size value in MySQL/MariaDB.

How to change the innodb_log_file_size value in MySQL/MariaDB

If you are looking for a way to change the innodb_log_file_size value in MySQL/MariaDB like a pro, we have your back. Our Support Engineers are here with two sets of solutions based on the server you are using.

How to change the innodb_log_file_size value in MySQL/MariaDB on Linux

  1. First, we have to connect to the Plesk server via SSH.
  2. Then we will stop the MySQL service. The command we use will depend on the OS and the MySQL version:
    # service mariadb stop
    
    # service mysql stop
  3. Next, we will open the MySQL configuration file via any text editor. For instance, here we use the vi editor:
    • On Debian.Ubuntu-based distributions:
      # vi /etc/mysql/my.cnf
    • On CentOS/RHEL-based distributions:
      # vi /etc/my.cnf
  4. Then, we have to head to the [mysqld] section and modify the innodb_log_file_size according to our preference. In case the innodb_log_file_size directive is not present, our Support Team recommends adding it manually under the [mysqld] section.
    [mysqld]
    <...>
    innodb_log_file_size=128M
    <...>
  5. After that, we have to move ib_logfile0 and ib_logfile1 files to another directory. For instance, here we move them to the /root:
    # mv /var/lib/mysql/ib_log* /root
  6. Finally, we start the MySQL service with these commands:
    # service mariadb start
    
    # service mysql start

How to change the innodb_log_file_size value in MySQL/MariaDB on Windows server

Before we begin, our Support Techs would like to point out that there are two MySQL instances with their own configuration in Plesk for Windows:

  • MySQL server for customers’ databases can be found at %plesk_dir%DatabasesMySQL
  • Plesk SQL server for Plesk system databases can be found at %plesk_dir%MySQL
  1. First, we will connect to the Plesk server via RDP.
  2. Then, we have to open the MySQL configuration file via any text editor as seen below:
    • For MySQL server:
      C:>%plesk_dir%DatabasesMySQLmy.ini
    • For Plesk SQL server:
      C:>%plesk_dir%MySQLmy.ini
  3. Next, we will head to the [mysqld] section and modify the innodb_log_file_size according to our preference.
    innodb_log_file_size=128M
  4. After that, we have to remove the redo log files as seen below:
    • For MySQL server:

      We have to navigate to the  %plesk_dir%DatabasesMySQLdata  folder and delete the  ib_logfile0 and ib_logfile1 files.

    • For Plesk SQL server:

      We have to navigate to the %plesk_dir%MySQLData folder and delete the ib_logfile0 and ib_logfile1 files.

  5. Finally, we have to start the Plesk SQL Server or MySQL57 service through Windows Services or Plesk Services Monitor.

[Seeking a solution to another query? We have your back.]

Conclusion

In brief, the skilled Support Engineers at Bobcares demonstrated how to change the innodb_log_file_size value in MySQL/MariaDB.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED