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

chingwp

日志是这样的

1. 180816 17:21:33 [Note] Plugin 'FEDERATED' is disabled.
   
2. 180816 17:21:33 InnoDB: The InnoDB memory heap is disabled
   
3. 180816 17:21:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
4. 180816 17:21:33 InnoDB: Compressed tables use zlib 1.2.7
   
5. 180816 17:21:33 InnoDB: Using Linux native AIO
   
6. 180816 17:21:33 InnoDB: Initializing buffer pool, size = 64.0M
   
7. 180816 17:21:33 InnoDB: Completed initialization of buffer pool
   
8. 180816 17:21:33 InnoDB: highest supported file format is Barracuda.
   
9. InnoDB: The log sequence number in ibdata files does not match
   
10. InnoDB: the log sequence number in the ib_logfiles!
    
11. 180816 17:21:33  InnoDB: Database was not shut down normally!
    
12. InnoDB: Starting crash recovery.
    
13. InnoDB: Reading tablespace information from the .ibd files...
    
14. InnoDB: Restoring possible half-written data pages from the doublewrite
    
15. InnoDB: buffer...
    
16. InnoDB: Last MySQL binlog file position 0 208033197, file name ./mysql-bin.000005
    
17. 180816 17:21:34  InnoDB: Waiting for the background threads to start
    
18. 180816 17:21:35 InnoDB: 5.5.57 started; log sequence number 2437265
    
19. 180816 17:21:35 [Note] Recovering after a crash using mysql-bin
    
20. 180816 17:21:35 [Note] Starting crash recovery...
    
21. 180816 17:21:35 [Note] Crash recovery finished.
    
22. 180816 17:21:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    
23. 180816 17:21:35 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    
24. 180816 17:21:35 [Note] Server socket created on IP: '0.0.0.0'.
    
25. 180816 17:21:35 [Note] Event Scheduler: Loaded 0 events
    
26. 180816 17:21:35 [Note] /www/server/mysql/bin/mysqld: ready for connections.
    
27. Version: '5.5.57-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

复制代码

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!

chingwp

h2o 发表于 2018-8-17 10:22
内存不够被kill了？

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

xsmx

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

chingwp

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