首頁 >資料庫 >mysql教程 >mysql启动过程中报错_MySQL

mysql启动过程中报错_MySQL

WBOY
WBOY原創
2016-05-31 08:46:23958瀏覽


今天给阿里云的机器安装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


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


陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn