Resolved Mysql Conf error for innodb

[Aude]

when i try to add this line, in my.cnf
innodb_log_file_size=4G

i got an error when i restart maria db ?

 

[IgorG]

Perhaps you have lack of free diskspace on your disk partition where innodb logs should be located?

 

[AYamshanov]

Hi Aude,

You cannot just change this variable inside my.cnf, it is not so easy. Please read the official documentation: MySQL :: MySQL 5.6 Reference Manual :: 14.7.2 Changing the Number or Size of InnoDB Redo Log Files.

 

[Aude]

@IgorG
i have 30Go on free space.

Here my my.cnf (64G server)

# INNODB #
innodb-buffer-pool-size = 4G
innodb-file-per-table = 1
innodb_buffer_pool_instances = 4
innodb-flush-method = O_DIRECT
innodb_log_file_size = 4G < this line fail to restart

when i look at the error log i have :

170418 14:31:33 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
170418 14:31:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170418 14:31:33 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 10309 ...
170418 14:31:33 [Warning] Changed limits: max_open_files: 1024 max_connections: 214 table_cache: 400
170418 14:31:33 InnoDB: The InnoDB memory heap is disabled
170418 14:31:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170418 14:31:33 InnoDB: Compressed tables use zlib 1.2.7
170418 14:31:33 InnoDB: Using Linux native AIO
170418 14:31:33 InnoDB: Initializing buffer pool, size = 16.0G
170418 14:31:34 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
InnoDB: Possible causes for this error:
(a) Incorrect log file is used or log file size is changed
(b) In case default size is used this log file is from 10.0
(c) Log file is corrupted or there was not enough disk space
In case (b) you need to set innodb_log_file_size = 48M
170418 14:31:34 [ERROR] Plugin 'InnoDB' init function returned error.
170418 14:31:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170418 14:31:34 [Note] Plugin 'FEEDBACK' is disabled.
170418 14:31:34 [ERROR] Unknown/unsupported storage engine: InnoDB
170418 14:31:34 [ERROR] Aborting

 

[UFHH01]

Hi Aude,

pls. check your "my.cnf" - file for a setting which causes your error:

InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!

The explanation is already given by:

(a) Incorrect log file is used or log file size is changed
(b) In case default size is used this log file is from 10.0
(c) Log file is corrupted or there was not enough disk space
In case (b) you need to set innodb_log_file_size = 48M

 

[Aude]

Ok. I will try alone