• news
  • pics
  • linux
  • windows
  • proxmox
  • game
  • news
  • pics
  • linux
  • windows
  • proxmox
  • game
Home
linux

mysql内存超出 mysqld: Out of memory 解决办法

自己配置的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

Previous article 如何添加swap分区
Next article 微胖“黑贞”简直犯规级别的性感啊!!!

therock

21 Comments

  1. pancakes or Waffles Tinder
    May 16, 2021 at 11:31 am

    pancakes or Waffles Tinder

    mysql内存超出 mysqld: Out of memory 解决办法 – rock funs

  2. i lost all my matches on tinder
    May 16, 2021 at 2:20 pm

    i lost all my matches on tinder

    mysql内存超出 mysqld: Out of memory 解决办法 – rock funs

  3. free dating sites bdsm
    May 19, 2021 at 9:51 pm

    free 100 dating site in europe

  4. farmers free dating site
    May 19, 2021 at 11:57 pm

    white women for black men free dating sites

  5. free chat and dating sites
    May 20, 2021 at 6:54 pm

    free military dating sites in the usa

  6. phone chat dating free trial
    May 20, 2021 at 11:14 pm

    are there any free adult dating site

  7. free dating sites for people over 40
    May 27, 2021 at 5:34 am

    free to send messages dating sites

  8. arab dating free
    June 1, 2021 at 10:14 pm

    dating sites for free no membership

  9. free online dating girls
    June 1, 2021 at 10:50 pm

    free free sugardaddy dating

  10. interracial dating online free
    June 1, 2021 at 11:16 pm

    totally free dating site in canada

  11. best online free dating site
    June 2, 2021 at 12:12 am

    free gamer dating site

  12. Usescedge
    June 15, 2021 at 10:44 pm

    cialis online reviews

  13. Usescedge
    June 16, 2021 at 7:18 am

  14. 100 free european dating sites
    June 23, 2021 at 9:41 pm

    are paid dating sites better than free

  15. double your dating book free
    June 24, 2021 at 12:43 am

    dating sites free for teenagers

  16. absolutely free dating sites no credit card required
    June 24, 2021 at 1:42 am

    local singles free dating site

  17. dating ariane free play
    June 24, 2021 at 7:08 am

    free indian online dating site

  18. free farmer dating site
    June 26, 2021 at 9:08 am

    best free online dating sites uk

  19. keto diet for vegans
    July 6, 2021 at 9:28 pm

    keto diet pills reviews

  20. keto os
    July 6, 2021 at 11:49 pm

    can you eat cheese on keto

  21. keto diet heart attack
    July 7, 2021 at 2:32 pm

    keto pie crust

Meta
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Categories
  • game
  • linux
  • news
  • pics
  • proxmox
  • windows
Recent Posts
  • 紧身胶衣问谁看不下贱?“HK416”:真的不鼓包的哦!~…
  • Using local directory bind mount points
  • Proxmox中Lxc容器挂载远程目录
  • livego流媒体服务实现无插件播放视频(支持hls,flv)
  • PVE直通核显给虚拟机
Recent Comments
  • Degebu on Proxmox中Lxc容器挂载远程目录
  • Bxdizx on Using local directory bind mount points
  • Markvem on livego流媒体服务实现无插件播放视频(支持hls,flv)
  • Eron Plus on livego流媒体服务实现无插件播放视频(支持hls,flv)
  • buy generic cialis online with mastercard on livego流媒体服务实现无插件播放视频(支持hls,flv)
Archives
  • April 2022 (1)
  • February 2022 (5)
  • January 2022 (2)
  • December 2021 (3)
  • November 2021 (1)
  • October 2021 (2)
  • September 2021 (1)
  • August 2021 (1)
  • July 2021 (8)
  • June 2021 (14)
  • May 2021 (2)
  • April 2021 (2)
  • March 2021 (10)
  • January 2021 (4)
  • December 2020 (4)
  • November 2020 (13)
  • April 2020 (276)
  • March 2020 (1)
  • June 2019 (5)
  • May 2019 (10)
  • December 2015 (1)