Class PerformanceCaptureConfig

Performance capture configuration.

Inheritance

object

PerformanceCaptureConfig

Implements

IDirectResponseSchema

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Google.Apis.SQLAdmin.v1.Data

Assembly: Google.Apis.SQLAdmin.v1.dll

Syntax

public class PerformanceCaptureConfig : IDirectResponseSchema

Properties

CpuUtilizationThresholdPercent

Optional. Specifies the minimum percentage of CPU utilization to trigger the performance capture. Valid integers range from 10 to 99. Enter 0 to disable the check.

Declaration

[JsonProperty("cpuUtilizationThresholdPercent")]
public virtual int? CpuUtilizationThresholdPercent { get; set; }

Property Value

Type	Description
int?

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
string

Enabled

Optional. Enables or disables the performance capture feature.

Declaration

[JsonProperty("enabled")]
public virtual bool? Enabled { get; set; }

Property Value

Type	Description
bool?

HistoryListLengthThresholdCount

Optional. Specifies the minimum number of undo log entries in the history list length to trigger the performance capture. Valid integers range from 10000 to 10000000. Enter 0 to disable the check.

Declaration

[JsonProperty("historyListLengthThresholdCount")]
public virtual int? HistoryListLengthThresholdCount { get; set; }

Property Value

Type	Description
int?

MemoryUsageThresholdPercent

Optional. Specifies the minimum percentage of memory usage to trigger the performance capture. Valid integers range from 10 to 99. Enter 0 to disable the check.

Declaration

[JsonProperty("memoryUsageThresholdPercent")]
public virtual int? MemoryUsageThresholdPercent { get; set; }

Property Value

Type	Description
int?

ProbeThreshold

Optional. Specifies the minimum number of consecutive probe threshold that triggers performance capture.

Declaration

[JsonProperty("probeThreshold")]
public virtual int? ProbeThreshold { get; set; }

Property Value

Type	Description
int?

ProbingIntervalSeconds

Optional. Specifies the interval in seconds between consecutive probes that check if any trigger condition thresholds have been reached.

Declaration

[JsonProperty("probingIntervalSeconds")]
public virtual int? ProbingIntervalSeconds { get; set; }

Property Value

Type	Description
int?

RunningThreadsThreshold

Optional. Specifies the minimum number of MySQL Threads_running to trigger the performance capture on the primary instance.

Declaration

[JsonProperty("runningThreadsThreshold")]
public virtual int? RunningThreadsThreshold { get; set; }

Property Value

Type	Description
int?

SecondsBehindSourceThreshold

Optional. Specifies the minimum number of seconds replica must be lagging behind primary instance to trigger the performance capture on replica.

Declaration

[JsonProperty("secondsBehindSourceThreshold")]
public virtual int? SecondsBehindSourceThreshold { get; set; }

Property Value

Type	Description
int?

SemaphoreWaitThresholdCount

Optional. Specifies the minimum allowed number of semaphore waits to trigger the performance capture. Valid integers range from 10 to 10000. Enter 0 to disable the check.

Declaration

[JsonProperty("semaphoreWaitThresholdCount")]
public virtual int? SemaphoreWaitThresholdCount { get; set; }

Property Value

Type	Description
int?

TransactionDurationThreshold

Optional. Specifies the amount of time in seconds that a transaction needs to have been open before the watcher starts recording it.

Declaration

[JsonProperty("transactionDurationThreshold")]
public virtual int? TransactionDurationThreshold { get; set; }

Property Value

Type	Description
int?

TransactionKillExcludedUserHosts

Optional. Specifies a customer-defined list of users to exclude from transaction termination. Entries can be in the format 'user@host' or just 'user'. A standalone 'user' implies 'user@%', excluding the user from any host. Wildcard '%' is allowed in the host part of the 'user@host' format. Example: ["app_user", "db_admin@10.1.2.3", "report_user@%"]

Declaration

[JsonProperty("transactionKillExcludedUserHosts")]
public virtual IList<string> TransactionKillExcludedUserHosts { get; set; }

Property Value

Type	Description
IList<string>

TransactionKillThresholdSeconds

Optional. Specifies the amount of time in seconds that a transaction needs to have been open before the watcher starts terminating it. Valid integers range from 60 to 604800 (7 days). Enter 0 to disable. If enabled (i.e., > 0), this value must be greater than or equal to transaction_duration_threshold. Configurations where 0 < transaction_kill_threshold_seconds < transaction_duration_threshold will be rejected.

Declaration

[JsonProperty("transactionKillThresholdSeconds")]
public virtual int? TransactionKillThresholdSeconds { get; set; }

Property Value

Type	Description
int?

TransactionKillType

Optional. Determines which transactions are allowed to be terminated when they exceed transaction_kill_threshold_seconds. This allows protecting write-heavy transactions from auto-termination if desired. Defaults to READ_ONLY_TRANSACTIONS if unspecified.

Declaration

[JsonProperty("transactionKillType")]
public virtual string TransactionKillType { get; set; }

Property Value

Type	Description
string

TransactionLockWaitThresholdCount

Optional. Specifies the minimum allowed number of transactions in lock wait state to trigger the performance capture. Valid integers range from 10 to 10000. Enter 0 to disable the check.

Declaration

[JsonProperty("transactionLockWaitThresholdCount")]
public virtual int? TransactionLockWaitThresholdCount { get; set; }

Property Value

Type	Description
int?

Implements

IDirectResponseSchema