On Apr 23, 2016 7:46 AM, "Marina Kalinin" <mkalinin@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?
Or, as Oved suggested, something to do with RestAPI and CFME to reduce
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. 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@redhat.com>
Juan - we should try to reduce this number consumed by CFME, if
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
wrote: possible. 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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- -- mku