[
https://issues.apache.org/jira/browse/VCL-713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13833375#comment-13833375
]
Josh Thompson commented on VCL-713:
-----------------------------------
The purpose of the querylog table is actually to have an audit trail in case
someone has their web frontend hacked. We should probably remove the UPDATE and
DELETE permissions from it for the normal vcl user.
I'm okay with making it configurable so that people can turn it off or decrease
the content if they have more of a storage concern than an audit one. I think
just removing logging for the adds and updates to the continuations table will
significantly reduce the number of records logged.
> Add ability to turn off certain types of logging in the database
> ----------------------------------------------------------------
>
> Key: VCL-713
> URL: https://issues.apache.org/jira/browse/VCL-713
> Project: VCL
> Issue Type: Improvement
> Components: database, web gui (frontend)
> Affects Versions: 2.3.2
> Reporter: Aaron Coburn
> Priority: Trivial
> Fix For: 2.3.3, 2.4
>
>
> Every UPDATE, INSERT and DELETE command to the database is recorded in the
> querylog table. Also, every XML-RPC call is logged in the database. This is
> great for debugging, but for general production use, it is probably
> unnecessary (and the tables can grow quite large).
> Instead, it would be convenient to be able to enable/disable this type of
> logging directly from .ht-inc/conf.php
--
This message was sent by Atlassian JIRA
(v6.1#6144)
