On Sun, Apr 17, 2016 at 9:33 AM, Oved Ourfali <[email protected]> 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/ . Y. > > On Fri, Apr 15, 2016 at 1:12 AM, Marina Kalinin <[email protected]> > 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 >> [email protected] >> http://lists.ovirt.org/mailman/listinfo/users >> >> >> > > _______________________________________________ > Users mailing list > [email protected] > http://lists.ovirt.org/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
