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:
Oracle VM - Version 3.2.1 and laterLinux x86-64
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |