PangXieKr-螃蟹氪
  • Home
Sign in Subscribe

mysql性能优化

A collection of 1 post
mysql

MYSQL在1G VPS上的性能优化配置

我的站目前都放在DigitalOcean上的1G VPS上面。除了这个博客还跑另外两个博客,都是跑在docker上,本想着1G内存足够了,没想到ghost退出过好几次,通过查log和监控发现,都是因为内存不够用被kill了。后来发现是mysql的配置还是默认配置,没有针对小内存优化过,所以很吃内存。不多说了,直接上配置。 [mysql] # CLIENT # port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] # GENERAL # user = mysql default-storage-engine = InnoDB socket = /var/lib/mysql/mysql.sock pid-file = /var/lib/mysql/mysql.pid
Mar 24, 2015 1 min read
Page 1 of 1
PangXieKr-螃蟹氪 © 2025
  • Sign up
Powered by Ghost