[ovirt-users] audit_log table performance tuning

[Marina Kalinin]

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.


[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

[ovirt-users] backup-engine 3.6.4.1-1 Files Compressor still broken in Centos 6.7? Work around

[Jack Greene]

Been trying to run a complete backup on a fresh install to get rid of that
annoying alert.

 

engine-backup --scope=all

 

Kept failing with the error:

2016-04-17 04:05:31 8742: Creating temp folder
/tmp/engine-backup.ymrXeYZay1/tar

2016-04-17 04:05:31 8742: OUTPUT: - Files

2016-04-17 04:05:31 8742: Backing up files to
/tmp/engine-backup.ymrXeYZay1/tar/files

2016-04-17 04:05:31 8742: FATAL: Failed backing up /etc/ovirt-engine

 

Research shows a bug reported on version 3.6.0 related to the tar options

https://gerrit.ovirt.org/#/c/48596/3/packaging/bin/engine-backup.sh

https://bugzilla.redhat.com/show_bug.cgi?id=1282397

 

But a grep of the script shows the changes have been made

[root@engine1 iso]# grep cpSs /usr/share/ovirt-engine/bin/engine-backup.sh

[root@engine1 iso]# grep cpS /usr/share/ovirt-engine/bin/engine-backup.sh

tar -C "${dir}" -cpS"${ARCHIVE_COMPRESS_OPTION}"f "${file}" . >>
"${tar_log}" 2>&1

tar -C / --files-from - -cpS"${FILES_COMPRESS_OPTION}"f
"${target}" || logdie "Failed backing up ${paths}"

 

Verified I had a new version (just re-installed ovirt-engine today)

 

ovirt-engine-3.6.4.1-1.el6.noarch

Linux engine1.attlocal.net 2.6.32-573.22.1.el6.x86_64 #1 SMP Wed Mar 23
03:35:39 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux

 

# ovirt-engine-backup - oVirt engine backup and restore utility

# Copyright (C) 2013-2016 Red Hat, Inc.

 

Then I noticed there is an option to turn off -files-compressor.  Doing this
I was able to get a complete backup.

 

[root@engine1 iso]# engine-backup --mode=backup --scope=files
--file=/mnt/h97m/backup_files_20160417
--log=/root/backup_files_20160417.log --files-compressor=None

Backing up:

Notifying engine

- Files

Packing into file '/mnt/h97m/backup_files_20160417'

Notifying engine

Done.

[root@engine1 iso]# engine-backup --mode=backup --scope=all
--file=/mnt/h97m/backup_all_20160417  --log=/root/backup_all_20160417.log
--files-compressor=None

Backing up:

Notifying engine

- Files

- Engine database 'engine'

Packing into file '/mnt/h97m/backup_all_20160417'

Notifying engine

Done.

[root@engine1 iso]# service ovirt-engine start

 

Passing this on in case I need the work around again ;)

 

Jack Greene

___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users