How to solve this message "[Warning] option 'innodb-autoextend-increment': unsigned value 26843adjusted to 1000 ?

Solution Unverified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content