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:192291 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