1、MySQL顺利安装完毕
2、但是却无法正常启动,查看日志记录
vim /var/log/mysqld.log
3、报错信息如下
4、关键词memory,内存信息
(1)由于innodb_buffer_pool_size默认是128M
(2)查看内存
free -m
(3)清理内存三连
sync; echo 1 > /proc/sys/vm/drop_caches
sync; echo 2 > /proc/sys/vm/drop_caches
sync; echo 3 > /proc/sys/vm/drop_caches
5、然后内存仍然不到128M
配置/etc/my.cnf文件来解决问题。
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size= 50M