> The number of users on our system has recently increased from > about 15 to 35, and now the server is hanging 3 or 4 times a > day. Server.log reporting that the unrespnsive thread count > (see log snippet at end of message). > > Have tried paying with the various cfadmin settings, but no joy. > > There are killer queries that are being executed, and this > takes 99% of the CPU for up to 2 minutes - and although the > cfserver appears to hang at those times, the response comes > back when the query has finished, btu what we are seeing is > worse than that - indefinite hangs which can only be cured by > stoping and restarting the cf server. > > We are working to get rid of the killer queries (even if they > are not the cause, they should be eliminated in any case), > and will probably move the cf server to another machine > (currently on the same high spec machine as the databse). > > Is there anything else we should be doing? Has anyone else > experienced these problems? > > Am running CF 5.0 on RedHat Linux 2.4.2-2smp, UNIX ODBC and > Postgres 7.2.3
I know that this is an old saw, but are you locking properly? If not then added load is exactly when you'll see problems. I've a guide to locking here that might be useful: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/L ocking/Index.cfm The guide is really only application to CF 4-5 as MX changes (and improves) the locking rules quite a bit, but since you're on 5.0 it's still VERY important. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.