mysql总是自己关掉，大佬们看看是什么原因

lhspang

vir洛杉矶的小鸡，用的是宝塔国际版，应该是最近才出现的问题，隔几天就自己下线

1. 00:53:57.174300Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
   
2. 00:53:57.174322Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
   
3. 00:53:57.174465Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
   
4. 00:53:57.174590Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.31-log) starting as process 664 ...
   
5. 00:53:57.516934Z 0 [Note] InnoDB: PUNCH HOLE support available
   
6. 00:53:57.517106Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
7. 00:53:57.517128Z 0 [Note] InnoDB: Uses event mutexes
   
8. 00:53:57.517146Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
   
9. 00:53:57.517163Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
   
10. 00:53:57.517180Z 0 [Note] InnoDB: Using Linux native AIO
    
11. 00:53:57.520093Z 0 [Note] InnoDB: Number of pools: 1
    
12. 00:53:57.520589Z 0 [Note] InnoDB: Not using CPU crc32 instructions
    
13. 00:53:57.525188Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    
14. 00:53:57.525380Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
    
15. 00:53:57.525416Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
    
16. 00:53:57.525438Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
    
17. 00:53:57.525471Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
    
18. 00:53:57.525527Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    
19. 00:53:57.525559Z 0 [ERROR] Failed to initialize builtin plugins.
    
20. 00:53:57.525575Z 0 [ERROR] Aborting
    
21. 
    
22. 00:53:57.525610Z 0 [Note] Binlog end
    
23. 00:53:57.525848Z 0 [Note] Shutting down plugin 'CSV'
    
24. 00:53:57.526595Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

复制代码

Tuzi

这写了 开始分配缓存 然后就是挂了    把交换分区   搞大一点吧    或者配置文件改小一点

cicvc

Cannot allocate memory for the buffer pool

周润发

日志不是写了吗 Not using CPU 估计是鸡的问题 CPU不行

txjcv

性能配置太差了。立马换高级独服

黄药师

CPU不行 内存不够

Tuzi

根据服务器内存配置内存参数

Tuzi

Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M    小鸡就别给   128 了

lhspang

Tuzi 发表于 2021-4-12 16:27
Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M    小鸡就别给   128 了 ...

1. total        used        free      shared  buff/cache   available
   
2. Mem:           1740         614         737          16         387         961
   
3. Swap:           255         221          34
   

复制代码

1.7G内存，应该不是内存的问题吧