It sounds like you are referring to the transaction log portion of a
database, and you can definitely expect the transaction log for Client
variables database to grow very quickly because they are updated on
every hit. Database transaction logs need to be checkpointed or cleared
on backup or whatever, but they will grow and this one will grow like
crazy. Your DBA needs to handle it.
Thanks
Mark
-----Original Message-----
From: John P [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2008 11:51 AM
To: cf-talk
Subject: client variables log database is huge
I suspect that there may be a problem with our ClientStorage_log
database as it's currently at 11.5 gigs and has to be cleared out once a
month or so. I freed 4.5 gigs of space on this server by moving files
off 2 days ago and within 24 hours that space was filled again. Could
this be a security hole that is allowing our clientStorage_log db to get
filled so quickly? I don't know the size of the clientStorage_log prior
to moving the files off the server but it's by far the largest recently
modified file in the past 4 days.
Coldfusion MX7 server.
Thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315705
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
