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

Follow

Comments

1 comment

  • 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
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request