How to solve this message "[Warning] option 'innodb-autoextend-increment': unsigned value 26843adjusted to 1000 ?
Issue
- How to solve this message "[Warning] option 'innodb-autoextend-increment': unsigned value 26843adjusted to 1000 ?
[root@example data]# /usr/libexec/mysqld --verbose --help > /dev/null
160602 19:36:43 [Warning] option 'innodb-autoextend-increment': unsigned value 268435456 adjusted to 1000
160602 19:48:41 mysqld_safe mysqld from pid file /dbfs/mysql/data/example.pid ended
160602 19:49:37 mysqld_safe Starting mysqld daemon with databases from /dbfs/mysql/data
160602 19:49:37 [Note] /usr/libexec/mysqld (mysqld 5.5.47-MariaDB-log) starting as process 16574 ...
160602 19:49:37 [Warning] option 'innodb-autoextend-increment': unsigned value 268435456 adjusted to 1000
160602 19:49:37 InnoDB: The InnoDB memory heap is disabled
160602 19:49:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160602 19:49:37 InnoDB: Compressed tables use zlib 1.2.7
160602 19:49:37 InnoDB: Using Linux native AIO
160602 19:49:37 InnoDB: Initializing buffer pool, size = 128.0M
160602 19:49:37 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file /dbfs/mysql/data/ibdata1 is of a different size
InnoDB: 1152 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 2621440 pages, max 0 (relevant if non-zero) pages!
160602 19:49:37 InnoDB: Could not open or create data files.
160602 19:49:37 InnoDB: If you tried to add new data files, and it failed here,
160602 19:49:37 InnoDB: you should now edit innodb_data_file_path in my.cnf back
160602 19:49:37 InnoDB: to what it was, and remove the new ibdata files InnoDB created
160602 19:49:37 InnoDB: in this failed attempt. InnoDB only wrote those files full of
160602 19:49:37 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
160602 19:49:37 InnoDB: remove old data files which contain your precious data!
160602 19:49:37 [ERROR] Plugin 'InnoDB' init function returned error.
160602 19:49:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160602 19:49:37 [Note] Plugin 'FEEDBACK' is disabled.
160602 19:49:37 [ERROR] Unknown/unsupported storage engine: InnoDB
160602 19:49:37 [ERROR] Aborting
160602 19:49:37 [Note] /usr/libexec/mysqld: Shutdown complete
Environment
- Red Hat Enterprise Linux 7.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.