Re: [ovirt-users] audit_log table performance tuning

Juan - we should try to reduce this number consumed by CFME, if possible. CC-ing Eli for DB related tips.

On Fri, Apr 15, 2016 at 1:12 AM, Marina Kalinin <mkalinin(a)redhat.com&gt; 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. > > > -- > Thanks, > Marina. > > > [1] https://access.redhat.com/solutions/2110011 > [2] https://bugzilla.redhat.com/show_bug.cgi?id=1120659 > _______________________________________________ > Users mailing list > Users(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > > _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users