修改配置参数后无法启程MySQL数据库

修改MySQL的参数文件/etc/my.cnf后MySQL数据库无法启动

查看错误日志，详见红色字体报错信息：

170418 10:05:50 mysqld_safe mysqld from pid file /app/mysql-data/tmp/mysqld.pid ended

170418 10:07:47 mysqld_safe Starting mysqld daemon with databases from /app/mysql-data/data

2017-04-18 10:07:48 0 [Note] /opt/mysql/bin/mysqld (mysqld 5.6.30-76.3-log) starting as process 8508 ...

2017-04-18 10:07:48 8508 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.

2017-04-18 10:07:48 8508 [Warning] option 'innodb-rollback-on-timeout': boolean value '8' wasn't recognized. Set to OFF.

2017-04-18 10:07:48 8508 [Note] Plugin 'FEDERATED' is disabled.

2017-04-18 10:07:48 7f9a73b61720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.

ECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.

2017-04-18 10:07:48 8508 [Note] InnoDB: Using atomics to ref count buffer pool pages

2017-04-18 10:07:48 8508 [Note] InnoDB: The InnoDB memory heap is disabled

2017-04-18 10:07:48 8508 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2017-04-18 10:07:48 8508 [Note] InnoDB: Memory barrier is not used

2017-04-18 10:07:48 8508 [Note] InnoDB: Compressed tables use zlib 1.2.3

2017-04-18 10:07:48 8508 [Note] InnoDB: Using Linux native AIO

2017-04-18 10:07:48 8508 [Note] InnoDB: Not using CPU crc32 instructions

2017-04-18 10:07:48 8508 [Note] InnoDB: Initializing buffer pool, size = 11.0G

2017-04-18 10:07:49 8508 [Note] InnoDB: Completed initialization of buffer pool

2017-04-18 10:07:49 8508 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 768 pages (rounded down to MB) than specified in the .cnf file: initial 32768 pages, max 0 (relevant if non-zero) pages!

2017-04-18 10:07:49 8508 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!

2017-04-18 10:07:49 8508 [ERROR] Plugin 'InnoDB' init function returned error.

2017-04-18 10:07:49 8508 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2017-04-18 10:07:49 8508 [ERROR] Unknown/unsupported storage engine: Innodb

2017-04-18 10:07:49 8508 [ERROR] Aborting

2017-04-18 10:07:49 8508 [Note] Binlog end

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'partition'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'BLACKHOLE'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'ARCHIVE'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_METRICS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_METRICS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_CMPMEM'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_CMP'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_LOCKS'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'INNODB_TRX'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'XTRADB_RSEG'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'XTRADB_READ_VIEW'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'MRG_MYISAM'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'MEMORY'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'MyISAM'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'CSV'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'sha256_password'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'mysql_old_password'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'mysql_native_password'

2017-04-18 10:07:49 8508 [Note] Shutting down plugin 'binlog'

解决方法：

将data目录下的ibdata1 ib_logfile0 ib_logfile1 ib_logfile2删除，重启MySQL即可。

# /etc/init.d/mysql start

Starting MySQL (Percona Server)............ SUCCESS!

# ps -ef|grep mysql

root 8714 1 0 10:10 pts/2 00:00:00 /bin/sh /opt/mysql/bin/mysqld_safe --datadir=/app/mysql-data/data --pid-file=/app/mysql-data/tmp/mysqld.pid

root 9680 8714 0 10:10 pts/2 00:00:09 /opt/mysql/bin/mysqld --basedir=/opt/mysql --datadir=/app/mysql-data/data --plugin-dir=/opt/mysql/lib/mysql/plugin --user=root --log-error=/app/mysql-data/logs/error.log --open-files-limit=65535 --pid-file=/app/mysql-data/tmp/mysqld.pid --socket=/app/mysql-data/run/mysql.sock --port=3306