自己配置的XWAMP环境,默认下没有详细配置mysql的my.ini,一方面不同服务器的配置不一样,另一方面按照默认为空的方式也一直没有出现过问题。不过最近服务器挂掉了,出现的症状是:
网站不能打开,动态的。静态的可以。
不能远程桌面。
强制重启服务器后查看系统日志发现了这个错误:
mysqld: Out of memory (Needed 129040 bytes)
于是找到了mariadb根目录中有几个推荐配置文件:
my-small.ini:内存小于64M。
my-medium.ini:内存在32M – 64M之间。
my-large.ini:内存为512M。
my-huge.ini:内存在1G-2G之间
my-innodb-heavy-4G.ini:内存4GB,仅使用innodb存储引擎。
挂掉的服务器是2核(CPU)2GB(内存),选择了my-large.ini的推荐配置,增加了如下配置(放在[mysqld]下):
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 4
21 Comments
keto diet heart attack
July 7, 2021 at 2:32 pmketo pie crust
keto os
July 6, 2021 at 11:49 pmcan you eat cheese on keto
keto diet for vegans
July 6, 2021 at 9:28 pmketo diet pills reviews
free farmer dating site
June 26, 2021 at 9:08 ambest free online dating sites uk
dating ariane free play
June 24, 2021 at 7:08 amfree indian online dating site
absolutely free dating sites no credit card required
June 24, 2021 at 1:42 amlocal singles free dating site
double your dating book free
June 24, 2021 at 12:43 amdating sites free for teenagers
100 free european dating sites
June 23, 2021 at 9:41 pmare paid dating sites better than free
Usescedge
June 16, 2021 at 7:18 amUsescedge
June 15, 2021 at 10:44 pmcialis online reviews
best online free dating site
June 2, 2021 at 12:12 amfree gamer dating site
interracial dating online free
June 1, 2021 at 11:16 pmtotally free dating site in canada
free online dating girls
June 1, 2021 at 10:50 pmfree free sugardaddy dating
arab dating free
June 1, 2021 at 10:14 pmdating sites for free no membership
free dating sites for people over 40
May 27, 2021 at 5:34 amfree to send messages dating sites
phone chat dating free trial
May 20, 2021 at 11:14 pmare there any free adult dating site
free chat and dating sites
May 20, 2021 at 6:54 pmfree military dating sites in the usa
farmers free dating site
May 19, 2021 at 11:57 pmwhite women for black men free dating sites
free dating sites bdsm
May 19, 2021 at 9:51 pmfree 100 dating site in europe
i lost all my matches on tinder
May 16, 2021 at 2:20 pmi lost all my matches on tinder
mysql内存超出 mysqld: Out of memory 解决办法 – rock funs
pancakes or Waffles Tinder
May 16, 2021 at 11:31 ampancakes or Waffles Tinder
mysql内存超出 mysqld: Out of memory 解决办法 – rock funs