Stories
Slash Boxes
Comments

Slash Open Source Project

This discussion has been archived. No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login
Loading... please wait.
  • 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
    • First a note. According to the MySQL online reference manual [mysql.com], set-variable is deprecated in 4.0. It says to pass the variables as --variable=value in my.cnf.
      For some reason I've yet to figure out, mysqld doesn't seem to be paying a lot of attention to my.cnf. I've had to modify mysqld_safe to pass the variables through (actually only wait_time out, as a test.)
      I'm beginning to realize that 128MB really isn't enough considering all that I'm doing in this machine. I'll have to bump that up a bit. I probably should upgrade the whole box while I'm at it.
      One last observation. With all due respect to Jamie, this sounds more like a band aide than a fix. If slashd is keeping data base connections open, I would assume it would be for caching and performance purposes. If that's the case, existing open, but sleeping, connections should be reused before openning new ones. Otherwise, connections should be closed, and the resources released, when the page has been rendered. Just my two cents worth.
    • 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.