死siua11 发表于 2018-10-8 08:04:40

MySQL无法启动——cannot allocate the memory for the buffer pool

  2017-08-13 13:40:27 19011 InnoDB: Initializing buffer pool,>  InnoDB: mmap(137363456 bytes) failed; errno 12
  2017-08-13 13:40:27 19011 InnoDB: Cannot allocate memory for the buffer pool
  2017-08-13 13:40:27 19011 Plugin 'InnoDB' init function returned error.
  2017-08-13 13:40:27 19011 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  2017-08-13 13:40:27 19011 Unknown/unsupported storage engine: InnoDB
  2017-08-13 13:40:27 19011 Aborting
  # free -m发现内存不足
  解决办法:
  在my.cnf添加以下字段
  innodb_buffer_pool_size=200M
  key_buffer=120M

页: [1]
查看完整版本: MySQL无法启动——cannot allocate the memory for the buffer pool