首页 > Web安全 > 解决:ERROR! The server quit without updating PID file
2017
10-11

解决:ERROR! The server quit without updating PID file

使用的是腾讯云主机,从镜像市场选择的系统+应用,启动mysql的时候报错如下:

Starting MySQL (Percona Server).. ERROR! The server quit without updating PID file (/var/lib/mysql/data/VM_129_111_centos.pid).

网上能搜到的解决方案都尝试了,并没有解决,看具体的数据库错误日志,详细信息如下:


2017-10-11 17:03:35 24532 [Note] Plugin 'FEDERATED' is disabled.
2017-10-11 17:03:35 7f2a135c07e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2017-10-11 17:03:35 24532 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-10-11 17:03:35 24532 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-11 17:03:35 24532 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-10-11 17:03:35 24532 [Note] InnoDB: Memory barrier is not used
2017-10-11 17:03:35 24532 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-11 17:03:35 24532 [Note] InnoDB: Using Linux native AIO
2017-10-11 17:03:35 24532 [Note] InnoDB: Using CPU crc32 instructions
2017-10-11 17:03:35 24532 [Note] InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: mmap(366297088 bytes) failed; errno 12
2017-10-11 17:03:35 24532 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2017-10-11 17:03:35 24532 [ERROR] Plugin 'InnoDB' init function returned error.
2017-10-11 17:03:35 24532 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-10-11 17:03:35 24532 [ERROR] Unknown/unsupported storage engine: INNODB
2017-10-11 17:03:35 24532 [ERROR] Aborting

查看/etc/my.cnf配置文件,发现

innodb_buffer_pool_size=2G

修改为:
innodb_buffer_pool_size=64M
成功解决改报错,这个参数的值是根据物理内存的大小来设置的,如果服务器物理内存过小,建议设置成64M。

最后编辑:
作者:admin
这个作者貌似有点懒,什么都没有留下。

留下一个回复

你的email不会被公开。