mysql频繁自动结束或僵死，自动重启都无用

yanqzh

错误代码：

1. 170622 12:30:03 [Note] Plugin 'FEDERATED' is disabled.
   
2. 170622 12:30:03 InnoDB: The InnoDB memory heap is disabled
   
3. 170622 12:30:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
4. 170622 12:30:03 InnoDB: Compressed tables use zlib 1.2.7
   
5. 170622 12:30:03 InnoDB: Initializing buffer pool, size = 32.0M
   
6. InnoDB: mmap(34340864 bytes) failed; errno 12
   
7. 170622 12:30:03 InnoDB: Completed initialization of buffer pool
   
8. 170622 12:30:03 InnoDB: Fatal error: cannot allocate memory for the buffer pool
   
9. 170622 12:30:03 [ERROR] Plugin 'InnoDB' init function returned error.
   
10. 170622 12:30:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    
11. 170622 12:30:03 [ERROR] Unknown/unsupported storage engine: InnoDB
    
12. 170622 12:30:03 [ERROR] Aborting
    
13. 
    
14. 170622 12:30:03 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
    
15. 
    
16. 170622 12:30:03 mysqld_safe mysqld from pid file /data/var/ebs-47166.pid ended
    
17. 170622 12:31:02 mysqld_safe Starting mysqld daemon with databases from /data/var
    
18. 170622 12:31:02 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48) starting as process 29689 ...
    
19. 170622 12:31:02 [Note] Plugin 'FEDERATED' is disabled.
    
20. 170622 12:31:02 InnoDB: The InnoDB memory heap is disabled
    
21. 170622 12:31:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
22. 170622 12:31:02 InnoDB: Compressed tables use zlib 1.2.7
    
23. 170622 12:31:02 InnoDB: Initializing buffer pool, size = 32.0M
    
24. InnoDB: mmap(34340864 bytes) failed; errno 12
    
25. 170622 12:31:02 InnoDB: Completed initialization of buffer pool
    
26. 170622 12:31:02 InnoDB: Fatal error: cannot allocate memory for the buffer pool
    
27. 170622 12:31:02 [ERROR] Plugin 'InnoDB' init function returned error.
    
28. 170622 12:31:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    
29. 170622 12:31:02 [ERROR] Unknown/unsupported storage engine: InnoDB
    
30. 170622 12:31:02 [ERROR] Aborting
    
31. 
    
32. 170622 12:31:02 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
    
33. 
    
34. 170622 12:31:02 mysqld_safe mysqld from pid file /data/var/ebs-47166.pid ended

复制代码

自动重启代码：

1. #!/bin/bash
   
2. pgrep -x mysqld &> /dev/null
   
3. if [ $? -ne 0 ]
   
4. then
   
5. echo "At time: `date` :MySQL error stop ." >> /home/wwwlogs/mysql_error_stop.log
   
6. /etc/init.d/mysql start
   
7. #echo "At time: `date` :MySQL server is stop."
   
8. else
   
9. echo "MySQL server is running ."
   
10. fi

复制代码

yanqzh

mysql路径从/usr/local/mysql变更为/data/了，但是innode没有变更路径，仍然是/usr/local/mysql

licess

机器什么配置？
innodb_buffer_pool_size 调小些

yanqzh

只有１６Ｍ了，机器内存总共２Ｇ

licess

估计有其他很占内存的程序，mysql都无法进行分配内存，如果不需要innodb可以关闭，就不受这个影响了