Oracle VM: Huge Mgr_EventManager.ibd table Size Resulting In Low Disk Space Warning For /u01 FileSystem (Doc ID 2638549.1)

Last updated on MARCH 01, 2024

Applies to:

Symptoms

OVM Manager Server reported to have low disk space for /u01 file system evident from df output:

Filesystem 1K-blocks Used Available Use% Mounted on
devtmpfs 16460916 0 16460916 0% /dev
tmpfs 32944624 0 32944624 0% /dev/shm
tmpfs 16472312 25244 16447068 1% /run
tmpfs 16472312 0 16472312 0% /sys/fs/cgroup
/dev/mapper/vg_root-rootlv 20961280 8390816 12570464 41% /
/dev/xvda1 2086912 207868 1879044 10% /boot
/dev/mapper/vg_root-varlv 5232640 2081560 3151080 40% /var
/dev/mapper/vg_root-loglv 5232640 80876 5151764 2% /var/log
/dev/mapper/vg_root-cachelv 26201600 852792 25348808 4% /var/cache
/dev/mapper/vg_root-homelv 5232640 159260 5073380 4% /home
/dev/mapper/vg_root-tmplv 5232640 479624 4753016 10% /tmp
/dev/mapper/vg_u01-u01lv 314415108 282614064 31801044 90% /u01 
/dev/mapper/vg_root-optlv 10475520 3118680 7356840 30% /opt
/dev/mapper/vg_root-auditlv 5232640 67764 5164876 2% /var/log/audit
depot-nfs:/export/depot/scripts 104857600 36052448 68805152 35% /import/scripts   

Huge size of OVM DB backups:

# du -sh /u01/app/oracle/mysql/*
14G /u01/app/oracle/mysql/data
249G /u01/app/oracle/mysql/dbbackup

Mgr_EventManager.ibd table found to be consume excessive disk space contributing to the huge size of the auto DB backups:

# ls -lt /u01/app/oracle/mysql/data/ovs/Mgr_EventManager*
6.1G /u01/app/oracle/mysql/data/ovs/Mgr_EventManager.ibd

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.