On Fri, Jan 16, 2009 at 2:11 AM, Craigsell wrote:
> We are working on one of our CF webservers and noticed something strange. A
> user was running a very long query which subsequently displays on the browser
> (10+ minutes, tons of data - don't ask it's a mess). It was chewing up huge
> amount
It sounds like your going through what we did a few yeas ago. While
the monitoring is nice, it only points to some of the problems. Get
the JVM tuned. I've written a few articles at my blog about how we
tuned our JVM for high availability. Your right to use Fusion
Reactor (or Seefusio
I said not to ask.
Just to answer what the heck are we doing --We are looking at all the
possibilities. The instance in question has thousands of pages on it
running all sorts of bad code built over10 years by a host of developers.
When activity recently picked up on this server and the pe
FusionReactor or SeeFusion (or the CF8 Monitor) allows you to kill long
running threads. Typically, I kill anything that runs over 5 minutes.
FusionReactor allows you to add exceptions for processes which you know
are valid, but are long running. I'm sure SeeFusion does as well, but I
don't
A better response to this is to fix the query or redefine the needed
data so less is returned.
Other possible options,
setting the timeout attribute on the cfquery tag
If you absolutely have to run that query then tune the DB tables with
indexes.
It may also be possible your hardware for the D
Need help with another shining example of my ignorance -- I'm more of a
developer than a webserver person.
We are working on one of our CF webservers and noticed something strange. A
user was running a very long query which subsequently displays on the browser
(10+ minutes, tons of data - don'
6 matches
Mail list logo