[ovirt-users] audit_log table performance tuning
Marina Kalinin
mkalinin at redhat.com
Thu Apr 28 21:41:58 UTC 2016
----- Original Message -----
> On 15.04.2016 00:12, Marina Kalinin wrote:
> > Hi,
> >
> > Any suggestions or maybe already available features in the pipeline for
> > tuning the database, and specifically the audit_log table?
> >
> > The problem today is that with multiple applications accessing the engine
> > through the RestAPI, especially deployments with CloudForms, create huge
> > amount of login records in the audit_table. Which, in turns, consumes most
> > of the available memory on the machine running the engine and the database
> > and results in a terrible performance of engine and inaccessible Web UI.
> >
> > The solution today is to delete those records from the table [1]:
> > => delete from audit_log where message like '%logged%';
> >
> >
> > Are there any current tunings we can apply to the database?
> > And if not - do we have any RFEs on limiting the records entered to the
> > database or a way to delete/filter those records somehow from the WebUI?
> > All I could find was RFE#1120659 [2], but it does not describe the exact
> > issue.
> >
> >
>
> Hi,
>
> I remember filing a BZ about this topic some years ago.
>
> I will mail it tomorrow to this thread as I had this exact issue, as a
> user of the rest api (without any persistent authentication).
Sven, Did you find anything?
I still cannot put my head around the right solution for this case. So I would appreciate to see your bug.
>
> the answer, as I recall (I haven't access to this BZ atm), was to simply
> truncate the event log, which is far from a "solution" at all.
>
> kind regards
>
> Sven
>
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
--
--
mku
More information about the Users
mailing list