Re: [ovirt-users] audit_log table performance tuning

This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --HxUlBB9m1VEcJj0dO9sBDwd2v86tIQdk5 Content-Type: multipart/mixed; boundary="HjK7R6pAQfhTK2JA4pVCDr6ifqD6oPb94" From: Sven Kieske <svenkieske(a)gmail.com&gt; To: users(a)ovirt.org Message-ID: <571F7625.9010906(a)gmail.com&gt; Subject: Re: [ovirt-users] audit_log table performance tuning References: <640699674.62984134.1460671956028.JavaMail.zimbra(a)redhat.com&gt; In-Reply-To: <640699674.62984134.1460671956028.JavaMail.zimbra(a)redhat.com&gt; --HjK7R6pAQfhTK2JA4pVCDr6ifqD6oPb94 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 15.04.2016 00:12, Marina Kalinin wrote: tuning the database, and specifically the audit_log table?=20 ne through the RestAPI, especially deployments with CloudForms, create hu= ge 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 da= tabase and results in a terrible performance of engine and inaccessible W= eb UI. database or a way to delete/filter those records somehow from the WebUI?= t issue. Hi, I remember filing a BZ about this topic some years ago. I will mail it tomorrow to this thread as I had this exact issue, as a user of the rest api (without any persistent authentication). the answer, as I recall (I haven't access to this BZ atm), was to simply truncate the event log, which is far from a "solution" at all. kind regards Sven --HjK7R6pAQfhTK2JA4pVCDr6ifqD6oPb94-- --HxUlBB9m1VEcJj0dO9sBDwd2v86tIQdk5 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" --HxUlBB9m1VEcJj0dO9sBDwd2v86tIQdk5--