[ovirt-users] audit_log table performance tuning

[Marina Kalinin]

Hi all, 

So far I created this solution for immediate remedy: 
https://access.redhat.com/solutions/721423 

I created this general RFE, that would help in our situation: 
https://bugzilla.redhat.com/show_bug.cgi?id=1329793 

However, this RFE is not all what I have in my mind. 
I am thinking if there is anyway we can limit the number of identical records in audit_log? 
Or, as Oved suggested, something to do with RestAPI and CFME to reduce the amount of logging? 
BTW, does current version of CFME already contains this feature: 
http://old.ovirt.org/Features/RESTSessionManagement 
? 

Thank you, 
Marina. 

----- Original Message -----

> On Sun, Apr 17, 2016 at 9:33 AM, Oved Ourfali < oourfali at redhat.com > wrote:

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

> Reminds me of https://gerrit.ovirt.org/#/c/55743/ .

This commit is great, however not relevant for my case, since event_notification_hist is empty. 

> Y.

> > On Fri, Apr 15, 2016 at 1:12 AM, Marina Kalinin < mkalinin at redhat.com >
> > 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 at ovirt.org
> > 
> 
> > > http://lists.ovirt.org/mailman/listinfo/users
> > 
> 

> > _______________________________________________
> 
> > Users mailing list
> 
> > Users at ovirt.org
> 
> > http://lists.ovirt.org/mailman/listinfo/users
> 

-- 
-- 
mku 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160423/c3ea94ab/attachment.html>