MySqlQuerySampleDetails¶
- class oci.database_management.models.MySqlQuerySampleDetails(**kwargs)¶
Bases:
objectThe details of a query sample including the query text, execution time, and other details. MySQL support within OCI Database Management service has been deprecated as of January 29, 2026.
Methods:
__init__(**kwargs)Initializes a new MySqlQuerySampleDetails object with values from keyword arguments.
Attributes:
[Required] Gets the execution_time of this MySqlQuerySampleDetails.
[Required] Gets the host of this MySqlQuerySampleDetails.
[Required] Gets the mysql_instance of this MySqlQuerySampleDetails.
[Required] Gets the query_sample_text of this MySqlQuerySampleDetails.
[Required] Gets the thread_id of this MySqlQuerySampleDetails.
[Required] Gets the time_query_sample_seen of this MySqlQuerySampleDetails.
[Required] Gets the user of this MySqlQuerySampleDetails.
- __init__(**kwargs)¶
Initializes a new MySqlQuerySampleDetails object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
query_sample_text (str) – The value to assign to the query_sample_text property of this MySqlQuerySampleDetails.
time_query_sample_seen (datetime) – The value to assign to the time_query_sample_seen property of this MySqlQuerySampleDetails.
execution_time (int) – The value to assign to the execution_time property of this MySqlQuerySampleDetails.
thread_id (int) – The value to assign to the thread_id property of this MySqlQuerySampleDetails.
user (str) – The value to assign to the user property of this MySqlQuerySampleDetails.
host (str) – The value to assign to the host property of this MySqlQuerySampleDetails.
mysql_instance (str) – The value to assign to the mysql_instance property of this MySqlQuerySampleDetails.
- property execution_time¶
[Required] Gets the execution_time of this MySqlQuerySampleDetails. The total amount of time that has been spent executing the query sample.
- Returns
The execution_time of this MySqlQuerySampleDetails.
- Return type
int
- property host¶
[Required] Gets the host of this MySqlQuerySampleDetails. The host from which the query sample was run.
- Returns
The host of this MySqlQuerySampleDetails.
- Return type
str
- property mysql_instance¶
[Required] Gets the mysql_instance of this MySqlQuerySampleDetails. The MySQL instance against which the query sample was run.
- Returns
The mysql_instance of this MySqlQuerySampleDetails.
- Return type
str
- property query_sample_text¶
[Required] Gets the query_sample_text of this MySqlQuerySampleDetails. The query sample mapped by MySQL to a given normalized query.
- Returns
The query_sample_text of this MySqlQuerySampleDetails.
- Return type
str
- property thread_id¶
[Required] Gets the thread_id of this MySqlQuerySampleDetails. The thread ID of the connection.
- Returns
The thread_id of this MySqlQuerySampleDetails.
- Return type
int
- property time_query_sample_seen¶
[Required] Gets the time_query_sample_seen of this MySqlQuerySampleDetails. The date and time the query sample was last seen.
- Returns
The time_query_sample_seen of this MySqlQuerySampleDetails.
- Return type
datetime
- property user¶
[Required] Gets the user of this MySqlQuerySampleDetails. The user who ran the query sample.
- Returns
The user of this MySqlQuerySampleDetails.
- Return type
str