Board logo

标题: [求助] mysql服务运行好好的无故会出现连接不上的问题 [打印本页]

作者: yoer    时间: 2018-2-22 15:47     标题: mysql服务运行好好的无故会出现连接不上的问题

  1. 180221 18:59:58  InnoDB: Waiting for the background threads to start
  2. 180221 18:59:59 InnoDB: 5.5.54 started; log sequence number 6827662
  3. 180221 18:59:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  4. 180221 18:59:59 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  5. 180221 18:59:59 [Note] Server socket created on IP: '0.0.0.0'.
  6. 180221 18:59:59 [Note] Event Scheduler: Loaded 0 events
  7. 180221 18:59:59 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: ready for connections.
  8. Version: '5.5.54'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
  9. 180222  3:27:38 [Note] Plugin 'FEDERATED' is disabled.
  10. 180222  3:27:38 InnoDB: The InnoDB memory heap is disabled
  11. 180222  3:27:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  12. 180222  3:27:38 InnoDB: Compressed tables use zlib 1.2.3
  13. 180222  3:27:38 InnoDB: Initializing buffer pool, size = 128.0M
  14. InnoDB: mmap(137363456 bytes) failed; errno 12
  15. 180222  3:27:38 InnoDB: Completed initialization of buffer pool
  16. 180222  3:27:38 InnoDB: Fatal error: cannot allocate memory for the buffer pool
  17. 180222  3:27:38 [ERROR] Plugin 'InnoDB' init function returned error.
  18. 180222  3:27:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  19. 180222  3:27:38 [ERROR] Unknown/unsupported storage engine: InnoDB
  20. 180222  3:27:38 [ERROR] Aborting

  21. 180222  3:27:38 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: Shutdown complete

  22. 180222 15:09:14 [Note] Plugin 'FEDERATED' is disabled.
  23. 180222 15:09:14 InnoDB: The InnoDB memory heap is disabled
  24. 180222 15:09:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  25. 180222 15:09:14 InnoDB: Compressed tables use zlib 1.2.3
  26. 180222 15:09:14 InnoDB: Initializing buffer pool, size = 128.0M
  27. 180222 15:09:14 InnoDB: Completed initialization of buffer pool
  28. 180222 15:09:14 InnoDB: highest supported file format is Barracuda.
  29. InnoDB: The log sequence number in ibdata files does not match
  30. InnoDB: the log sequence number in the ib_logfiles!
  31. 180222 15:09:14  InnoDB: Database was not shut down normally!
  32. InnoDB: Starting crash recovery.
  33. InnoDB: Reading tablespace information from the .ibd files...
  34. InnoDB: Restoring possible half-written data pages from the doublewrite
  35. InnoDB: buffer...
  36. 180222 15:09:15  InnoDB: Waiting for the background threads to start
  37. 180222 15:09:16 InnoDB: 5.5.54 started; log sequence number 6827672
  38. 180222 15:09:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  39. 180222 15:09:16 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  40. 180222 15:09:16 [Note] Server socket created on IP: '0.0.0.0'.
  41. 180222 15:09:16 [Note] Event Scheduler: Loaded 0 events
  42. 180222 15:09:16 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: ready for connections.
  43. Version: '5.5.54'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
复制代码


摘取以上错误日志,昨晚7点重启后恢复,凌晨3点就出现错误了,下午15点重启后又恢复正常。经常出现这个问题,需要手动重启才行。看不懂日志,求大神帮助。




欢迎光临 WDlinux官方论坛 (http://www.wdlinux.cn/bbs/) Powered by Discuz! 7.2