解决mysql启动报错Starting MySQL.Manager of pid-file quit without updating file

解决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]中加入
# 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=8

innodb_force_recovery = 4

max_allowed_packet=16M
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值