MySQL Database Summary - Hourly
Hourly summary for CPU, memory, IO and storage metrics, summed over all of the corresponding database system's hosts for MySQL Database System
Table 16-18 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) |
HOUR_OF_DAY | Collection hour of day | VARCHAR2 | DIMENSION | Collection hour in hourly range 0-23 |
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 |