修改配置参数后无法启程MySQL数据库
来源:互联网 发布:炒股神经病 知乎 编辑:程序博客网 时间:2024/06/05 16:40
修改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
0 0
- 修改配置参数后无法启程MySQL数据库
- 修改mysql数据库密码后phpMyAdmin无法连接数据库解决方法
- 修改mysql数据库密码后phpMyAdmin无法连接数据库
- 修改Spfile参数文件后无法打开数据库
- wampserver修改mysql数据库密码后phpMyAdmin无法登陆
- linux下修改mysql数据库编码后无法启动解决办法
- 用phpMyAdmin修改mysql数据库密码后无法登录
- MySQL数据库参数配置
- mysql 数据库参数配置
- 动态修改MYSQL配置参数
- 动态修改MYSQL配置参数
- SqlServer数据库数据表修改后无法保存
- 远程Linux服务器修改Mysql数据库编码及解决编码修改后Mysql无法启动的问题
- mysql修改密码后,phpMyadmin无法登陆
- mysql修改密码后,phpMyadmin无法登陆
- MySql修改密码后PhpAdmin无法登陆
- MySql修改密码后PhpMyAdmin无法登陆
- windows server 2008系统中修改mysql数据库路径datadi后无法启动问题
- HTML5 移动Web App阅读器-4(页面基本结构开发)
- poj 1731 Orders(库函数运用)
- 关于js 点击所在行,获取隐藏域问题
- linux内核进程退出分析
- ARC 下的内存泄露
- 修改配置参数后无法启程MySQL数据库
- 博文要有的元素
- iOS 开发之 pdf 文档的加载与浏览的 4 种方式
- extjs4.2导出excel表格
- Java Expression Language (JEXL)
- redis 数据类型详解 以及 redis适用场景场合
- Android线程及进程笔记
- chrome打不开plugins
- 各大互联网公司前端笔试面试题–HTML,CSS篇