<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Apr 17, 2016 at 9:33 AM, Oved Ourfali <span dir="ltr"><<a href="mailto:oourfali@redhat.com" target="_blank">oourfali@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr">Juan - we should try to reduce this number consumed by CFME, if possible.<div>CC-ing Eli for DB related tips.</div></div></blockquote><div><br></div><div>Reminds me of <a href="https://gerrit.ovirt.org/#/c/55743/">https://gerrit.ovirt.org/#/c/55743/</a> .</div><div>Y.</div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div class=""><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Apr 15, 2016 at 1:12 AM, Marina Kalinin <span dir="ltr"><<a href="mailto:mkalinin@redhat.com" target="_blank">mkalinin@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">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>
<span><font color="#888888"><br>
<br>
--<br>
Thanks,<br>
Marina.<br>
<br>
<br>
[1] <a href="https://access.redhat.com/solutions/2110011" rel="noreferrer" target="_blank">https://access.redhat.com/solutions/2110011</a><br>
[2] <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1120659" rel="noreferrer" target="_blank">https://bugzilla.redhat.com/show_bug.cgi?id=1120659</a><br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
<br>
<br>
</font></span></blockquote></div><br></div>
</div></div><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" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div></div>