On Sun, Apr 17, 2016 at 9:33 AM, Oved Ourfali <oourfali(a)redhat.com> wrote:
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>
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