解决mysql启动报错Starting MySQL.Manager of pid-file quit without updating file
来源:互联网 发布:阿里云80端口备案 编辑:程序博客网 时间:2024/05/07 17:36
解决mysql启动报错Starting MySQL.Manager of pid-file quit without updating file
错误日志:
120924 15:53:34 mysqld_safe Starting mysqld daemon with databases from /data0/mysql/3306/data
120924 15:53:34 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
120924 15:53:34 InnoDB: Initializing buffer pool, size = 8.0M
120924 15:53:34 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120924 15:53:34 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Page directory corruption: infimum not pointed to
120924 15:53:34 InnoDB: Page dump in ascii and hex (16384 bytes):
注意这句:
InnoDB: The log sequence number in ibdata files does not match
InnoDB的:在ibdata文件的日志序列号不匹配
可能ibdata文件损坏了
解决办法如下:
在my.cny 的[mysqld]中加入
错误日志:
120924 15:53:34 mysqld_safe Starting mysqld daemon with databases from /data0/mysql/3306/data
120924 15:53:34 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
120924 15:53:34 InnoDB: Initializing buffer pool, size = 8.0M
120924 15:53:34 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120924 15:53:34 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Page directory corruption: infimum not pointed to
120924 15:53:34 InnoDB: Page dump in ascii and hex (16384 bytes):
注意这句:
InnoDB: The log sequence number in ibdata files does not match
InnoDB的:在ibdata文件的日志序列号不匹配
可能ibdata文件损坏了
解决办法如下:
在my.cny 的[mysqld]中加入
# Size of each log file in a log group. You should set the combined size# of log files to about 25%-100% of your buffer pool size to avoid# unneeded buffer pool flush activity on log file overwrite. However,# note that a larger logfile size will increase the time needed for the# recovery process.innodb_log_file_size=10M# Number of threads allowed inside the InnoDB kernel. The optimal value# depends highly on the application, hardware as well as the OS# scheduler properties. A too high value may lead to thread thrashing.innodb_thread_concurrency=8innodb_force_recovery = 4max_allowed_packet=16M
- 解决mysql启动报错Starting MySQL.Manager of pid-file quit without updating file
- 启动mysql 报错,,Starting MySQL.Manager of pid-file quit without updating fi[失败]
- 解决Linux下MySQL启动错误Starting MySQL.Manager of pid-file quit without updating file
- 启动mysql报错(Starting MySQL..Manager of pid-file quit without updating f[失败]) 解决方法集锦
- 启动mysql报错(Starting MySQL..Manager of pid-file quit without updating f[失败]) 解决方法集锦
- 启动mysql报错(starting mysql..manager of pid-file quit without updating f[失败]) 解决方法集锦
- 启动mysql报错(Starting MySQL..Manager of pid-file quit without updating f[失败]) 解决方法集锦
- 启动mysql报错(Starting MySQL..Manager of pid-file quit without updating f[失败]) 解决方法集锦
- 启动mysql报错(starting mysql..manager of pid-file quit without updating f[失败]) 解决方法集锦
- Starting MySQL.Manager of pid-file quit without updating
- MYSQL解决Starting MySQL..Manager of pid-file quit without updating file
- linux 出现: Starting MySQL.Manager of pid-file quit without updating file.[FAILED] 已解决
- linux 出现: Starting MySQL.Manager of pid-file quit without updating file.[FAILED] 已解决
- 关于mysql启动时的Starting MySQL..Manager of pid-file quit without updating提示
- centos 安装mysql,启动时报错Starting MySQL.Manager of pid-file quit without updating file.[FAILED]
- 【解决】Starting MySQL.Manager of pid-file quit without updating fi[失败]
- 启动mysql 报错,,Starting MySQL.Manager of pid-file quit without updating fi[失败] (2011-10-28 12:30:56)转载▼
- mysql数据库启动报错Starting MySQL.The server quit without updating PID file..
- Python多进程并发(multiprocessing)
- java url编码与解码 (钓鱼岛是中国的!)
- ProtoBuf开发者指南
- Binary Tree Inorder Traversal
- 跨平台项目组织
- 解决mysql启动报错Starting MySQL.Manager of pid-file quit without updating file
- java.lang.NoSuchMethodError: org.apache.log4j.Category.log
- 念,心随君浅舞天涯
- 许多同学应该都还记得联考前夕的焦虑
- ubuntu12.04中opencv静态编译
- Mysql5.6安装步骤(图解)
- My Birthday
- nginx rewrite中last和break的区别
- 错误——自我提高的垫脚石