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

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

主机2H2G

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

日志：

20061500:37:42mysqld_safeNumberofprocessesrunningnow:0
20061500:37:42mysqld_safemysqldrestarted
2020-06-15 0:37:4347904597051392[Warning]optionmax_allowed_packet:unsignedvalue107374182400adjustedto1073741824
2020-06-15 0:37:4347904597051392[Note]/www/server/mysql/bin/mysqld(mysqld10.1.45-MariaDB)startingasprocess5419...
2020-06-15 0:37:4347904597051392[Note]InnoDB:Usingmutexestorefcountbufferpoolpages
2020-06-15 0:37:4347904597051392[Note]InnoDB:TheInnoDBmemoryheapisdisabled
2020-06-15 0:37:4347904597051392[Note]InnoDB:Mutexesandrw_locksuseGCCatomicbuiltins
2020-06-15 0:37:4347904597051392[Note]InnoDB:GCCbuiltin__atomic_thread_fence()isusedformemorybarrier
2020-06-15 0:37:4347904597051392[Note]InnoDB:Compressedtablesusezlib1.2.7
2020-06-15 0:37:4347904597051392[Note]InnoDB:UsingLinuxnativeAIO
2020-06-15 0:37:4347904597051392[Note]InnoDB:UsingSSEcrc32instructions
2020-06-15 0:37:4347904597051392[Note]InnoDB:Initializingbufferpool,size=768.0M
InnoDB:mmap(843448320bytes)failed;errno12
2020-06-15 0:37:4347904597051392[ERROR]InnoDB:Cannotallocatememoryforthebufferpool
2020-06-15 0:37:4347904597051392[ERROR]PluginInnoDBinitfunctionreturnederror.
2020-06-15 0:37:4347904597051392[ERROR]PluginInnoDBregistrationasaSTORAGEENGINEfailed.
2020-06-15 0:37:4347904597051392[Note]PluginFEEDBACKisdisabled.
2020-06-15 0:37:4347904597051392[ERROR]Unknown/unsupportedstorageengine:InnoDB
2020-06-15 0:37:4347904597051392[ERROR]Aborting

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


网友回复:

引用:xiaozhenghi发表于2020-6-1523:24

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


网友回复:

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

2020-06-15 0:37:4347904597051392[Note]InnoDB:Initializingbufferpool,size=768.0M
InnoDB:mmap(843448320bytes)failed;errno12
2020-06-15 0:37:4347904597051392[ERROR]InnoDB:Cannotallocatememoryforthebufferpool


网友回复:

pgrep-xmysqld&>/dev/null
if[$?-ne0];then

bash/www/server/panel/script/rememory.sh
/etc/init.d/mysqldstart

fi


网友回复:

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


网友回复:

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


网友回复:

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

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


网友回复:

pgrep-xmysqld&>/dev/null

if[$?-ne0];then

  bash/www/server/panel/script/rememory.sh  

  /etc/init.d/mysqldstart    

fi

设置60分钟运行一次