› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
1 个用户可以正常工作，但人数大于 5， mysql 数据库就自动关闭了，求帮助！
yangwenqian · 2016-03-05 15:32:54 +08:00 · 2841 次点击这是一个创建于 3214 天前的主题，其中的信息可能已经有所发展或是发生改变。
以下是错误日志，请问是什么原因导致数据库自动关闭，谢谢。
160305 1:31:42 [Warning] IP address '121.42.0.16' could not be resolved: Name or service not known
160305 1:31:42 [Warning] IP address '121.42.0.16' could not be resolved: Name or service not known
160305 1:44:36 [Warning] IP address '114.215.185.137' could not be resolved: Name or service not known
160305 9:47:51 [Warning] IP address '121.196.244.10' could not be resolved: Name or service not known
Killed
160305 14:55:51 mysqld_safe Number of processes running now: 0
160305 14:55:51 mysqld_safe mysqld restarted
160305 14:55:52 [Note] Plugin 'FEDERATED' is disabled.
160305 14:55:52 InnoDB: The InnoDB memory heap is disabled
160305 14:55:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160305 14:55:52 InnoDB: Compressed tables use zlib 1.2.3
160305 14:55:52 InnoDB: Using Linux native AIO
160305 14:55:52 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
160305 14:55:52 InnoDB: Completed initialization of buffer pool
160305 14:55:52 InnoDB: Fatal error: cannot allocate memory for the buffer pool
160305 14:55:52 [ERROR] Plugin 'InnoDB' init function returned error.
160305 14:55:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160305 14:55:52 [ERROR] Unknown/unsupported storage engine: InnoDB
160305 14:55:52 [ERROR] Aborting
160305 14:55:52 [Note] /alidata/server/mysql/bin/mysqld: Shutdown complete
160305 14:55:52 mysqld_safe mysqld from pid file /alidata/server/mysql/data/iZ2892tr3o4Z.pid ended
160305 1:31:42 [Warning] IP address '121.42.0.16' could not be resolved: Name or service not known
160305 1:31:42 [Warning] IP address '121.42.0.16' could not be resolved: Name or service not known
160305 1:44:36 [Warning] IP address '114.215.185.137' could not be resolved: Name or service not known
160305 9:47:51 [Warning] IP address '121.196.244.10' could not be resolved: Name or service not known
Killed
160305 14:55:51 mysqld_safe Number of processes running now: 0
160305 14:55:51 mysqld_safe mysqld restarted
160305 14:55:52 [Note] Plugin 'FEDERATED' is disabled.
160305 14:55:52 InnoDB: The InnoDB memory heap is disabled
160305 14:55:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160305 14:55:52 InnoDB: Compressed tables use zlib 1.2.3
160305 14:55:52 InnoDB: Using Linux native AIO
160305 14:55:52 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
160305 14:55:52 InnoDB: Completed initialization of buffer pool
160305 14:55:52 InnoDB: Fatal error: cannot allocate memory for the buffer pool
160305 14:55:52 [ERROR] Plugin 'InnoDB' init function returned error.
160305 14:55:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160305 14:55:52 [ERROR] Unknown/unsupported storage engine: InnoDB
160305 14:55:52 [ERROR] Aborting
160305 14:55:52 [Note] /alidata/server/mysql/bin/mysqld: Shutdown complete
160305 14:55:52 mysqld_safe mysqld from pid file /alidata/server/mysql/data/iZ2892tr3o4Z.pid ended
 |
1
6IbA2bj5ip3tK49j 2016-03-05 15:47:54 +08:00
|
 |
2
vibbow 2016-03-06 08:00:45 +08:00
简单总结一下：内存不足
|
Select Language