有懂数据库问题的大佬吗？

chingwp

日志是这样的


[ol]

180816 17:21:33 [Note] Plugin 'FEDERATED' is disabled.

180816 17:21:33 InnoDB: The InnoDB memory heap is disabled

180816 17:21:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins

180816 17:21:33 InnoDB: Compressed tables use zlib 1.2.7

180816 17:21:33 InnoDB: Using Linux native AIO

180816 17:21:33 InnoDB: Initializing buffer pool, size = 64.0M

180816 17:21:33 InnoDB: Completed initialization of buffer pool

180816 17:21:33 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!

180816 17:21:33  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: Last MySQL binlog file position 0 208033197, file name ./mysql-bin.000005

180816 17:21:34  InnoDB: Waiting for the background threads to start

180816 17:21:35 InnoDB: 5.5.57 started; log sequence number 2437265

180816 17:21:35 [Note] Recovering after a crash using mysql-bin

180816 17:21:35 [Note] Starting crash recovery...

180816 17:21:35 [Note] Crash recovery finished.

180816 17:21:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

180816 17:21:35 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

180816 17:21:35 [Note] Server socket created on IP: '0.0.0.0'.

180816 17:21:35 [Note] Event Scheduler: Loaded 0 events

180816 17:21:35 [Note] /www/server/mysql/bin/mysqld: ready for connections.

Version: '5.5.57-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution[/ol]复制代码

Eric.c

chingwp 发表于 2018-8-17 11:53

只有三个站， 2G内存的话应该够用吧

要去猜你的问题，基本都懒得看了。

----
日志说得明白了， 你的inodb崩溃了，也修复了。然后重启了，没了。


InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!

h2o

内存不够被kill了？

chingwp

h2o 发表于 2018-8-17 10:22

内存不够被kill了？
只有三个站， 2G内存的话应该够用吧

lzhd24

楼上大佬正解

foboy

内存不够可以来点虚拟内存

xsmx

负载测试其实是很必要的，另外如果只是偶尔这么一次，你其实不必太在意的。以前我没钱的时候，用很差的鸡也是隔段时间会崩一下什么的，只要注意些，不会有太大影响。

chingwp

本帖最后由 chingwp 于 2018-8-17 18:03 编辑

Eric.c 发表于 2018-8-17 12:51

要去猜你的问题，基本都懒得看了。

----



谢谢大佬回复 。。。我大概知道是问题出在 inodb ，但是不知道该怎么解决，是因为内存过小么？

这是mysql 的配置

default_storage_engine = InnoDB
innodb_data_home_dir = /www/server/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /www/server/data
innodb_buffer_pool_size = 64M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 64M
innodb_log_buffer_size = 12M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 120
innodb_max_dirty_pages_pct = 90
innodb_read_io_threads = 2
innodb_write_io_threads = 2
innodb_force_recovery=1