Class PerformanceCaptureConfig (0.1.1)

PerformanceCaptureConfig(mapping=None, *, ignore_unknown_fields=False, **kwargs)

Attributes

Name Description
enabled bool
Optional. Enables or disables the performance capture feature. This field is a member of oneof_ _enabled.
probing_interval_seconds int
Optional. Specifies the interval in seconds between consecutive probes that check if any trigger condition thresholds have been reached. This field is a member of oneof_ _probing_interval_seconds.
probe_threshold int
Optional. Specifies the minimum number of consecutive probe threshold that triggers performance capture. This field is a member of oneof_ _probe_threshold.
running_threads_threshold int
Optional. Specifies the minimum number of MySQL Threads_running to trigger the performance capture on the primary instance. This field is a member of oneof_ _running_threads_threshold.
seconds_behind_source_threshold int
Optional. Specifies the minimum number of seconds replica must be lagging behind primary instance to trigger the performance capture on replica. This field is a member of oneof_ _seconds_behind_source_threshold.
transaction_duration_threshold int
Optional. Specifies the amount of time in seconds that a transaction needs to have been open before the watcher starts recording it. This field is a member of oneof_ _transaction_duration_threshold.
cpu_utilization_threshold_percent int
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. This field is a member of oneof_ _cpu_utilization_threshold_percent.
memory_usage_threshold_percent int
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. This field is a member of oneof_ _memory_usage_threshold_percent.
transaction_lock_wait_threshold_count int
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. This field is a member of oneof_ _transaction_lock_wait_threshold_count.
semaphore_wait_threshold_count int
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. This field is a member of oneof_ _semaphore_wait_threshold_count.
history_list_length_threshold_count int
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. This field is a member of oneof_ _history_list_length_threshold_count.
transaction_kill_threshold_seconds int
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=""><> will be rejected. This field is a member of oneof_ _transaction_kill_threshold_seconds.
transaction_kill_excluded_user_hosts MutableSequence[str]
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@%"]
transaction_kill_type google.cloud.sqladmin_v1beta4.types.PerformanceCaptureConfig.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. This field is a member of oneof_ _transaction_kill_type.

Classes

TransactionKillType

TransactionKillType(value)

Defines the categories of long-running transactions eligible for automatic termination by the Performance Capture.