FYI, I don't believe postgresql is a threaded database system. I found this out the hard way when trying to optimize its query analyzer with threads.
> -----Original Message----- > From: Jordan Michaels [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 02, 2004 9:07 AM > To: CF-Linux > Subject: Re: Performance of CFMX 6.1 and Linux > > Hello Shane, > > A couple things to note: > > 1) Cold Fusion MX Professional (not Enterprise) will only use > one CPU. > If you want to take advantage of both CPU's on that box then > you will need to use Cold Fusion Enterprise. > > 2) Since you're only hitting a "hello world" page, I find it > highly unlikely that postgresql would be what's causing your > problems. Also, postgresql is a multi-threaded database, so > it *should* be able to utilize both CPU's on that box. That > said, if CFMX is maxing out one of the CPU's on your system, > postgre should have no problem utilizing the other CPU. > > 3) A few questions: Have you checked out your memory usage > while this is happening? How about hard drive usage? Is hard > drive usage spiking as well when you run these tests? What > are your JVm memory usage settings configured to? > > Warm regards, > Jordan Michaels > Vivio Technologies > http://www.viviotech.net/ > jordan (at) viviotech (dot) net > > [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: > > >Hi All > > > >We are experiencing a problem on our production server which > is running > > > >Cold Fusion MX 6.1 (Standard stand alone installation) Apache 2.0.40 > >PostgreSQL 7.4.1 JDBC Driver 7.4 Build 1 ( JDBC3 ) > > > >The hardware is a beefy dell server not 100% sure on the > specs but dual > >> 2GHz CPU, > 1Gb RAM plenty of disk space > > > >The site generally runs really well and using Microsoft > Application Center Test can test it handling 300+ requests per second. > > > >The problem is that during these tests and at any time the > site say at 40 second intervals will take up 20 seconds to > return a request. after this 20 second interval the site > takes off again to its maximum performance for about 40 > seconds and then cycles like that indefinitely. The request > will always be returned though. > >The interval of slowness changes when we decrease the number > of hits but perplexing it actually gets shorter rather than longer. > > > >Hitting a simple "hello world cfm page" exhibits the same > results but hitting a html page doesn't. Remember this site > is live during these tests so it is possible and highly > likely that CF is still dealing with Postgres through other requests. > > > >On our dev box running the same software but only a dual > Pentium II 400MHz with 500Mb Ram the site constantly returns > 200+ requests per minute with no real performance spikes to think of. > > > >One thing to note is that during these performance dips on > the production box one of the cpu's is used up at 100% by the > CF Process and the other(s) aren't doing much at all and the > RAM is has 100's Mb in reserve. > > > >CF Cache template setting is set at about 10 times more that > the actual templates in the site. > > > >Any ideas would help > > > >Cheers > > > >Shane > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:14:3765 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/14 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:14 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.14 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
