服务器 Gind.cn
  1. 服务器 Gind.cn
  3. MySQL（MariaDB）崩溃
Intereting Posts
sql server使用内存 IIS是否支持将特定的URLredirect到备用位置/镜像列表？ 我如何从日志文件中删除IP地址 不常用的字符不在Nginx中加载Drupal Boost静态caching Linux TCP连接超时长度不一致 如何安全地禁止用户的密码通过木偶？ IBM x3650 M3 – RSA（IMM）在操作系统安装期间退出，不可用 VBScript-inputDisplayName输出AD用户名 128位和256位AESencryption算是弱？ sftp服务器的chroot初始目录 帮助期待脚本，运行远程压缩猫并获得输出到variables 我应该如何强制某些path使用https？ 分离屏幕会话 什么是IIS6网站/应用程序池可以使用的最大内存？ 单击确定以修改域上的HKLM \ Software \ Policies和HKCU \ SOFTWARE \ Policies？

MySQL（MariaDB）崩溃

早上好 – 我已经回顾了以前的一篇文章，关于将性能模式改为“在configuration设置中closures”，看起来好像我们的configuration已经设置为这个，所以不知道是什么原因导致了崩溃的问题。 

[root@#### etc]# vim my.cnf [mysqld] general_log = 1 general_log_file=/var/log/mariadb/query.log datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock symbolic-links=0 innodb_file_per_table = 1 #thread_stack = 131072 # mgk change 11/23/15 thread_stack = 256k net_buffer_length = 2K read_rnd_buffer_size = 256K read_buffer_size = 256K sort_buffer_size = 64K table_open_cache = 4 max_allowed_packet = 1M key_buffer_size = 16K performance_schema = off

这是一个日志摘要 

 InnoDB: mmap(137756672 bytes) failed; errno 12 160329 11:44:50 InnoDB: Completed initialization of buffer pool 160329 11:44:50 InnoDB: Fatal error: cannot allocate memory for the buffer pool 160329 11:44:50 [ERROR] Plugin 'InnoDB' init function returned error. 160329 11:44:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 160329 11:44:50 [ERROR] mysqld: Out of memory (Needed 128917504 bytes) 160329 11:44:50 [ERROR] mysqld: Out of memory (Needed 96681984 bytes) 160329 11:44:50 [Note] Plugin 'FEEDBACK' is disabled. 160329 11:44:50 [ERROR] Unknown/unsupported storage engine: InnoDB 160329 11:44:50 [ERROR] Aborting 160329 11:44:50 [Note] /usr/libexec/mysqld: Shutdown complete 160329 11:44:50 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended 160329 12:46:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 160329 12:46:48 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB-log) starting as process 7488 ... 160329 12:46:48 InnoDB: The InnoDB memory heap is disabled 160329 12:46:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins 160329 12:46:48 InnoDB: Compressed tables use zlib 1.2.7 160329 12:46:48 InnoDB: Using Linux native AIO 160329 12:46:48 InnoDB: Initializing buffer pool, size = 128.0M 160329 12:46:48 InnoDB: Completed initialization of buffer pool 160329 12:46:48 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 2502249177 160329 12:46:48 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery.

160329 11:44:50 [错误] mysqld：内存不足（需要96681984字节）

每@ michael-sqlbot看起来像Ubuntu 12.04服务器 – MySQL不断崩溃 – 可能的InnoDB问题 – 服务器故障涵盖了你的问题。