Slashcode

• We had the same problem (Score:2)

  by Vladinator (1112)

  Jamie mentioned some tweaks to the mysql cnf file that helped us with this a great deal. The relavant section of our my.cnf looks (partially) like this now:
  
  [mysqld] ...
  set-variable = table_cache=512
  set-variable = max_connections=300
  set-variable = interactive_timeout=60
  set-variable = wait_timeout=60
  

  --
  
  
  "How about you interface with my ass? By biting it!" --Bender
  • Re:We had the same problem (Score:1)

    by edrubins (5004)

    OK, MySQL is now reading the my.cng file and the timeouts are set as above. max_connections was already lower. In addition I reconfigured apache to limit the number of child threads and the number of requests per child thread. Still leaking memory (apache, I believe) but things are getting better.
    • Re:We had the same problem (Score:2)

      by Krow (986)

      Look at Apache::SizeLimit to solve that.

      --
      
      --
      You can't grep a dead tree.
      • Re:We had the same problem (Score:2)

        by Vladinator (1112) <vladNO@SPAMlrsehosting.com> on Monday April 07 2003, @11:03PM (#5948) Homepage

        What about the points he made about slash closing connections?

        --
        
        
        "How about you interface with my ass? By biting it!" --Bender

        Parent