PerformanceCaptureConfig(mapping=None, *, ignore_unknown_fields=False, **kwargs)Performance capture configuration.
.. _oneof: https://proto-plus-python.readthedocs.io/en/stable/fields.html#oneofs-mutually-exclusive-fields
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_v1.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.