------=_Part_65949358_553852405.1461386776000 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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 am thinking if there is anyway we can limit the number of identical records in audit_log? 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 ? Thank you, Marina. ----- Original Message -----
On Sun, Apr 17, 2016 at 9:33 AM, Oved Ourfali < oourfali@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@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.
_______________________________________________
Users mailing list
Users@ovirt.org
_______________________________________________
Users mailing list
Users@ovirt.org
</div><div>I am thinking if there is anyway we can limit the number of ide= ntical 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=3D"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><h= r id=3D"zwchr"><blockquote style=3D"border-left:2px solid #1010FF;margin-le= ft:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;tex= t-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" d= ata-mce-style=3D"border-left: 2px solid #1010FF; margin-left: 5px; padding-= left: 5px; color: #000; font-weight: normal; font-style: normal; text-decor= ation: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><di= v dir=3D"ltr"><br><div class=3D"gmail_extra"><br><div class=3D"gmail_quote"= On Sun, Apr 17, 2016 at 9:33 AM, Oved Ourfali <span dir=3D"ltr"><<a hre= f=3D"mailto:oourfali@redhat.com" target=3D"_blank" data-mce-href=3D"mailto:= oourfali@redhat.com">oourfali@redhat.com</a>></span> wrote:<br><blockquo= te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-widt= h:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-le= ft:1ex" data-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px= ; border-left-style: solid; border-left-color: #cccccc; padding-left: 1ex;"= <div dir=3D"ltr">Juan - we should try to reduce this number consumed by CF= ME, if possible.<div>CC-ing Eli for DB related tips.</div></div></blockquot= e><div><br></div><div>Reminds me of <a href=3D"https://gerrit.ovirt.org/#/c= /55743/" target=3D"_blank" data-mce-href=3D"https://gerrit.ovirt.org/#/c/55= 743/">https://gerrit.ovirt.org/#/c/55743/</a> .</div></div></div></div></bl= ockquote><div>This commit is great, however not relevant for my case, since= event_notification_hist is empty.<br></div><blockquote style=3D"border-lef= t: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=3D"border-left: 2px solid #1010F= F; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; f= ont-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans= -serif; font-size: 12pt;"><div dir=3D"ltr"><div class=3D"gmail_extra"><div = class=3D"gmail_quote"><div>Y.</div><blockquote class=3D"gmail_quote" style= =3D"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=3D"marg= in: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; bo= rder-left-color: #cccccc; padding-left: 1ex;"><div class=3D""><div class=3D= "h5"><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">On Fri, Apr = 15, 2016 at 1:12 AM, Marina Kalinin <span dir=3D"ltr"><<a href=3D"mailto= :mkalinin@redhat.com" target=3D"_blank" data-mce-href=3D"mailto:mkalinin@re= dhat.com">mkalinin@redhat.com</a>></span> wrote:<br><blockquote class=3D= "gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;borde= r-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex" dat= a-mce-style=3D"margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-le= ft-style: solid; border-left-color: #cccccc; padding-left: 1ex;">Hi,<br><di= v><br></div> Any suggestions or maybe already available features in the pip= eline for tuning the database, and specifically the audit_log table?<br><di= v><br></div> The problem today is that with multiple applications accessing=
-- -- mku ------=_Part_65949358_553852405.1461386776000 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><body><div style=3D"font-family: Verdana; font-size: 12pt; color: #00= 0066"><div>Hi all,<br></div><div><br></div><div>So far I created this solut= ion for immediate remedy:</div><div><a href=3D"https://access.redhat.com/so= lutions/721423">https://access.redhat.com/solutions/721423</a> <br></div><d= iv><br></div><div>I created this general RFE, that would help in our situat= ion:<br></div><div><a href=3D"https://bugzilla.redhat.com/show_bug.cgi?id= =3D1329793">https://bugzilla.redhat.com/show_bug.cgi?id=3D1329793</a></div>= <div><br></div><div>However, this RFE is not all what I have in my mind.<br= the engine through the RestAPI, especially deployments with CloudForms, cr= eate huge amount of login records in the audit_table. Which, in turns, cons= umes 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 fr= om the table [1]:<br> =3D> delete from audit_log where message like '%lo= gged%';<br><div><br></div><br> Are there any current tunings we can apply t= o the database?<br> And if not - do we have any RFEs on limiting the record= s entered to the database or a way to delete/filter those records somehow f= rom the WebUI?<br> All I could find was RFE#1120659 [2], but it does not de= scribe the exact issue.<br><span><span style=3D"color: #888888;" data-mce-s= tyle=3D"color: #888888;" color=3D"#888888"><br> <br> --<br> Thanks,<br> Mar= ina.<br> <br> <br> [1] <a href=3D"https://access.redhat.com/solutions/21100= 11" rel=3D"noreferrer" target=3D"_blank" data-mce-href=3D"https://access.re= dhat.com/solutions/2110011">https://access.redhat.com/solutions/2110011</a>= <br> [2] <a href=3D"https://bugzilla.redhat.com/show_bug.cgi?id=3D1120659" = rel=3D"noreferrer" target=3D"_blank" data-mce-href=3D"https://bugzilla.redh= at.com/show_bug.cgi?id=3D1120659">https://bugzilla.redhat.com/show_bug.cgi?= id=3D1120659</a><br> _______________________________________________<br> Us= ers mailing list<br> <a href=3D"mailto:Users@ovirt.org" target=3D"_blank" d= ata-mce-href=3D"mailto:Users@ovirt.org">Users@ovirt.org</a><br> <a href=3D"= http://lists.ovirt.org/mailman/listinfo/users" rel=3D"noreferrer" target=3D= "_blank" data-mce-href=3D"http://lists.ovirt.org/mailman/listinfo/users">ht= tp://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=3D"mailto:Users@ovirt.= org" target=3D"_blank" data-mce-href=3D"mailto:Users@ovirt.org">Users@ovirt= .org</a><br><a href=3D"http://lists.ovirt.org/mailman/listinfo/users" rel= =3D"noreferrer" target=3D"_blank" data-mce-href=3D"http://lists.ovirt.org/m= ailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a><br= <div><br></div></blockquote></div><br></div></div></blockquote><div><br><d= iv><br></div></div><div><br></div><div>-- <br></div><div><span name=3D"x"><= /span>--<br> mku<span name=3D"x"></span><br></div></div></body></html> ------=_Part_65949358_553852405.1461386776000--