Free Republic
Browse · Search
News/Activism
Topics · Post Article

To: Fudd Fan

“What about 3 or 4 live threads - identified as such? Maybe spread the load?”
Well, we can give it a try. If there’s a chance that hundreds of people trying to post to the same thread at the same time is causing a deadlock on the db, it’s worth a shot to try to split the load. John says the load avg on the web server was low, the cpu’s were not busy and the db sever was mostly idle last time, but we couldn’t get any throughput. Could be a logjam in the db caused by record locks making it hard to get anything in or out.

259 posted on Tuesday, October 16, 2012 4:42:24 PM by Jim Robinson (Resistance to tyrants is obedience to God!!)
[ Post Reply | Private Reply | To 62 | View Replies | Report Abuse]


86 posted on 10/16/2012 4:58:19 PM PDT by advertising guy (" that lie has it's own sleep number " David Feherty PGA Championship 2012)
[ Post Reply | Private Reply | To 84 | View Replies ]


To: advertising guy

just wow


88 posted on 10/16/2012 4:59:46 PM PDT by advertising guy (" that lie has it's own sleep number " David Feherty PGA Championship 2012)
[ Post Reply | Private Reply | To 86 | View Replies ]

To: advertising guy
jeez - unix tardz that know nothing about relational database locking mechanisms - tossing out bs like ‘deadlocked’ - major eyeroll
100 posted on 10/16/2012 5:24:39 PM PDT by sloop (don't touch my junk)
[ Post Reply | Private Reply | To 86 | View Replies ]

Free Republic
Browse · Search
News/Activism
Topics · Post Article


FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson