Oracle Cloud Infrastructure v1.41.0, Jun 19 24

Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

oci.DatabaseManagement.getManagedMySqlDatabaseSqlData

Explore with Pulumi AI

Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedMySqlDatabaseSqlData = oci.DatabaseManagement.getManagedMySqlDatabaseSqlData({
    endTime: managedMySqlDatabaseSqlDataEndTime,
    managedMySqlDatabaseId: testManagedMySqlDatabase.id,
    startTime: managedMySqlDatabaseSqlDataStartTime,
    filterColumn: managedMySqlDatabaseSqlDataFilterColumn,
});

import pulumi
import pulumi_oci as oci

test_managed_my_sql_database_sql_data = oci.DatabaseManagement.get_managed_my_sql_database_sql_data(end_time=managed_my_sql_database_sql_data_end_time,
    managed_my_sql_database_id=test_managed_my_sql_database["id"],
    start_time=managed_my_sql_database_sql_data_start_time,
    filter_column=managed_my_sql_database_sql_data_filter_column)

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/go/oci/DatabaseManagement"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := DatabaseManagement.GetManagedMySqlDatabaseSqlData(ctx, &databasemanagement.GetManagedMySqlDatabaseSqlDataArgs{
			EndTime:                managedMySqlDatabaseSqlDataEndTime,
			ManagedMySqlDatabaseId: testManagedMySqlDatabase.Id,
			StartTime:              managedMySqlDatabaseSqlDataStartTime,
			FilterColumn:           pulumi.StringRef(managedMySqlDatabaseSqlDataFilterColumn),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testManagedMySqlDatabaseSqlData = Oci.DatabaseManagement.GetManagedMySqlDatabaseSqlData.Invoke(new()
    {
        EndTime = managedMySqlDatabaseSqlDataEndTime,
        ManagedMySqlDatabaseId = testManagedMySqlDatabase.Id,
        StartTime = managedMySqlDatabaseSqlDataStartTime,
        FilterColumn = managedMySqlDatabaseSqlDataFilterColumn,
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetManagedMySqlDatabaseSqlDataArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testManagedMySqlDatabaseSqlData = DatabaseManagementFunctions.getManagedMySqlDatabaseSqlData(GetManagedMySqlDatabaseSqlDataArgs.builder()
            .endTime(managedMySqlDatabaseSqlDataEndTime)
            .managedMySqlDatabaseId(testManagedMySqlDatabase.id())
            .startTime(managedMySqlDatabaseSqlDataStartTime)
            .filterColumn(managedMySqlDatabaseSqlDataFilterColumn)
            .build());

    }
}

variables:
  testManagedMySqlDatabaseSqlData:
    fn::invoke:
      Function: oci:DatabaseManagement:getManagedMySqlDatabaseSqlData
      Arguments:
        endTime: ${managedMySqlDatabaseSqlDataEndTime}
        managedMySqlDatabaseId: ${testManagedMySqlDatabase.id}
        startTime: ${managedMySqlDatabaseSqlDataStartTime}
        filterColumn: ${managedMySqlDatabaseSqlDataFilterColumn}

Using getManagedMySqlDatabaseSqlData

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getManagedMySqlDatabaseSqlData(args: GetManagedMySqlDatabaseSqlDataArgs, opts?: InvokeOptions): Promise<GetManagedMySqlDatabaseSqlDataResult>
function getManagedMySqlDatabaseSqlDataOutput(args: GetManagedMySqlDatabaseSqlDataOutputArgs, opts?: InvokeOptions): Output<GetManagedMySqlDatabaseSqlDataResult>

def get_managed_my_sql_database_sql_data(end_time: Optional[str] = None,
                                         filter_column: Optional[str] = None,
                                         filters: Optional[Sequence[_databasemanagement.GetManagedMySqlDatabaseSqlDataFilter]] = None,
                                         managed_my_sql_database_id: Optional[str] = None,
                                         start_time: Optional[str] = None,
                                         opts: Optional[InvokeOptions] = None) -> GetManagedMySqlDatabaseSqlDataResult
def get_managed_my_sql_database_sql_data_output(end_time: Optional[pulumi.Input[str]] = None,
                                         filter_column: Optional[pulumi.Input[str]] = None,
                                         filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedMySqlDatabaseSqlDataFilterArgs]]]] = None,
                                         managed_my_sql_database_id: Optional[pulumi.Input[str]] = None,
                                         start_time: Optional[pulumi.Input[str]] = None,
                                         opts: Optional[InvokeOptions] = None) -> Output[GetManagedMySqlDatabaseSqlDataResult]

func GetManagedMySqlDatabaseSqlData(ctx *Context, args *GetManagedMySqlDatabaseSqlDataArgs, opts ...InvokeOption) (*GetManagedMySqlDatabaseSqlDataResult, error)
func GetManagedMySqlDatabaseSqlDataOutput(ctx *Context, args *GetManagedMySqlDatabaseSqlDataOutputArgs, opts ...InvokeOption) GetManagedMySqlDatabaseSqlDataResultOutput

> Note: This function is named GetManagedMySqlDatabaseSqlData in the Go SDK.

public static class GetManagedMySqlDatabaseSqlData 
{
    public static Task<GetManagedMySqlDatabaseSqlDataResult> InvokeAsync(GetManagedMySqlDatabaseSqlDataArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedMySqlDatabaseSqlDataResult> Invoke(GetManagedMySqlDatabaseSqlDataInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetManagedMySqlDatabaseSqlDataResult> getManagedMySqlDatabaseSqlData(GetManagedMySqlDatabaseSqlDataArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: oci:DatabaseManagement/getManagedMySqlDatabaseSqlData:getManagedMySqlDatabaseSqlData
  arguments:
    # arguments dictionary

The following arguments are supported:

EndTime string

The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

ManagedMySqlDatabaseId string

The OCID of the Managed MySQL Database.

StartTime string

The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

FilterColumn string

The parameter to filter results by key criteria which include :

AVG_TIMER_WAIT
SUM_TIMER_WAIT
COUNT_STAR
SUM_ERRORS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_TABLES
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
FIRST_SEEN
LAST_SEEN
HEATWAVE_OFFLOADED
HEATWAVE_OUT_OF_MEMORY

Filters List<GetManagedMySqlDatabaseSqlDataFilter>

EndTime string

The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

ManagedMySqlDatabaseId string

The OCID of the Managed MySQL Database.

StartTime string

The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

FilterColumn string

The parameter to filter results by key criteria which include :

AVG_TIMER_WAIT
SUM_TIMER_WAIT
COUNT_STAR
SUM_ERRORS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_TABLES
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
FIRST_SEEN
LAST_SEEN
HEATWAVE_OFFLOADED
HEATWAVE_OUT_OF_MEMORY

Filters []GetManagedMySqlDatabaseSqlDataFilter

endTime String

The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

managedMySqlDatabaseId String

The OCID of the Managed MySQL Database.

startTime String

The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

filterColumn String

The parameter to filter results by key criteria which include :

AVG_TIMER_WAIT
SUM_TIMER_WAIT
COUNT_STAR
SUM_ERRORS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_TABLES
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
FIRST_SEEN
LAST_SEEN
HEATWAVE_OFFLOADED
HEATWAVE_OUT_OF_MEMORY

filters List<GetManagedMySqlDatabaseSqlDataFilter>

endTime string

The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

managedMySqlDatabaseId string

The OCID of the Managed MySQL Database.

startTime string

The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

filterColumn string

The parameter to filter results by key criteria which include :

AVG_TIMER_WAIT
SUM_TIMER_WAIT
COUNT_STAR
SUM_ERRORS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_TABLES
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
FIRST_SEEN
LAST_SEEN
HEATWAVE_OFFLOADED
HEATWAVE_OUT_OF_MEMORY

filters GetManagedMySqlDatabaseSqlDataFilter[]

end_time str

The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

managed_my_sql_database_id str

The OCID of the Managed MySQL Database.

start_time str

The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

filter_column str

The parameter to filter results by key criteria which include :

AVG_TIMER_WAIT
SUM_TIMER_WAIT
COUNT_STAR
SUM_ERRORS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_TABLES
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
FIRST_SEEN
LAST_SEEN
HEATWAVE_OFFLOADED
HEATWAVE_OUT_OF_MEMORY

filters Sequence[databasemanagement.GetManagedMySqlDatabaseSqlDataFilter]

endTime String

The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

managedMySqlDatabaseId String

The OCID of the Managed MySQL Database.

startTime String

The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".

filterColumn String

The parameter to filter results by key criteria which include :

AVG_TIMER_WAIT
SUM_TIMER_WAIT
COUNT_STAR
SUM_ERRORS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_TABLES
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
FIRST_SEEN
LAST_SEEN
HEATWAVE_OFFLOADED
HEATWAVE_OUT_OF_MEMORY

filters List<Property Map>

getManagedMySqlDatabaseSqlData Result

The following output properties are available:

EndTime string
Id string: The provider-assigned unique ID for this managed resource.
ManagedMySqlDatabaseId string
MySqlDataCollections List<GetManagedMySqlDatabaseSqlDataMySqlDataCollection>: The list of my_sql_data_collection.
StartTime string
FilterColumn string
Filters List<GetManagedMySqlDatabaseSqlDataFilter>

EndTime string
Id string: The provider-assigned unique ID for this managed resource.
ManagedMySqlDatabaseId string
MySqlDataCollections []GetManagedMySqlDatabaseSqlDataMySqlDataCollection: The list of my_sql_data_collection.
StartTime string
FilterColumn string
Filters []GetManagedMySqlDatabaseSqlDataFilter

endTime String
id String: The provider-assigned unique ID for this managed resource.
managedMySqlDatabaseId String
mySqlDataCollections List<GetManagedMySqlDatabaseSqlDataMySqlDataCollection>: The list of my_sql_data_collection.
startTime String
filterColumn String
filters List<GetManagedMySqlDatabaseSqlDataFilter>

endTime string
id string: The provider-assigned unique ID for this managed resource.
managedMySqlDatabaseId string
mySqlDataCollections GetManagedMySqlDatabaseSqlDataMySqlDataCollection[]: The list of my_sql_data_collection.
startTime string
filterColumn string
filters GetManagedMySqlDatabaseSqlDataFilter[]

end_time str
id str: The provider-assigned unique ID for this managed resource.
managed_my_sql_database_id str
my_sql_data_collections Sequence[databasemanagement.GetManagedMySqlDatabaseSqlDataMySqlDataCollection]: The list of my_sql_data_collection.
start_time str
filter_column str
filters Sequence[databasemanagement.GetManagedMySqlDatabaseSqlDataFilter]

endTime String
id String: The provider-assigned unique ID for this managed resource.
managedMySqlDatabaseId String
mySqlDataCollections List<Property Map>: The list of my_sql_data_collection.
startTime String
filterColumn String
filters List<Property Map>

Supporting Types

GetManagedMySqlDatabaseSqlDataFilter

Name string
Values List<string>
Regex bool

Name string
Values []string
Regex bool

name String
values List<String>
regex Boolean

name string
values string[]
regex boolean

name str
values Sequence[str]
regex bool

name String
values List<String>
regex Boolean

GetManagedMySqlDatabaseSqlDataMySqlDataCollection

Items List<GetManagedMySqlDatabaseSqlDataMySqlDataCollectionItem>: The list of SQLDataSummary records.

Items []GetManagedMySqlDatabaseSqlDataMySqlDataCollectionItem: The list of SQLDataSummary records.

items List<GetManagedMySqlDatabaseSqlDataMySqlDataCollectionItem>: The list of SQLDataSummary records.

items GetManagedMySqlDatabaseSqlDataMySqlDataCollectionItem[]: The list of SQLDataSummary records.

items Sequence[databasemanagement.GetManagedMySqlDatabaseSqlDataMySqlDataCollectionItem]: The list of SQLDataSummary records.

items List<Property Map>: The list of SQLDataSummary records.

GetManagedMySqlDatabaseSqlDataMySqlDataCollectionItem

AvgTimerWait double: The average execution time.
CountStar double: The number Of times the query has been executed.
Digest string: The digest information of the normalized query.
DigestText string: The normalized query.
FirstSeen string: The date and time the query was first seen. If the table is truncated, the first seen value is reset.
HeatWaveOffloaded double: The number of query executions offloaded to HeatWave.
HeatWaveOutOfMemory double: The number of query executions with HeatWave out-of-memory errors.
LastSeen string: The date and time the query was last seen.
MaxTimerWait double: The slowest the query has been executed.
MinTimerWait double: The fastest the query has been executed.
Quantile95 double: The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
Quantile99 double: The 99th percentile of the query latency.
Quantile999 double: The 99.9th percentile of the query latency.
SchemaName string: The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
SumCreatedTempDiskTables double: The total number of On-Disk internal temporary tables that have been created by the query.
SumCreatedTempTables double: The total number of internal temporary tables (in memory or on disk), which have been created by the query.
SumErrors double: The total number of errors that have been encountered executing the query.
SumLockTime double: The total amount of time that has been spent waiting for table locks.
SumNoGoodIndexUsed double: The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
SumNoIndexUsed double: The total number of times no index was used to execute the query.
SumRowsAffected double: The total number of rows that have been modified by the query.
SumRowsExamined double: The total number of rows that have been examined by the query.
SumRowsSent double: The total number of rows that have been returned (sent) to the client.
SumSelectFullJoin double: The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
SumSelectFullRangeJoin double: The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
SumSelectRange double: The total number of times the query has used a range search. This is the same as the select_range status variable.
SumSelectRangeCheck double: The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
SumSelectScan double: The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
SumSortMergePasses double: The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
SumSortRange double: The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
SumSortRows double: The total number of rows sorted. This is the same as the sort_rowsStatus variable.
SumSortScan double: The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
SumTimerWait double: The total amount of time that has been spent executing the query.
SumWarnings double: The total number of warnings that have been encountered executing the query.

AvgTimerWait float64: The average execution time.
CountStar float64: The number Of times the query has been executed.
Digest string: The digest information of the normalized query.
DigestText string: The normalized query.
FirstSeen string: The date and time the query was first seen. If the table is truncated, the first seen value is reset.
HeatWaveOffloaded float64: The number of query executions offloaded to HeatWave.
HeatWaveOutOfMemory float64: The number of query executions with HeatWave out-of-memory errors.
LastSeen string: The date and time the query was last seen.
MaxTimerWait float64: The slowest the query has been executed.
MinTimerWait float64: The fastest the query has been executed.
Quantile95 float64: The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
Quantile99 float64: The 99th percentile of the query latency.
Quantile999 float64: The 99.9th percentile of the query latency.
SchemaName string: The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
SumCreatedTempDiskTables float64: The total number of On-Disk internal temporary tables that have been created by the query.
SumCreatedTempTables float64: The total number of internal temporary tables (in memory or on disk), which have been created by the query.
SumErrors float64: The total number of errors that have been encountered executing the query.
SumLockTime float64: The total amount of time that has been spent waiting for table locks.
SumNoGoodIndexUsed float64: The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
SumNoIndexUsed float64: The total number of times no index was used to execute the query.
SumRowsAffected float64: The total number of rows that have been modified by the query.
SumRowsExamined float64: The total number of rows that have been examined by the query.
SumRowsSent float64: The total number of rows that have been returned (sent) to the client.
SumSelectFullJoin float64: The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
SumSelectFullRangeJoin float64: The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
SumSelectRange float64: The total number of times the query has used a range search. This is the same as the select_range status variable.
SumSelectRangeCheck float64: The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
SumSelectScan float64: The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
SumSortMergePasses float64: The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
SumSortRange float64: The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
SumSortRows float64: The total number of rows sorted. This is the same as the sort_rowsStatus variable.
SumSortScan float64: The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
SumTimerWait float64: The total amount of time that has been spent executing the query.
SumWarnings float64: The total number of warnings that have been encountered executing the query.

avgTimerWait Double: The average execution time.
countStar Double: The number Of times the query has been executed.
digest String: The digest information of the normalized query.
digestText String: The normalized query.
firstSeen String: The date and time the query was first seen. If the table is truncated, the first seen value is reset.
heatWaveOffloaded Double: The number of query executions offloaded to HeatWave.
heatWaveOutOfMemory Double: The number of query executions with HeatWave out-of-memory errors.
lastSeen String: The date and time the query was last seen.
maxTimerWait Double: The slowest the query has been executed.
minTimerWait Double: The fastest the query has been executed.
quantile95 Double: The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
quantile99 Double: The 99th percentile of the query latency.
quantile999 Double: The 99.9th percentile of the query latency.
schemaName String: The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
sumCreatedTempDiskTables Double: The total number of On-Disk internal temporary tables that have been created by the query.
sumCreatedTempTables Double: The total number of internal temporary tables (in memory or on disk), which have been created by the query.
sumErrors Double: The total number of errors that have been encountered executing the query.
sumLockTime Double: The total amount of time that has been spent waiting for table locks.
sumNoGoodIndexUsed Double: The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
sumNoIndexUsed Double: The total number of times no index was used to execute the query.
sumRowsAffected Double: The total number of rows that have been modified by the query.
sumRowsExamined Double: The total number of rows that have been examined by the query.
sumRowsSent Double: The total number of rows that have been returned (sent) to the client.
sumSelectFullJoin Double: The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
sumSelectFullRangeJoin Double: The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
sumSelectRange Double: The total number of times the query has used a range search. This is the same as the select_range status variable.
sumSelectRangeCheck Double: The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
sumSelectScan Double: The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
sumSortMergePasses Double: The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
sumSortRange Double: The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
sumSortRows Double: The total number of rows sorted. This is the same as the sort_rowsStatus variable.
sumSortScan Double: The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
sumTimerWait Double: The total amount of time that has been spent executing the query.
sumWarnings Double: The total number of warnings that have been encountered executing the query.

avgTimerWait number: The average execution time.
countStar number: The number Of times the query has been executed.
digest string: The digest information of the normalized query.
digestText string: The normalized query.
firstSeen string: The date and time the query was first seen. If the table is truncated, the first seen value is reset.
heatWaveOffloaded number: The number of query executions offloaded to HeatWave.
heatWaveOutOfMemory number: The number of query executions with HeatWave out-of-memory errors.
lastSeen string: The date and time the query was last seen.
maxTimerWait number: The slowest the query has been executed.
minTimerWait number: The fastest the query has been executed.
quantile95 number: The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
quantile99 number: The 99th percentile of the query latency.
quantile999 number: The 99.9th percentile of the query latency.
schemaName string: The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
sumCreatedTempDiskTables number: The total number of On-Disk internal temporary tables that have been created by the query.
sumCreatedTempTables number: The total number of internal temporary tables (in memory or on disk), which have been created by the query.
sumErrors number: The total number of errors that have been encountered executing the query.
sumLockTime number: The total amount of time that has been spent waiting for table locks.
sumNoGoodIndexUsed number: The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
sumNoIndexUsed number: The total number of times no index was used to execute the query.
sumRowsAffected number: The total number of rows that have been modified by the query.
sumRowsExamined number: The total number of rows that have been examined by the query.
sumRowsSent number: The total number of rows that have been returned (sent) to the client.
sumSelectFullJoin number: The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
sumSelectFullRangeJoin number: The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
sumSelectRange number: The total number of times the query has used a range search. This is the same as the select_range status variable.
sumSelectRangeCheck number: The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
sumSelectScan number: The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
sumSortMergePasses number: The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
sumSortRange number: The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
sumSortRows number: The total number of rows sorted. This is the same as the sort_rowsStatus variable.
sumSortScan number: The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
sumTimerWait number: The total amount of time that has been spent executing the query.
sumWarnings number: The total number of warnings that have been encountered executing the query.

avg_timer_wait float: The average execution time.
count_star float: The number Of times the query has been executed.
digest str: The digest information of the normalized query.
digest_text str: The normalized query.
first_seen str: The date and time the query was first seen. If the table is truncated, the first seen value is reset.
heat_wave_offloaded float: The number of query executions offloaded to HeatWave.
heat_wave_out_of_memory float: The number of query executions with HeatWave out-of-memory errors.
last_seen str: The date and time the query was last seen.
max_timer_wait float: The slowest the query has been executed.
min_timer_wait float: The fastest the query has been executed.
quantile95 float: The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
quantile99 float: The 99th percentile of the query latency.
quantile999 float: The 99.9th percentile of the query latency.
schema_name str: The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
sum_created_temp_disk_tables float: The total number of On-Disk internal temporary tables that have been created by the query.
sum_created_temp_tables float: The total number of internal temporary tables (in memory or on disk), which have been created by the query.
sum_errors float: The total number of errors that have been encountered executing the query.
sum_lock_time float: The total amount of time that has been spent waiting for table locks.
sum_no_good_index_used float: The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
sum_no_index_used float: The total number of times no index was used to execute the query.
sum_rows_affected float: The total number of rows that have been modified by the query.
sum_rows_examined float: The total number of rows that have been examined by the query.
sum_rows_sent float: The total number of rows that have been returned (sent) to the client.
sum_select_full_join float: The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
sum_select_full_range_join float: The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
sum_select_range float: The total number of times the query has used a range search. This is the same as the select_range status variable.
sum_select_range_check float: The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
sum_select_scan float: The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
sum_sort_merge_passes float: The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
sum_sort_range float: The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
sum_sort_rows float: The total number of rows sorted. This is the same as the sort_rowsStatus variable.
sum_sort_scan float: The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
sum_timer_wait float: The total amount of time that has been spent executing the query.
sum_warnings float: The total number of warnings that have been encountered executing the query.

avgTimerWait Number: The average execution time.
countStar Number: The number Of times the query has been executed.
digest String: The digest information of the normalized query.
digestText String: The normalized query.
firstSeen String: The date and time the query was first seen. If the table is truncated, the first seen value is reset.
heatWaveOffloaded Number: The number of query executions offloaded to HeatWave.
heatWaveOutOfMemory Number: The number of query executions with HeatWave out-of-memory errors.
lastSeen String: The date and time the query was last seen.
maxTimerWait Number: The slowest the query has been executed.
minTimerWait Number: The fastest the query has been executed.
quantile95 Number: The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
quantile99 Number: The 99th percentile of the query latency.
quantile999 Number: The 99.9th percentile of the query latency.
schemaName String: The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
sumCreatedTempDiskTables Number: The total number of On-Disk internal temporary tables that have been created by the query.
sumCreatedTempTables Number: The total number of internal temporary tables (in memory or on disk), which have been created by the query.
sumErrors Number: The total number of errors that have been encountered executing the query.
sumLockTime Number: The total amount of time that has been spent waiting for table locks.
sumNoGoodIndexUsed Number: The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
sumNoIndexUsed Number: The total number of times no index was used to execute the query.
sumRowsAffected Number: The total number of rows that have been modified by the query.
sumRowsExamined Number: The total number of rows that have been examined by the query.
sumRowsSent Number: The total number of rows that have been returned (sent) to the client.
sumSelectFullJoin Number: The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
sumSelectFullRangeJoin Number: The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
sumSelectRange Number: The total number of times the query has used a range search. This is the same as the select_range status variable.
sumSelectRangeCheck Number: The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
sumSelectScan Number: The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
sumSortMergePasses Number: The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
sumSortRange Number: The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
sumSortRows Number: The total number of rows sorted. This is the same as the sort_rowsStatus variable.
sumSortScan Number: The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
sumTimerWait Number: The total amount of time that has been spent executing the query.
sumWarnings Number: The total number of warnings that have been encountered executing the query.

Package Details

Repository: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.

Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

pulumi/pulumi-oci

oci.DatabaseManagement.getManagedMySqlDatabaseSqlData

On this page

On this page

Example Usage

Using getManagedMySqlDatabaseSqlData

getManagedMySqlDatabaseSqlData Result

Supporting Types

GetManagedMySqlDatabaseSqlDataFilter

GetManagedMySqlDatabaseSqlDataMySqlDataCollection

GetManagedMySqlDatabaseSqlDataMySqlDataCollectionItem

Package Details

On this page

On this page