How to change InnoDB log file size in MariaDB?
Make changes to my.cnf for innodb_log_file_size as per your desired option. Rollback: If it doesn’t start for some reason put back the iblogfiles and start. UPDATE: In our chat we narrowed down that my.cnf was pointed to a different file or picked default ones.
How to safely change MySQL InnoDB variable’innodsb _ buffer _ pool _ size?
Start the MySQL server again. If InnoDB detects that the innodb_log_file_size differs from the redo log file size, it will write a log checkpoint, close and remove the old log files, create new log files at the requested size, and open the new log files. innodb_buffer_pool_size — simply change my.cnf ( my.ini) and restart mysqld.
Which is the default file format for MariaDB?
In MariaDB 10.2.2 and later, the default file format is Barracuda and Antelope is deprecated. Barracuda is a newer InnoDB file format. It supports the COMPACT, REDUNDANT, DYNAMIC and COMPRESSED row formats. Tables with large BLOB or TEXT columns in particular could benefit from the dynamic row format.
Which is the default file format for InnoDB tables?
In MariaDB 10.2 and before, the default file format for InnoDB tables can be chosen by setting the innodb_file_format. In MariaDB 10.2.1 and before, the default file format is Antelope. In MariaDB 10.2.2 and later, the default file format is Barracuda and Antelope is deprecated.
How to change the log file size in MySQL?
To change the log file size, configure innodb_log_file_size. To increase the number of log files, configure innodb_log_files_in_group. Start the MySQL server again.
Is the InnoDB _ Fast _ Shutdown setting no longer relevant?
As of MySQL 5.6.8, the innodb_fast_shutdown setting is no longer relevant when changing the number or the size of InnoDB log files. Additionally, you are no longer required remove old log files, although you may still want to copy the old log files to a safe place, as a backup.