MySQL Database System Summary - Daily

Daily summary for CPU, memory, IO and storage metrics, summed over all of the corresponding database's hosts for MySQL Database System

Table 16-17 MySQL Database CPU, IO and Storage daily

Field Name Name Column Type Column Category Description
ROLLUP_TIME_UTC Rollup time (UTC) TIMESTAMP TIME_DIMENSION End timestamp of the rollup period (UTC)
DAY_OF_WEEK Collection day of week VARCHAR2 DIMENSION Collection day in weekly range 1-7 (Mon-Sun)
DAY_OF_MONTH Collection day of month VARCHAR2 DIMENSION Collection day in monthly range 1-31
OPSI_ID Database insight OCID VARCHAR2 DIMENSION Database insight resource OCID
ASSOCIATED_RESOURCE_ID Associated resource identifier VARCHAR2 DIMENSION OCID of the related OCI resource
ENTITY_SOURCE Entity source VARCHAR2 DIMENSION Source type of the entity, acceptable values are: AUTONOMOUS_DATABASE, MACS_MANAGED_EXTERNAL_DATABASE and EM_MANAGED_EXTERNAL_DATABASE
OPSI_ENTITY_TYPE Database type VARCHAR2 DIMENSION Database type, for example: ADB-S, ATP-D, EXTERNAL-HOST, EXTERNAL-PDB, EXTERNAL-NONCDB
DB_SYSTEM_NAME Database system name VARCHAR2 DIMENSION Name of the database system
DB__SYSTEM_DISPLAY_NAME Database system display name VARCHAR2 DIMENSION Display name of the database system
DB_SYSTEM_VERSION Database system version VARCHAR2 DIMENSION Version of the database system
IS_HEATWAVE_CLUSTER_ATTACHED Heatwave attached VARCHAR2 DIMENSION Indicates if the MySQL Server has a HeatWave cluster attached
IS_HIGHLY_AVAILABLE HA enabled VARCHAR2 DIMENSION Indicates if the MySQL Server is enabled for high availability
SHAPE_NAME VM shape VARCHAR2 DIMENSION VM configuration of the MySQL Server MySQL.VM.Standard.E4.1.8GB
OCPU_USED OCPUs Used NUMBER METRIC Actual number of OCPUs used by the host over the time interval
OCPU_USED_MAX Maximum (daily) OCPUs Used NUMBER METRIC Maximum (daily) number of OCPUs used by the host over the time interval
OCPU_CAPACITY Allocated Host CPUs NUMBER DIMENSION Total number of OCPUs for the MySQL DB system host running the deployed database's primary instance
CPU_UTILIZATION CPU utilization (%) NUMBER METRIC Activity level from CPU, expressed as a percentage of total time
CPU_UTILIZATION_MAX Maximum (daily) CPU utilization (%) NUMBER METRIC Maximum (daily) activity level from CPU, expressed as a percentage of total time
WRITE_IO_MBPS Write IO per second (MB/sec) NUMBER METRIC Number of IO (in megabytes) per second to the database
WRITE_IO_MBPS_MAX Maximum (daily) Write IO per second (MB/sec) NUMBER METRIC Maximum (daily) number of IO (in megabytes) per second to the database
READ_IO_MBPS Read IO per second (MB/sec) NUMBER METRIC Number of IO (in megabytes) per second from the database
READ_IO_MBPS_MAX Maximum (daily) Read IO per second (MB/sec) NUMBER METRIC Maximum (daily) number of IO (in megabytes) per second from the database
IO_USAGE Read and write IO per second (MB/sec) NUMBER METRIC Number of IO (in megabytes) per second to and from the database
IO_USAGE_MAX Maximum (daily) read and write IO per second (MB/sec) NUMBER METRIC Maximum (daily) number of IO (in megabytes) per second to and from the database
MEMORY_USAGE Host memory usage (GB) NUMBER METRIC Memory used by the MySQL DB system host, running the deployed database's primary instance
MEMORY_USAGE_MAX Maximum (daily) host memory usage (GB) NUMBER METRIC Maximum (daily) memory used by the MySQL DB system host, running the deployed database's primary instance
MEMORY_UTIL Host memory utilization (%) NUMBER METRIC Memory utilized by the MySQL DB system host, running the deployed database's primary instance
MEMORY_UTIL_MAX Maximum (daily) host memory utilization (%) NUMBER METRIC Maximum (daily) memory utilized by the MySQL DB system host, running the deployed database's primary instances
MEMORY_ALLOCATED Host memory capacity (GB) NUMBER METRIC Total memory (in gigabytes) allocated to the MySQL DB system host, running the deployed database's primary instance
STORAGE_USAGE Database storage usage (GB) NUMBER METRIC Storage used (in gigabytes) on the disk
STORAGE_USAGE_MAX Maximum (daily) database storage usage (GB) NUMBER METRIC Maximum (daily) storage used (in gigabytes) on the disk
STORAGE_ALLOCATED Storage allocated to the disk (GB) NUMBER METRIC Capacity (in gigabytes) of the storage disk
STORAGE_UTIL Storage space utilization (%) NUMBER METRIC Percent of storage utilized on the disk
STORAGE_UTIL_MAX Maximum (daily) storage space utilization (%) NUMBER METRIC Maximum (daily) percent of storage utilized on the disk