[ovirt-users] audit_log table performance tuning

[Oved Ourfali]

On Apr 23, 2016 7:46 AM, "Marina Kalinin" <mkalinin at 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 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/ .
>
> 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 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
>>>
>>
>
>
>
> --
> --
>  mku
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160423/abcff215/attachment-0001.html>