<p dir="ltr"><br>
On Apr 23, 2016 7:46 AM, "Marina Kalinin" <<a href="mailto:mkalinin@redhat.com">mkalinin@redhat.com</a>> wrote:<br>
><br>
> Hi all,<br>
><br>
> So far I created this solution for immediate remedy:<br>
> <a href="https://access.redhat.com/solutions/721423">https://access.redhat.com/solutions/721423</a> <br>
><br>
> I created this general RFE, that would help in our situation:<br>
> <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1329793">https://bugzilla.redhat.com/show_bug.cgi?id=1329793</a><br>
><br>
> However, this RFE is not all what I have in my mind.</p>
<p dir="ltr">I also don't think we should have such tool as mentioned in the RFE. </p>
<p dir="ltr">> I am thinking if there is anyway we can limit the number of identical records in audit_log?</p>
<p dir="ltr">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. </p>
<p dir="ltr">> Or, as Oved suggested, something to do with RestAPI and CFME to reduce the amount of logging?<br>
> BTW, does current version of CFME already contains this feature:<br>
> <a href="http://old.ovirt.org/Features/RESTSessionManagement">http://old.ovirt.org/Features/RESTSessionManagement</a><br>
> ?</p>
<p dir="ltr">CFME uses the session. However, I think that we don't reuse the session among unrelated requests. <br>
Not 100% sure about that. </p>
<p dir="ltr">Juan? </p>
<p dir="ltr">><br>
> Thank you,<br>
> Marina.<br>
><br>
> ________________________________<br>
>><br>
>><br>
>><br>
>> On Sun, Apr 17, 2016 at 9:33 AM, Oved Ourfali <<a href="mailto:oourfali@redhat.com">oourfali@redhat.com</a>> wrote:<br>
>>><br>
>>> Juan - we should try to reduce this number consumed by CFME, if possible.<br>
>>> CC-ing Eli for DB related tips.<br>
>><br>
>><br>
>> Reminds me of <a href="https://gerrit.ovirt.org/#/c/55743/">https://gerrit.ovirt.org/#/c/55743/</a> .<br>
><br>
> This commit is great, however not relevant for my case, since event_notification_hist is empty.<br>
>><br>
>> Y.<br>
>>><br>
>>><br>
>>> On Fri, Apr 15, 2016 at 1:12 AM, Marina Kalinin <<a href="mailto:mkalinin@redhat.com">mkalinin@redhat.com</a>> wrote:<br>
>>>><br>
>>>> Hi,<br>
>>>><br>
>>>> Any suggestions or maybe already available features in the pipeline for tuning the database, and specifically the audit_log table?<br>
>>>><br>
>>>> 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.<br>
>>>><br>
>>>> The solution today is to delete those records from the table [1]:<br>
>>>> => delete from audit_log where message like '%logged%';<br>
>>>><br>
>>>><br>
>>>> Are there any current tunings we can apply to the database?<br>
>>>> 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?<br>
>>>> All I could find was RFE#1120659 [2], but it does not describe the exact issue.<br>
>>>><br>
>>>><br>
>>>> --<br>
>>>> Thanks,<br>
>>>> Marina.<br>
>>>><br>
>>>><br>
>>>> [1] <a href="https://access.redhat.com/solutions/2110011">https://access.redhat.com/solutions/2110011</a><br>
>>>> [2] <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1120659">https://bugzilla.redhat.com/show_bug.cgi?id=1120659</a><br>
>>>> _______________________________________________<br>
>>>> Users mailing list<br>
>>>> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
>>>> <a href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a><br>
>>>><br>
>>>><br>
>>><br>
>>><br>
>>> _______________________________________________<br>
>>> Users mailing list<br>
>>> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
>>> <a href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a><br>
>>><br>
>><br>
><br>
><br>
><br>
> -- <br>
> --<br>
> mku<br>
</p>