As a follow up from my previous post, I am pondering some changes to my env.
I read that with AR I should change the verification timeout to be lower than the MySQL db Interactive_timeout. Now, I have done some performancing tuning to mysql in LAMP env's but not RoR. MySQL typical set the default interactive_timeout to 8hrs (28800) this has bitten me a few times with sleeping processess or stale connections. What I have done in the past was optimize mysql with the following variable changes (/etc/my.cnf) wait_timeout=60 connect_timeout=10 interactive_timeout=120 join_buffer_size=1M query_cache_size=128M query_cache_limit=2M sort_buffer_size=8M key_buffer = 256M key_buffer_size=64M ... According to the mongrel docs it says to use 4hrs - assuming you didn't edit mysql default settings- but what I am curious to know, is what most people set this to, those of us who do performance tweak their mysql servers. Also, if there is anything recommended mongrel/rails specific. ActiveRecord::Base.verification_timeout = 14400 -- -mike _______________________________________________ Mongrel-users mailing list [email protected] http://rubyforge.org/mailman/listinfo/mongrel-users
