求助BT大神，数据库老是自动停止

多多打折

BT 7.2免费版，数据库每隔一两天就自动停止，每次手动重启，疯了。。。

主机 2H2G

InnoDB_buffer_pool_size 默认就128，试过64，试过768，还是一样停止。。。

日志：

1. 
   
2. 200615 00:37:42 mysqld_safe Number of processes running now: 0
   
3. 200615 00:37:42 mysqld_safe mysqld restarted
   
4. 2020-06-15  0:37:43 47904597051392 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
   
5. 2020-06-15  0:37:43 47904597051392 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.45-MariaDB) starting as process 5419 ...
   
6. 2020-06-15  0:37:43 47904597051392 [Note] InnoDB: Using mutexes to ref count buffer pool pages
   
7. 2020-06-15  0:37:43 47904597051392 [Note] InnoDB: The InnoDB memory heap is disabled
   
8. 2020-06-15  0:37:43 47904597051392 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
9. 2020-06-15  0:37:43 47904597051392 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
   
10. 2020-06-15  0:37:43 47904597051392 [Note] InnoDB: Compressed tables use zlib 1.2.7
    
11. 2020-06-15  0:37:43 47904597051392 [Note] InnoDB: Using Linux native AIO
    
12. 2020-06-15  0:37:43 47904597051392 [Note] InnoDB: Using SSE crc32 instructions
    
13. 2020-06-15  0:37:43 47904597051392 [Note] InnoDB: Initializing buffer pool, size = 768.0M
    
14. InnoDB: mmap(843448320 bytes) failed; errno 12
    
15. 2020-06-15  0:37:43 47904597051392 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
    
16. 2020-06-15  0:37:43 47904597051392 [ERROR] Plugin 'InnoDB' init function returned error.
    
17. 2020-06-15  0:37:43 47904597051392 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    
18. 2020-06-15  0:37:43 47904597051392 [Note] Plugin 'FEEDBACK' is disabled.
    
19. 2020-06-15  0:37:43 47904597051392 [ERROR] Unknown/unsupported storage engine: InnoDB
    
20. 2020-06-15  0:37:43 47904597051392 [ERROR] Aborting
    

复制代码

yifast07

服务器的问题吧   你去bt论坛去问问

xiaozhenghi

我写了个脚本，每三分钟监测一下mysql的活动性，死了就启动下

inkedus

xiaozhenghi 发表于 2020-6-15 23:24
我写了个脚本，每三分钟监测一下mysql的活动性，死了就启动下

牛逼啊，分享出来给mjj们玩玩吧

shc

MySQL经常挂大概率是内存不够

1. 2020-06-15  0:37:43 47904597051392 [Note] InnoDB: Initializing buffer pool, size = 768.0M
   
2. InnoDB: mmap(843448320 bytes) failed; errno 12
   
3. 2020-06-15  0:37:43 47904597051392 [ERROR] InnoDB: Cannot allocate memory for the buffer pool

复制代码

768M太大了，系统没有那么多内存分配出来

xiaozhenghi

1. pgrep -x mysqld &> /dev/null
   
2. if [ $? -ne 0 ];then
   
3.         bash /www/server/panel/script/rememory.sh
   
4.         /etc/init.d/mysqld start
   
5. fi

复制代码

任务计划，shell脚本，间隔三分钟，三分钟监测一下，挂了就重启下mysql，反正前端是cdn，三分钟也看不出来死了没就过去了

你好，再见

把Nginx的处理进程调少点试试，不要Auto

hdwz88

重装基本能解决全部问题 估计是你LINUX系统版本缺少组件

嗷嗷

可能是内存问题 ⁢⁢⁢⁢⁢

1767196823

内存不够，，，我之前用的那种超开ovz，，，1H2G  安装数据库，，时不时就停止

换了其他商家就好了，，，，多半是服务器内存问题，，肯定超开严重