• Log of Video Views can overwhelm database

    By David A Clover 1 decade ago

    I'm using version Open.TV1.0.0 and it works well. For some reason 1.5 didn't. However, it looks as though it is being targeted by an external Denial of Service attack and because they are logged, this bumps up the entries in the view [Administration][Video Views Unprocessed] into the stratospheric thousands and millions. This in turn bulks the file up into the Gb range and it becomes a very bad tenant on the server. Sometimes the activity against the Db on the web appears to actually crash the (Domino 8.5.1) server. Is it possible to make the Db not record/log these accesses and thus remain immune from becoming overbloated with log details? I've tried altering the ACL for 'Anonymous' and 'Default' but to no avail as it is the server itself that appears to be logging these hits on the Db

    • I have an idea

      By Neil Gower 1 decade ago

      Hi,



      Sounds like a nightmare, there is currently no switch to turn off view recording. I was thinking about writing a quick purge agent, and sending it to you. If your interested please email me at neilgower at gmail.com



      If you dont want to email me then please follow these instructions



      In the Open TV template create a new agent called "$PurgeOldViewDocuments"



      The agent should be set to run more than once a day (I suggest every 30 mins), and its target should be "All Documents in Database".



      You need to copy the following Notes formula in the "action" part of the edit pane





      FIELD Views_Status:=@If(Views_Status="Processed";@DeleteDocument;Views_Status);

      SELECT @All



      and choose "Modify Documents"



      This agent will purge already processed "view" documents and should clean up your db. If you want it to be even more effective increase the frequency of the running of the "$RollUp_VideoStatistics" to every 10 mins..



      Hope this helps, the next version has lots of features to manage this kind of logging.