1. 论坛系统升级为Xenforo,欢迎大家测试!
    排除公告

娃哈哈,把innodb干掉,mysql现在只占100M内存

本帖由 wm_chief2007-04-14 发布。版面名称:主机讨论

  1. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    :) 我才不要啥事务处理
     
  2. 平行线

    平行线 New Member

    注册:
    2005-10-29
    帖子:
    9,943
    赞:
    63
    全都搞定了?
     
  3. amt

    amt New Member

    注册:
    2005-12-13
    帖子:
    8,582
    赞:
    67
    折腾
     
  4. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    啊哦,乱搞一通
     
  5. zmnet

    zmnet Well-Known Member

    注册:
    2006-05-03
    帖子:
    7,809
    赞:
    62
    不懂
     
  6. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    按mysql默认配置占了600MB的内存......
     
  7. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    有这么多吗?没试过有占这么多的!
     
  8. 平平

    平平 New Member

    注册:
    2006-11-23
    帖子:
    640
    赞:
    0
    用啥innodb
    我的mysql 都只占了几十M内存 CUP高的时候不超30%
     
  9. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    你装mysql时自动按你内存比例设置.
     
  10. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    现在100mb左右
     
  11. Hoofei

    Hoofei New Member

    注册:
    2005-12-10
    帖子:
    3,162
    赞:
    35
    怎么搞?:rolleyes:
     
  12. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    修改my.ini,然后在"default-storage-engine=INNODB"之前加上"#"
    接着找到:"#skip-innodb"把前面的"#"去掉,然后重启mysql即可
     
  13. zmnet

    zmnet Well-Known Member

    注册:
    2006-05-03
    帖子:
    7,809
    赞:
    62
  14. OUYANG

    OUYANG New Member

    注册:
    2005-09-06
    帖子:
    3,025
    赞:
    5
    此 贴 收 了
     
  15. edust

    edust New Member

    注册:
    2007-04-07
    帖子:
    17
    赞:
    0
    有这挡事情呢. 好
     
  16. yeshou

    yeshou New Member

    注册:
    2005-09-06
    帖子:
    7,067
    赞:
    34
    老 数据库占用空间也释放了很多吧
     
  17. xooass

    xooass New Member

    注册:
    2005-09-09
    帖子:
    653
    赞:
    1
    不错不错 现在的东西占内存越来越大了 一个 apache2子进程就要了20多M
     
  18. besthome

    besthome New Member

    注册:
    2006-10-31
    帖子:
    81
    赞:
    0
    会不会有什么负面影响啊
    比如会不会影响pw和dz论坛以及帝国等cms的程序啊?