steampipe plugin install ocisteampipe plugin install oci

Table: oci_mysql_heat_wave_cluster - Query OCI MySQL HeatWave Clusters using SQL

MySQL HeatWave is an integrated, high-performance analytic engine for the MySQL Database Service in Oracle Cloud Infrastructure (OCI). It accelerates MySQL performance by orders of magnitude for analytics and scales to millions of queries per second. MySQL HeatWave provides a single, unified platform for both transaction processing and analytics, eliminating the need for ETL, data duplication, and data movement.

Table Usage Guide

The oci_mysql_heat_wave_cluster table provides insights into MySQL HeatWave Clusters within Oracle Cloud Infrastructure. As a database administrator or data analyst, explore cluster-specific details through this table, including cluster status, capacity, and associated metadata. Utilize it to uncover information about clusters, such as their configuration settings, performance metrics, and the verification of operational status.

Examples

Basic info

Explore the lifecycle state and creation time of your MySQL HeatWave clusters in Oracle Cloud Infrastructure. This can help you understand their status and longevity, which is useful for tracking usage and managing resources.

select
  db_system_id,
  lifecycle_state as state,
  time_created
from
  oci_mysql_heat_wave_cluster;

select
  db_system_id,
  lifecycle_state as state,
  time_created
from
  oci_mysql_heat_wave_cluster;

List failed heat wave clusters

Explore which MySQL Heat Wave clusters have failed to understand potential issues in your database system. This can help in troubleshooting and improving the system's reliability.

select
  db_system_id,
  lifecycle_state as state,
  time_created
from
  oci_mysql_heat_wave_cluster
where
  lifecycle_state = 'FAILED';

select
  db_system_id,
  lifecycle_state as state,
  time_created
from
  oci_mysql_heat_wave_cluster
where
  lifecycle_state = 'FAILED';

List heat wave clusters older than 90 days

Identify older heat wave clusters in your MySQL system to assess their lifecycle state and size. This is particularly useful for managing system resources and maintaining optimal database performance.

select
  db_system_id,
  lifecycle_state as state,
  time_created,
  cluster_size
from
  oci_mysql_heat_wave_cluster
where
  time_created <= (current_date - interval '90' day)
order by
  time_created;

select
  db_system_id,
  lifecycle_state as state,
  time_created,
  cluster_size
from
  oci_mysql_heat_wave_cluster
where
  time_created <= date('now', '-90 day')
order by
  time_created;

Schema for oci_mysql_heat_wave_cluster

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
cluster_nodes	jsonb		A HeatWave node is a compute host that is part of a HeatWave cluster.
cluster_size	bigint		The number of analytics-processing compute instances, of the specified shape, in the HeatWave cluster.
db_system_id	text	=	The OCID of the parent DB System this HeatWave cluster is attached to.
lifecycle_details	text		Additional information about the current lifecycleState.
lifecycle_state	text		The current state of the HeatWave cluster.
shape_name	text		The shape determines resources to allocate to the HeatWave nodes - CPU cores, memory.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tenant_name	text		The name of the Tenant in which the resource is located.
time_created	timestamp with time zone		The date and time the HeatWave cluster was created.
time_updated	timestamp with time zone		The time the HeatWave cluster was last updated.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- oci

You can pass the configuration to the command with the --config argument:

steampipe_export_oci --config '<your_config>' oci_mysql_heat_wave_cluster