[ovirt-users] audit_log table performance tuning

[Yaniv Kaul]

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/ .
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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160417/0137c087/attachment-0001.html>