遇到一个很棘手的mysql环境问题

零点钟 发布于 2013/07/01 22:33
阅读 583
收藏 1

mysql日志报:

130701 22:04:02 mysqld_safe Number of processes running now: 0
130701 22:04:02 mysqld_safe mysqld restarted
130701 22:04:02 [Note] Plugin 'FEDERATED' is disabled.
130701 22:04:02 InnoDB: The InnoDB memory heap is disabled
130701 22:04:02 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
130701 22:04:02 InnoDB: Compressed tables use zlib 1.2.3
130701 22:04:02 InnoDB: Initializing buffer pool, size = 16.0M
130701 22:04:02 InnoDB: Completed initialization of buffer pool
130701 22:04:02 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130701 22:04:03  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...

以上错误, mysql 就挂掉了

我在安装wordpress 的时候挂掉的. 

环境: 阿里云 Ubuntu 12.04 64位, lampp

求问题解决方案. 感谢大侠们.

加载中
0
Cavalier
Cavalier
他貌似说的是你没有正常关闭mysql 然后恢复数据的时间挂掉的
0
马马来
马马来
Mark,等高手。
0
首席安全砖家
首席安全砖家
130701 22:04:02 [Note] Plugin 'FEDERATED' is disabled.

130701 22:04:02 InnoDB: The InnoDB memory heap is disabled

上次 也看到有个人提过这个问题,你自己在问答模块里面找找

0
首席安全砖家
首席安全砖家

http://www.oschina.net/question/2962_115815 

这里,一模一样的问题。

好像是innodB的问题。

 

0
零点钟
零点钟

引用来自“钟晓骏”的答案

http://www.oschina.net/question/2962_115815 

这里,一模一样的问题。

好像是innodB的问题。

 

InnoDB 的问题. 看日志..没能分析出来原因.~我在尝试一下~
0
零点钟
零点钟

引用来自“钟晓骏”的答案

http://www.oschina.net/question/2962_115815 

这里,一模一样的问题。

好像是innodB的问题。

 

Killed


130702 09:49:56 mysqld_safe Number of processes running now: 0
130702 09:49:56 mysqld_safe mysqld restarted
130702  9:49:56 [Note] Plugin 'FEDERATED' is disabled.
130702  9:49:56 InnoDB: The InnoDB memory heap is disabled
130702  9:49:56 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
130702  9:49:56 InnoDB: Compressed tables use zlib 1.2.3
130702  9:49:57 InnoDB: Initializing buffer pool, size = 10.0M
130702  9:49:57 InnoDB: Completed initialization of buffer pool
130702  9:49:57 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 14851053
130702  9:49:57  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: Doing recovery: scanned up to log sequence number 14870585
130702  9:49:59  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
130702  9:50:00  InnoDB: Waiting for the background threads to start
130702  9:50:01 InnoDB: 1.1.8 started; log sequence number 14870585
130702  9:50:01 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130702  9:50:01 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130702  9:50:01 [Note] Server socket created on IP: '0.0.0.0'.
130702  9:50:02 [Note] Event Scheduler: Loaded 0 events
130702  9:50:02 [Note] /opt/lampp/sbin/mysqld: ready for connections.

Version: '5.5.27'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution

我按照他http://www.oschina.net/question/2962_115815 的修改 innodb_buffer_pool_size 修改成10M

就变成上面的问题了~

0
零点钟
零点钟

引用来自“钟晓骏”的答案

130701 22:04:02 [Note] Plugin 'FEDERATED' is disabled.

130701 22:04:02 InnoDB: The InnoDB memory heap is disabled

上次 也看到有个人提过这个问题,你自己在问答模块里面找找

他的问题与我的不同.~
0
错觉
错觉

哥们解决mysql无限重启的问题了吗

返回顶部
顶部