全球主机交流论坛

标题: mysql总是自己关掉，大佬们看看是什么原因 [打印本页]
作者: lhspang    时间: 2021-4-12 16:19
标题: mysql总是自己关掉，大佬们看看是什么原因
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

  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
复制代码
作者: cicvc    时间: 2021-4-12 16:20
Cannot allocate memory for the buffer pool
作者: 周润发    时间: 2021-4-12 16:21
日志不是写了吗 Not using CPU 估计是鸡的问题 CPU不行
作者: h20    时间: 2021-4-12 16:23
提示: 作者被禁止或删除 内容自动屏蔽
作者: txjcv    时间: 2021-4-12 16:23
性能配置太差了。立马换高级独服
作者: 黄药师    时间: 2021-4-12 16:25
CPU不行 内存不够
作者: Tuzi    时间: 2021-4-12 16:26
根据服务器内存配置内存参数
作者: Tuzi    时间: 2021-4-12 16:27
Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M    小鸡就别给   128 了
作者: lhspang    时间: 2021-4-12 16:35
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内存，应该不是内存的问题吧
作者: Tuzi    时间: 2021-4-12 16:49
这写了 开始分配缓存 然后就是挂了    把交换分区   搞大一点吧    或者配置文件改小一点



欢迎光临 全球主机交流论坛 (https://mjj.022333.xyz/) Powered by Discuz! X3.4