<html><body><div style="font-family: Verdana; font-size: 12pt; color: #000066"><div>Hi all,<br></div><div><br></div><div>So far I created this solution for immediate remedy:</div><div><a href="https://access.redhat.com/solutions/721423">https://access.redhat.com/solutions/721423</a> <br></div><div><br></div><div>I created this general RFE, that would help in our situation:<br></div><div><a href="https://bugzilla.redhat.com/show_bug.cgi?id=1329793">https://bugzilla.redhat.com/show_bug.cgi?id=1329793</a></div><div><br></div><div>However, this RFE is not all what I have in my mind.<br></div><div>I am thinking if there is anyway we can limit the number of identical records in audit_log?<br></div><div>Or, as Oved suggested, something to do with RestAPI and CFME to reduce the amount of logging?<br></div><div>BTW, does current version of CFME already contains this feature:<br></div><div><a href="http://old.ovirt.org/Features/RESTSessionManagement">http://old.ovirt.org/Features/RESTSessionManagement</a></div><div>?<br></div><div><br></div><div>Thank you,<br></div><div>Marina.<br></div><div><br></div><hr id="zwchr"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><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" data-mce-href="mailto:oourfali@redhat.com">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" data-mce-style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: #cccccc; 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/" target="_blank" data-mce-href="https://gerrit.ovirt.org/#/c/55743/">https://gerrit.ovirt.org/#/c/55743/</a> .</div></div></div></div></blockquote><div>This commit is great, however not relevant for my case, since event_notification_hist is empty.<br></div><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><div>Y.</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" data-mce-style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: #cccccc; 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" data-mce-href="mailto:mkalinin@redhat.com">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" data-mce-style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: #cccccc; padding-left: 1ex;">Hi,<br><div><br></div> Any suggestions or maybe already available features in the pipeline for tuning the database, and specifically the audit_log table?<br><div><br></div> 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><div><br></div> The solution today is to delete those records from the table [1]:<br> => delete from audit_log where message like '%logged%';<br><div><br></div><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><span style="color: #888888;" data-mce-style="color: #888888;" color="#888888"><br> <br> --<br> Thanks,<br> Marina.<br> <br> <br> [1] <a href="https://access.redhat.com/solutions/2110011" rel="noreferrer" target="_blank" data-mce-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" rel="noreferrer" target="_blank" data-mce-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" target="_blank" data-mce-href="mailto:Users@ovirt.org">Users@ovirt.org</a><br> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank" data-mce-href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a><br> <br> <br> </span></span></blockquote></div><br></div></div></div><br>_______________________________________________<br> Users mailing list<br><a href="mailto:Users@ovirt.org" target="_blank" data-mce-href="mailto:Users@ovirt.org">Users@ovirt.org</a><br><a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank" data-mce-href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a><br><div><br></div></blockquote></div><br></div></div></blockquote><div><br><div><br></div></div><div><br></div><div>-- <br></div><div><span name="x"></span>--<br> mku<span name="x"></span><br></div></div></body></html>