Articles in this section

See more

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

Avatar
Yulia Minenkova
Updated
Plesk for Windows kb: how-to Plesk for Linux ABT: Group A

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Question

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

Answer

Note: Any Customization may be overwritten during MariaDB/MySQL updates.

 

Changing the innodb_log_file_size value on Linux

 

  1. Connect to a Plesk server via SSH.

  2. Stop the MySQL/MariaDB service. The command will differ depending on an OS and installed MySQL/MariaDB version:

    # systemctl stop mariadb

    # systemctl stop mysql

  3. Open the MySQL/MariaDB 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

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

    Note: If the innodb_log_file_size directive does not exist in the file, add it manually under the [mysqld] section.

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

  5. 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

  6. Start the MySQL service:

    # systemctl start mariadb

    # systemctl start mysql

 

Changing the innodb_log_file_size value on Windows Server

 

In Plesk for Windows, there are two MySQL/MariaDB 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/MariaDB 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.

 

Comments

1 comment

Sort by Date Votes
  • Avatar
    Del Corso (Edited )

    These instructions work on MariaDB 10.3 but on 10.11.6 -  if you do step #5 (moving ib_log*) then mariadb will not start:

    2023-12-02 21:01:34 0 [ERROR] InnoDB: File ./ib_logfile0 was not found
    2023-12-02 21:01:34 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
    2023-12-02 21:01:34 0 [Note] InnoDB: Starting shutdown..

    If you skip step #5, and just restart the service, it will re-size the existing file: (96MB->32MB in my case)

    2023-12-02 21:03:33 0 [Note] InnoDB: Resizing redo log from 96.000MiB to 32.000MiB; LSN=3001335335


    This may be correlated with: "innodb_log_file_size: From MariaDB 10.9 the variable is dynamic, and the server no longer needs to be restarted for the resizing to take place." 

    0

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles