[OVM] Issues with huge OVM_STATISTIC.ibd used as OVM_STATISTIC Table.

(Doc ID 2216441.1)

Last updated on NOVEMBER 22, 2017

Applies to:

Oracle VM - Version 3.4.1 and later
Linux x86-64

Symptoms

The OVM_STATISTIC.ibd of OVMM database is growing too huge.

# du -hs /u01/app/oracle/mysql/data/ovs/OVM_STATISTIC*
16K /u01/app/oracle/mysql/data/ovs/OVM_STATISTIC.frm
62G /u01/app/oracle/mysql/data/ovs/OVM_STATISTIC.ibd <--- this file

 

 

Login MySQL, the table contains too many records.

# mysql ovs -u ovs -p -S /u01/app/oracle/mysql/data/mysqld.sock
mysql> select count(*) from OVM_STATISTIC;
+----------+
| count(*) |
+----------+
| 97147640 |
+----------+

 

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms