Re: [ovirt-users] audit_log table performance tuning

On Apr 23, 2016 7:46 AM, "Marina Kalinin" <mkalinin(a)redhat.com <mailto:mkalinin@redhat.com>> wrote: > > 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 also don't think we should have such tool as mentioned in the RFE. > I am thinking if there is anyway we can limit the number of identical records in audit_log? Identical records might imply some issue, so I don't think they should be limited. What we can add configuration for is maybe the frequency in which the data is purged, which is 30 days currently, afair. > 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 > ? CFME uses the session. However, I think that we don't reuse the session among unrelated requests. Not 100% sure about that. Juan?

> > Thank you, > Marina. > > ________________________________ >> >> >> >> On Sun, Apr 17, 2016 at 9:33 AM, Oved Ourfali <oourfali(a)redhat.com <mailto:oourfali@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(a)redhat.com <mailto:mkalinin@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(a)ovirt.org <mailto:Users@ovirt.org> >>>> http://lists.ovirt.org/mailman/listinfo/users >>>> >>>> >>> >>> >>> _______________________________________________ >>> Users mailing list >>> Users(a)ovirt.org <mailto:Users@ovirt.org> >>> http://lists.ovirt.org/mailman/listinfo/users >>> >> > > > > -- > -- > mku _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users