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 < oourf...@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 < mkali...@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@ovirt.org > > > > > > http://lists.ovirt.org/mailman/listinfo/users > > > > > _______________________________________________ > > > Users mailing list > > > Users@ovirt.org > > > http://lists.ovirt.org/mailman/listinfo/users > -- -- mku
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
