mysql启动过程中报错_MySQL
今天给阿里云的机器安装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 大体意思应该是内存不够,因为的申请的机器的内存是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 重新初始化数据库,启动正常了。 |