MySqlQuerySampleDetails¶

class oci.database_management.models.MySqlQuerySampleDetails(**kwargs)¶

Bases: object

The details of a query sample including the query text, execution time and other details.

Methods

__init__(**kwargs) Initializes a new MySqlQuerySampleDetails object with values from keyword arguments.

Attributes

`execution_time`	[Required] Gets the execution_time of this MySqlQuerySampleDetails.
`host`	[Required] Gets the host of this MySqlQuerySampleDetails.
`mysql_instance`	[Required] Gets the mysql_instance of this MySqlQuerySampleDetails.
`query_sample_text`	[Required] Gets the query_sample_text of this MySqlQuerySampleDetails.
`thread_id`	[Required] Gets the thread_id of this MySqlQuerySampleDetails.
`time_query_sample_seen`	[Required] Gets the time_query_sample_seen of this MySqlQuerySampleDetails.
`user`	[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.

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

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

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

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

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

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

user¶

[Required] Gets the user of this MySqlQuerySampleDetails. The user who ran the query sample.

Returns:	The user of this MySqlQuerySampleDetails.
Return type:	str