There are a hotfixes available for 6.1 pertaining to client database purging. Two versions, depending on whether you've run 6.1 updater or not. Go to http://www.macromedia.com/cfusion/knowledgebase/ & search for "6.1 client hotfix"
The main group of websites I work on recently made the change to 6.1. Our CF server was getting hung up repeatedly. Sometimes after 20 minutes, sometimes after 7 hours. Server Admin said it was my code. Or my locking practices. I'm humble ... said, yeah this code is complex I'll run though the queries/StoredProcs/Views to find something hanging it up. (ps. I've been doing CF since '98 -- I rarely make locking mistakes) After nearly a week of repeated CF Server hangs & restarts, Server Admin says "I just applied a hotfix that might have something to do with it." (http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19590) Problem went away If this is the case with you, it's a quick fix. good luck Jevo Terry Ford wrote: >Hey all, > >In the process of performing a yearly upgrade I was quite surprised to find >that my CGLOBAL and CDATA tables contained over 20 million (yes, million) >entries each, and the CGLOBAL.MYD file alone had a size of 3.1 gigs. > >Needless to say, I had been operating under the assumption that the tables >were purging correctly. Apparantly I was incorrect. > >Anyway, I've taken a hatchet to the tabbles and whacked them down to size, and >have verified that indeed the purge option (30 days) is selected. > >Does anyone have any clue why my tables aren't purging? >I am running mysql / CFMX6.1 / lotsa mem / dual xeon > >Terry > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:193242 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