1. 论坛系统升级为Xenforo，欢迎大家测试！
    Dismiss Notice

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

Discussion in '主机讨论' started by wm_chief, Apr 14, 2007.

  1. wm_chief

    wm_chief New Member

    Joined:
    Sep 5, 2005
    Messages:
    17,890
    Likes Received:
    46
    :) 我才不要啥事务处理
     
    #1 wm_chief, Apr 14, 2007
  2. 平行线

    平行线 New Member

    Joined:
    Oct 29, 2005
    Messages:
    9,943
    Likes Received:
    63
    全都搞定了？
     
    #2 平行线, Apr 14, 2007
  3. amt

    amt New Member

    Joined:
    Dec 13, 2005
    Messages:
    8,582
    Likes Received:
    67
    折腾
     
    #3 amt, Apr 14, 2007
  4. wm_chief

    wm_chief New Member

    Joined:
    Sep 5, 2005
    Messages:
    17,890
    Likes Received:
    46
    啊哦,乱搞一通
     
    #4 wm_chief, Apr 14, 2007
  5. zmnet

    zmnet Well-Known Member

    Joined:
    May 3, 2006
    Messages:
    7,809
    Likes Received:
    62
    不懂
     
    #5 zmnet, Apr 14, 2007
  6. wm_chief

    wm_chief New Member

    Joined:
    Sep 5, 2005
    Messages:
    17,890
    Likes Received:
    46
    按mysql默认配置占了600MB的内存......
     
    #6 wm_chief, Apr 14, 2007
  7. Kevin

    Kevin New Member

    Joined:
    Oct 23, 2005
    Messages:
    12,728
    Likes Received:
    55
    有这么多吗？没试过有占这么多的！
     
    #7 Kevin, Apr 14, 2007
  8. 平平

    平平 New Member

    Joined:
    Nov 23, 2006
    Messages:
    640
    Likes Received:
    0
    用啥innodb
    我的mysql 都只占了几十M内存 CUP高的时候不超30%
     
    #8 平平, Apr 14, 2007
  9. wm_chief

    wm_chief New Member

    Joined:
    Sep 5, 2005
    Messages:
    17,890
    Likes Received:
    46
    你装mysql时自动按你内存比例设置.
     
    #9 wm_chief, Apr 14, 2007
  10. wm_chief

    wm_chief New Member

    Joined:
    Sep 5, 2005
    Messages:
    17,890
    Likes Received:
    46
    现在100mb左右
     
    #10 wm_chief, Apr 14, 2007
  11. Hoofei

    Hoofei New Member

    Joined:
    Dec 10, 2005
    Messages:
    3,162
    Likes Received:
    35
    怎么搞?:rolleyes:
     
    #11 Hoofei, Apr 14, 2007
  12. wm_chief

    wm_chief New Member

    Joined:
    Sep 5, 2005
    Messages:
    17,890
    Likes Received:
    46
    修改my.ini,然后在"default-storage-engine=INNODB"之前加上"#"
    接着找到:"#skip-innodb"把前面的"#"去掉,然后重启mysql即可
     
    #12 wm_chief, Apr 14, 2007
  13. zmnet

    zmnet Well-Known Member

    Joined:
    May 3, 2006
    Messages:
    7,809
    Likes Received:
    62
    学习
     
    #13 zmnet, Apr 14, 2007
  14. OUYANG

    OUYANG New Member

    Joined:
    Sep 6, 2005
    Messages:
    3,025
    Likes Received:
    5
    此 贴 收 了
     
    #14 OUYANG, Apr 14, 2007
  15. edust

    edust New Member

    Joined:
    Apr 7, 2007
    Messages:
    17
    Likes Received:
    0
    有这挡事情呢. 好
     
    #15 edust, Jun 15, 2007
  16. yeshou

    yeshou New Member

    Joined:
    Sep 6, 2005
    Messages:
    7,067
    Likes Received:
    34
    老 数据库占用空间也释放了很多吧
     
    #16 yeshou, Jun 15, 2007
  17. xooass

    xooass New Member

    Joined:
    Sep 9, 2005
    Messages:
    653
    Likes Received:
    1
    不错不错 现在的东西占内存越来越大了 一个 apache2子进程就要了20多M
     
    #17 xooass, Jun 16, 2007
  18. besthome

    besthome New Member

    Joined:
    Oct 31, 2006
    Messages:
    81
    Likes Received:
    0
    会不会有什么负面影响啊
    比如会不会影响pw和dz论坛以及帝国等cms的程序啊？
     
    #18 besthome, Jun 27, 2007
(You must log in or sign up to post here.)
Toggle Width
Language
English (US)