> -----Original Message----- > From: Terry Ford [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 07, 2005 1:26 AM > To: CF-Talk > Subject: High Load Server... how much more can it take? > > > A few questions: > > 1. Does 12,000,000 .cfm pages / month (distributed normally over the day, > peaking around 4 PM ET) seem like a lot for a single xeon 2.0?
It depends completely on what those pages do. ;^) It seems like you've answered this yourself, however: at peak your current architecture is reaching its limit. You architect for peak times. > Do you think its possible for me to squeeze a lot more life out of this > machine by investigating further optimizations, or does it sound like it's > time to abandon that exercise and get a second machine? Can anyone else > who is using a dual xeon on linux heavily let me know what sort of load / > pages the thing is successfully serving? You really have to determine where your problem lies. If you're seeing Queued requests but your CPU isn't maxed (for example) it mean that you don't have enough threads allocated for example. It might also mean that your app is becoming DB-bound. > 2. I'm not so sure that we're using RAM effectively, even with mysql set > to use lots of memory and cf set to cache lots of queries and pages. If you've cached everything possible it might just be that your application doesn't have enough data to use that much RAM. You might consider setting aside some of it as a RAM disk, but I'm not sure how well mySQL could use this. The idea would be to load your database (or the most used tables) into the RAM disk on system boot (if it's small enough). I'm not sure how to do this in mySQL (if it's possible at all). But if you could you'd eliminate disk access for your client variables). This might improve performance but would create a risk: should the machine go down you'd lose anything in the RAM disk. You should then create task or process (if mySQL doesn't do it automatically) to periodically back up the tables to physical disk. As long as CF's template cache is large enough to cache all templates in RAM then there's not much you can do for CF using a RAM disk. > 3. Could the use of database client variables be causing peak hour > sluggishness? I've always wondered what sort of performance hit using > database client variables has under load. Would I get a noticable > improvement switching to cookie client variables? How much information do you store in the client scope? If it's small enough to be kept in a cookie then go for it. It's a simple change and you should see an immediate boost concerning DB usage and availability. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205953 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
