标题: [求助] WDCP重装后mysql经常死机，有wordpress网站 [打印本页]

---

作者: bb120    时间: 2019-6-28 16:45     标题: WDCP重装后mysql经常死机，有wordpress网站

采用单apache服务器，数据库使用mv命令移动的。现在一天要死机好几次，已经确认只有mysql死机。下面是mysql日志

1. 2019-06-28 16:52:13 10299 [Note] InnoDB: Using atomics to ref count buffer pool pages
   
2. 2019-06-28 16:52:13 10299 [Note] InnoDB: The InnoDB memory heap is disabled
   
3. 2019-06-28 16:52:13 10299 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
4. 2019-06-28 16:52:13 10299 [Note] InnoDB: Memory barrier is not used
   
5. 2019-06-28 16:52:13 10299 [Note] InnoDB: Compressed tables use zlib 1.2.11
   
6. 2019-06-28 16:52:13 10299 [Note] InnoDB: Not using CPU crc32 instructions
   
7. 2019-06-28 16:52:13 10299 [Note] InnoDB: Initializing buffer pool, size = 128.0M
   
8. InnoDB: mmap(136019968 bytes) failed; errno 12
   
9. 2019-06-28 16:52:13 10299 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
   
10. 2019-06-28 16:52:13 10299 [ERROR] Plugin 'InnoDB' init function returned error.
    
11. 2019-06-28 16:52:13 10299 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    
12. 2019-06-28 16:52:13 10299 [ERROR] Unknown/unsupported storage engine: InnoDB
    
13. 2019-06-28 16:52:13 10299 [ERROR] Aborting

复制代码

my.cnf配置如下：

1. # For advice on how to change settings please see
   
2. # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
   
3. 
   
4. [mysqld]
   
5. #add @190623 by alber https://www.7hubei.com/272.html
   
6. federated
   
7. innodb_force_recovery=1
   
8. 
   
9. # Remove leading # and set to the amount of RAM for the most important data
   
10. # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    
11. # innodb_buffer_pool_size = 128M
    
12. 
    
13. # Remove leading # to turn on a very important data integrity option: logging
    
14. # changes to the binary log between backups.
    
15. # log_bin
    
16. 
    
17. # These are commonly set, remove the # and set as required.
    
18. # basedir = .....
    
19. # datadir = /var/lib/mysql
    
20. # port = .....
    
21. # server_id = .....
    
22. # socket = /var/lib/mysql/mysql.sock
    
23. 
    
24. # Remove leading # to set options mainly useful for reporting servers.
    
25. # The server defaults are faster for transactions and fast SELECTs.
    
26. # Adjust sizes as needed, experiment to find the optimal values.
    
27. # join_buffer_size = 128M
    
28. # sort_buffer_size = 2M
    
29. # read_rnd_buffer_size = 2M
    
30. 
    
31. 
    
32. performance_schema_max_table_instances=400
    
33. table_definition_cache=400
    
34. table_open_cache=256
    
35. 
    
36. sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

复制代码

求大神指点

---

作者: admin    时间: 2019-6-28 22:59

内存有溢出，不支持innodb引擎

---

作者: bb120    时间: 2019-6-29 17:28

回复 2# admin

能麻烦问一下什么解决这个？

---

欢迎光临 WDlinux官方论坛 (http://www.wdlinux.cn/bbs/)

Powered by Discuz! 7.2