MySqlDataSummary¶

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

Bases: object

The SQL performance data record for a specific SQL query.

Methods

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

Attributes

`avg_timer_wait`	[Required] Gets the avg_timer_wait of this MySqlDataSummary.
`count_star`	[Required] Gets the count_star of this MySqlDataSummary.
`digest`	[Required] Gets the digest of this MySqlDataSummary.
`digest_text`	[Required] Gets the digest_text of this MySqlDataSummary.
`first_seen`	[Required] Gets the first_seen of this MySqlDataSummary.
`heat_wave_offloaded`	Gets the heat_wave_offloaded of this MySqlDataSummary.
`heat_wave_out_of_memory`	Gets the heat_wave_out_of_memory of this MySqlDataSummary.
`last_seen`	[Required] Gets the last_seen of this MySqlDataSummary.
`max_timer_wait`	[Required] Gets the max_timer_wait of this MySqlDataSummary.
`min_timer_wait`	[Required] Gets the min_timer_wait of this MySqlDataSummary.
`quantile95`	[Required] Gets the quantile95 of this MySqlDataSummary.
`quantile99`	[Required] Gets the quantile99 of this MySqlDataSummary.
`quantile999`	[Required] Gets the quantile999 of this MySqlDataSummary.
`schema_name`	[Required] Gets the schema_name of this MySqlDataSummary.
`sum_created_temp_disk_tables`	[Required] Gets the sum_created_temp_disk_tables of this MySqlDataSummary.
`sum_created_temp_tables`	[Required] Gets the sum_created_temp_tables of this MySqlDataSummary.
`sum_errors`	[Required] Gets the sum_errors of this MySqlDataSummary.
`sum_lock_time`	[Required] Gets the sum_lock_time of this MySqlDataSummary.
`sum_no_good_index_used`	[Required] Gets the sum_no_good_index_used of this MySqlDataSummary.
`sum_no_index_used`	[Required] Gets the sum_no_index_used of this MySqlDataSummary.
`sum_rows_affected`	[Required] Gets the sum_rows_affected of this MySqlDataSummary.
`sum_rows_examined`	[Required] Gets the sum_rows_examined of this MySqlDataSummary.
`sum_rows_sent`	[Required] Gets the sum_rows_sent of this MySqlDataSummary.
`sum_select_full_join`	[Required] Gets the sum_select_full_join of this MySqlDataSummary.
`sum_select_full_range_join`	[Required] Gets the sum_select_full_range_join of this MySqlDataSummary.
`sum_select_range`	[Required] Gets the sum_select_range of this MySqlDataSummary.
`sum_select_range_check`	[Required] Gets the sum_select_range_check of this MySqlDataSummary.
`sum_select_scan`	[Required] Gets the sum_select_scan of this MySqlDataSummary.
`sum_sort_merge_passes`	[Required] Gets the sum_sort_merge_passes of this MySqlDataSummary.
`sum_sort_range`	[Required] Gets the sum_sort_range of this MySqlDataSummary.
`sum_sort_rows`	[Required] Gets the sum_sort_rows of this MySqlDataSummary.
`sum_sort_scan`	[Required] Gets the sum_sort_scan of this MySqlDataSummary.
`sum_timer_wait`	[Required] Gets the sum_timer_wait of this MySqlDataSummary.
`sum_warnings`	[Required] Gets the sum_warnings of this MySqlDataSummary.

__init__(**kwargs)¶

Initializes a new MySqlDataSummary object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

schema_name (str) – The value to assign to the schema_name property of this MySqlDataSummary.
digest (str) – The value to assign to the digest property of this MySqlDataSummary.
digest_text (str) – The value to assign to the digest_text property of this MySqlDataSummary.
count_star (float) – The value to assign to the count_star property of this MySqlDataSummary.
sum_timer_wait (float) – The value to assign to the sum_timer_wait property of this MySqlDataSummary.
min_timer_wait (float) – The value to assign to the min_timer_wait property of this MySqlDataSummary.
avg_timer_wait (float) – The value to assign to the avg_timer_wait property of this MySqlDataSummary.
max_timer_wait (float) – The value to assign to the max_timer_wait property of this MySqlDataSummary.
sum_lock_time (float) – The value to assign to the sum_lock_time property of this MySqlDataSummary.
sum_errors (float) – The value to assign to the sum_errors property of this MySqlDataSummary.
sum_warnings (float) – The value to assign to the sum_warnings property of this MySqlDataSummary.
sum_rows_affected (float) – The value to assign to the sum_rows_affected property of this MySqlDataSummary.
sum_rows_sent (float) – The value to assign to the sum_rows_sent property of this MySqlDataSummary.
sum_rows_examined (float) – The value to assign to the sum_rows_examined property of this MySqlDataSummary.
sum_created_temp_disk_tables (float) – The value to assign to the sum_created_temp_disk_tables property of this MySqlDataSummary.
sum_created_temp_tables (float) – The value to assign to the sum_created_temp_tables property of this MySqlDataSummary.
sum_select_full_join (float) – The value to assign to the sum_select_full_join property of this MySqlDataSummary.
sum_select_full_range_join (float) – The value to assign to the sum_select_full_range_join property of this MySqlDataSummary.
sum_select_range (float) – The value to assign to the sum_select_range property of this MySqlDataSummary.
sum_select_range_check (float) – The value to assign to the sum_select_range_check property of this MySqlDataSummary.
sum_select_scan (float) – The value to assign to the sum_select_scan property of this MySqlDataSummary.
sum_sort_merge_passes (float) – The value to assign to the sum_sort_merge_passes property of this MySqlDataSummary.
sum_sort_range (float) – The value to assign to the sum_sort_range property of this MySqlDataSummary.
sum_sort_rows (float) – The value to assign to the sum_sort_rows property of this MySqlDataSummary.
sum_sort_scan (float) – The value to assign to the sum_sort_scan property of this MySqlDataSummary.
sum_no_index_used (float) – The value to assign to the sum_no_index_used property of this MySqlDataSummary.
sum_no_good_index_used (float) – The value to assign to the sum_no_good_index_used property of this MySqlDataSummary.
first_seen (datetime) – The value to assign to the first_seen property of this MySqlDataSummary.
last_seen (datetime) – The value to assign to the last_seen property of this MySqlDataSummary.
quantile95 (float) – The value to assign to the quantile95 property of this MySqlDataSummary.
quantile99 (float) – The value to assign to the quantile99 property of this MySqlDataSummary.
quantile999 (float) – The value to assign to the quantile999 property of this MySqlDataSummary.
heat_wave_offloaded (float) – The value to assign to the heat_wave_offloaded property of this MySqlDataSummary.
heat_wave_out_of_memory (float) – The value to assign to the heat_wave_out_of_memory property of this MySqlDataSummary.

avg_timer_wait¶

[Required] Gets the avg_timer_wait of this MySqlDataSummary. The average execution time.

Returns:	The avg_timer_wait of this MySqlDataSummary.
Return type:	float

count_star¶

[Required] Gets the count_star of this MySqlDataSummary. The number Of times the query has been executed.

Returns:	The count_star of this MySqlDataSummary.
Return type:	float

digest¶

[Required] Gets the digest of this MySqlDataSummary. The digest information of the normalized query.

Returns:	The digest of this MySqlDataSummary.
Return type:	str

digest_text¶

[Required] Gets the digest_text of this MySqlDataSummary. The normalized query.

Returns:	The digest_text of this MySqlDataSummary.
Return type:	str

first_seen¶

[Required] Gets the first_seen of this MySqlDataSummary. The date and time the query was first seen. If the table is truncated, the first seen value is reset.

Returns:	The first_seen of this MySqlDataSummary.
Return type:	datetime

heat_wave_offloaded¶

Gets the heat_wave_offloaded of this MySqlDataSummary. The number of query executions offloaded to HeatWave.

Returns:	The heat_wave_offloaded of this MySqlDataSummary.
Return type:	float

heat_wave_out_of_memory¶

Gets the heat_wave_out_of_memory of this MySqlDataSummary. The number of query executions with HeatWave out-of-memory errors.

Returns:	The heat_wave_out_of_memory of this MySqlDataSummary.
Return type:	float

last_seen¶

[Required] Gets the last_seen of this MySqlDataSummary. The date and time the query was last seen.

Returns:	The last_seen of this MySqlDataSummary.
Return type:	datetime

max_timer_wait¶

[Required] Gets the max_timer_wait of this MySqlDataSummary. The slowest the query has been executed.

Returns:	The max_timer_wait of this MySqlDataSummary.
Return type:	float

min_timer_wait¶

[Required] Gets the min_timer_wait of this MySqlDataSummary. The fastest the query has been executed.

Returns:	The min_timer_wait of this MySqlDataSummary.
Return type:	float

quantile95¶

[Required] Gets the quantile95 of this MySqlDataSummary. The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.

Returns:	The quantile95 of this MySqlDataSummary.
Return type:	float

quantile99¶

[Required] Gets the quantile99 of this MySqlDataSummary. The 99th percentile of the query latency.

Returns:	The quantile99 of this MySqlDataSummary.
Return type:	float

quantile999¶

[Required] Gets the quantile999 of this MySqlDataSummary. The 99.9th percentile of the query latency.

Returns:	The quantile999 of this MySqlDataSummary.
Return type:	float

schema_name¶

[Required] Gets the schema_name of this MySqlDataSummary. The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.

Returns:	The schema_name of this MySqlDataSummary.
Return type:	str

sum_created_temp_disk_tables¶

[Required] Gets the sum_created_temp_disk_tables of this MySqlDataSummary. The total number of On-Disk internal temporary tables that have been created by the query.

Returns:	The sum_created_temp_disk_tables of this MySqlDataSummary.
Return type:	float

sum_created_temp_tables¶

[Required] Gets the sum_created_temp_tables of this MySqlDataSummary. The total number of internal temporary tables (in memory or on disk), which have been created by the query.

Returns:	The sum_created_temp_tables of this MySqlDataSummary.
Return type:	float

sum_errors¶

[Required] Gets the sum_errors of this MySqlDataSummary. The total number of errors that have been encountered executing the query.

Returns:	The sum_errors of this MySqlDataSummary.
Return type:	float

sum_lock_time¶

[Required] Gets the sum_lock_time of this MySqlDataSummary. The total amount of time that has been spent waiting for table locks.

Returns:	The sum_lock_time of this MySqlDataSummary.
Return type:	float

sum_no_good_index_used¶

[Required] Gets the sum_no_good_index_used of this MySqlDataSummary. The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”

Returns:	The sum_no_good_index_used of this MySqlDataSummary.
Return type:	float

sum_no_index_used¶

[Required] Gets the sum_no_index_used of this MySqlDataSummary. The total number of times no index was used to execute the query.

Returns:	The sum_no_index_used of this MySqlDataSummary.
Return type:	float

sum_rows_affected¶

[Required] Gets the sum_rows_affected of this MySqlDataSummary. The total number of rows that have been modified by the query.

Returns:	The sum_rows_affected of this MySqlDataSummary.
Return type:	float

sum_rows_examined¶

[Required] Gets the sum_rows_examined of this MySqlDataSummary. The total number of rows that have been examined by the query.

Returns:	The sum_rows_examined of this MySqlDataSummary.
Return type:	float

sum_rows_sent¶

[Required] Gets the sum_rows_sent of this MySqlDataSummary. The total number of rows that have been returned (sent) to the client.

Returns:	The sum_rows_sent of this MySqlDataSummary.
Return type:	float

sum_select_full_join¶

[Required] Gets the sum_select_full_join of this MySqlDataSummary. The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.

Returns:	The sum_select_full_join of this MySqlDataSummary.
Return type:	float

sum_select_full_range_join¶

[Required] Gets the sum_select_full_range_join of this MySqlDataSummary. The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.

Returns:	The sum_select_full_range_join of this MySqlDataSummary.
Return type:	float

sum_select_range¶

[Required] Gets the sum_select_range of this MySqlDataSummary. The total number of times the query has used a range search. This is the same as the select_range status variable.

Returns:	The sum_select_range of this MySqlDataSummary.
Return type:	float

sum_select_range_check¶

[Required] Gets the sum_select_range_check of this MySqlDataSummary. The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.

Returns:	The sum_select_range_check of this MySqlDataSummary.
Return type:	float

sum_select_scan¶

[Required] Gets the sum_select_scan of this MySqlDataSummary. The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.

Returns:	The sum_select_scan of this MySqlDataSummary.
Return type:	float

sum_sort_merge_passes¶

[Required] Gets the sum_sort_merge_passes of this MySqlDataSummary. The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.

Returns:	The sum_sort_merge_passes of this MySqlDataSummary.
Return type:	float

sum_sort_range¶

[Required] Gets the sum_sort_range of this MySqlDataSummary. The total number of times a sort was done using ranges. This is the same as the sort_range status variable.

Returns:	The sum_sort_range of this MySqlDataSummary.
Return type:	float

sum_sort_rows¶

[Required] Gets the sum_sort_rows of this MySqlDataSummary. The total number of rows sorted. This is the same as the sort_rowsStatus variable.

Returns:	The sum_sort_rows of this MySqlDataSummary.
Return type:	float

sum_sort_scan¶

[Required] Gets the sum_sort_scan of this MySqlDataSummary. The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.

Returns:	The sum_sort_scan of this MySqlDataSummary.
Return type:	float

sum_timer_wait¶

[Required] Gets the sum_timer_wait of this MySqlDataSummary. The total amount of time that has been spent executing the query.

Returns:	The sum_timer_wait of this MySqlDataSummary.
Return type:	float

sum_warnings¶

[Required] Gets the sum_warnings of this MySqlDataSummary. The total number of warnings that have been encountered executing the query.

Returns:	The sum_warnings of this MySqlDataSummary.
Return type:	float