修改MySQL的内存表的三种方法

分类：MYSQL日期：2011-04-21作者：雨尚

修改mysql的内存表的三种方法

修改配置文件my.cnf
在[mysqld]字段中添加max_heap_table_size=1G;

启动时加入参数
-O max_heap_table_size=1G

不重启mysql的情况下，用命令行；
show variables like '%heap%';
set global max_heap_table_size=1073741824;

转载请注明来自：LinuxSEE

Tags: MYSQL

17条评论

Etta 说：

Tahnks alot – your answer solved all my problems after several days struggling

POST:2011-06-12 22:08 回复
- Karcy 说：
  
  I went to tons of links bofere this, what was I thinking?
  
  POST:2011-06-25 13:39 回复
  - Kamryn 说：
    
    And I tghohut I was the sensible one. Thanks for setting me straight.
    
    POST:2011-09-06 23:17 回复
    - Coralee 说：
      
      This piece was a lfieajcekt that saved me from drowning.
      
      POST:2011-10-14 10:52 回复
    - Tiger 说：
      
      I bow down hubmly in the presence of such greatness.
      
      POST:2011-10-17 02:02 回复
  - Linx 说：
    
    Thanks for sharing. What a palesrue to read!
    
    POST:2011-09-07 16:57 回复
    - Denim 说：
      
      You’re the one with the barnis here. I’m watching for your posts.
      
      POST:2011-10-14 02:16 回复
    - Karinthia 说：
      
      I might be beating a dead horse, but thank you for psotnig this!
      
      POST:2011-10-17 00:57 回复
- Datherine 说：
  
  Kewl you solhud come up with that. Excellent!
  
  POST:2011-06-26 16:55 回复
  - Allayna 说：
    
    I relaly needed to find this info, thank God!
    
    POST:2011-09-07 05:06 回复
    - Jayde 说：
      
      A good many vlauabels you’ve given me.
      
      POST:2011-10-14 16:33 回复
    - Anitra 说：
      
      A piece of erduitoin unlike any other!
      
      POST:2011-10-17 00:59 回复
  - Buddy 说：
    
    Frankly I think that’s abslotuely good stuff.
    
    POST:2011-09-07 16:38 回复
    - Almena 说：
      
      Full of slainet points. Don’t stop believing or writing!
      
      POST:2011-10-14 07:16 回复
    - Irish 说：
      
      Clear, informative, smilpe. Could I send you some e-hugs?
      
      POST:2011-10-17 00:38 回复
electric toothbrush 说：

Hi, have you been allowing any ads on your web site? I’d like to purchase a banner for a couple of months promoting my my personal blog which is closely related. Let me know, or give me an email that I can reach you at. Thanks a lot!

POST:2012-01-19 01:56 回复
- 雨尚说：
  
  My personal mailbox ydjjing@163.com,thank u
  
  POST:2012-01-19 07:51 回复