当前位置:Gxlcms > mysql > mysql启动过程中报错_MySQL

mysql启动过程中报错_MySQL

时间:2021-07-01 10:21:17 帮助过:34人阅读

今天给阿里云的机器安装mysql,安装完成后,启动的时候报错The server quit without updating PID file (/data/mysql/AY140710163143738066Z.pid).

mysql的配置我用的是默认配置,没有新添加错误,查看了下错误日志:

2014-07-11 10:14:25 2267 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2014-07-11 10:14:25 2267 [ERROR] Plugin 'InnoDB' init function returned error.
2014-07-11 10:14:25 2267 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-07-11 10:14:25 2267 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-07-11 10:14:25 2267 [ERROR] Aborting


大体意思应该是内存不够,因为的申请的机器的内存是512M,所以修改了下配置文件,添加入下内容

innodb_buffer_pool_size = 16M

innodb_additional_mem_pool_size = 2M

innodb_log_file_size = 5M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50


重新初始化数据库,启动正常了。

人气教程排行