[求助] mysql服務(wù)運(yùn)行好好的無(wú)故會(huì)出現(xiàn)連接不上的問(wèn)題

yoer

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

復(fù)制代碼

摘取以上錯(cuò)誤日志，昨晚7點(diǎn)重啟后恢復(fù)，凌晨3點(diǎn)就出現(xiàn)錯(cuò)誤了，下午15點(diǎn)重啟后又恢復(fù)正常。經(jīng)常出現(xiàn)這個(gè)問(wèn)題，需要手動(dòng)重啟才行�？床欢�日志，求大神幫助。