VPS侦探论坛

 找回密码
 注册
查看: 2684|回复: 1

mysql 连接失败的问题,请大佬帮忙看看

[复制链接]
发表于 2019-4-27 16:20:18 | 显示全部楼层 |阅读模式

最近网站经常出现数据库连接失败的问题,日志如下:
  1. 190419  0:35:04 [Note] Plugin 'FEDERATED' is disabled.
  2. 190419  0:35:04 InnoDB: The InnoDB memory heap is disabled
  3. 190419  0:35:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  4. 190419  0:35:04 InnoDB: Compressed tables use zlib 1.2.7
  5. 190419  0:35:04 InnoDB: Using Linux native AIO
  6. 190419  0:35:04 InnoDB: Initializing buffer pool, size = 1.0G
  7. InnoDB: mmap(1098907648 bytes) failed; errno 12
  8. 190419  0:35:04 InnoDB: Completed initialization of buffer pool
  9. 190419  0:35:04 InnoDB: Fatal error: cannot allocate memory for the buffer pool
  10. 190419  0:35:04 [ERROR] Plugin 'InnoDB' init function returned error.
  11. 190419  0:35:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  12. 190419  0:35:04 [ERROR] Unknown/unsupported storage engine: InnoDB
  13. 190419  0:35:04 [ERROR] Aborting

  14. 190419  0:35:04 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

  15. 190419  0:35:51 [Note] Plugin 'FEDERATED' is disabled.
  16. 190419  0:35:51 InnoDB: The InnoDB memory heap is disabled
  17. 190419  0:35:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  18. 190419  0:35:51 InnoDB: Compressed tables use zlib 1.2.7
  19. 190419  0:35:51 InnoDB: Using Linux native AIO
  20. 190419  0:35:51 InnoDB: Initializing buffer pool, size = 1.0G
  21. 190419  0:35:51 InnoDB: Completed initialization of buffer pool
  22. 190419  0:35:51 InnoDB: highest supported file format is Barracuda.
  23. InnoDB: The log sequence number in ibdata files does not match
  24. InnoDB: the log sequence number in the ib_logfiles!
  25. 190419  0:35:51  InnoDB: Database was not shut down normally!
  26. InnoDB: Starting crash recovery.
  27. InnoDB: Reading tablespace information from the .ibd files...
  28. InnoDB: Restoring possible half-written data pages from the doublewrite
  29. InnoDB: buffer...
  30. InnoDB: Last MySQL binlog file position 0 19465650, file name ./mysql-bin.000030
  31. 190419  0:35:51  InnoDB: Waiting for the background threads to start
  32. 190419  0:35:52 InnoDB: 5.5.60 started; log sequence number 3215952
  33. 190419  0:35:52 [Note] Recovering after a crash using mysql-bin
  34. 190419  0:35:53 [Note] Starting crash recovery...
  35. 190419  0:35:53 [Note] Crash recovery finished.
  36. 190419  0:35:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  37. 190419  0:35:53 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  38. 190419  0:35:53 [Note] Server socket created on IP: '0.0.0.0'.
  39. 190419  0:35:54 [Note] Event Scheduler: Loaded 0 events
  40. 190419  0:35:54 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  41. Version: '5.5.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
复制代码
求老大帮忙看看是什么问题,谢谢
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2019-4-27 20:21:23 | 显示全部楼层
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-9-22 21:29 , Processed in 0.024868 second(s), 17 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表