Class: OCI::DatabaseManagement::Models::MySqlDataSummary

Inherits:
Object
  • Object
show all
Defined in:
lib/oci/database_management/models/my_sql_data_summary.rb

Overview

The SQL performance data record for a specific SQL query.

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(attributes = {}) ⇒ MySqlDataSummary

Initializes the object

Parameters:

  • attributes (Hash) (defaults to: {}) —

    Model attributes in the form of hash

Options Hash (attributes):

  • :schema_name (String) —

    The value to assign to the #schema_name property

  • :digest (String) —

    The value to assign to the #digest property

  • :digest_text (String) —

    The value to assign to the #digest_text property

  • :count_star (Float) —

    The value to assign to the #count_star property

  • :sum_timer_wait (Float) —

    The value to assign to the #sum_timer_wait property

  • :min_timer_wait (Float) —

    The value to assign to the #min_timer_wait property

  • :avg_timer_wait (Float) —

    The value to assign to the #avg_timer_wait property

  • :max_timer_wait (Float) —

    The value to assign to the #max_timer_wait property

  • :max_controlled_memory (Integer) —

    The value to assign to the #max_controlled_memory property

  • :max_total_memory (Integer) —

    The value to assign to the #max_total_memory property

  • :sum_cpu_time (Integer) —

    The value to assign to the #sum_cpu_time property

  • :sum_lock_time (Float) —

    The value to assign to the #sum_lock_time property

  • :sum_errors (Float) —

    The value to assign to the #sum_errors property

  • :sum_warnings (Float) —

    The value to assign to the #sum_warnings property

  • :sum_rows_affected (Float) —

    The value to assign to the #sum_rows_affected property

  • :sum_rows_sent (Float) —

    The value to assign to the #sum_rows_sent property

  • :sum_rows_examined (Float) —

    The value to assign to the #sum_rows_examined property

  • :sum_created_temp_disk_tables (Float) —

    The value to assign to the #sum_created_temp_disk_tables property

  • :sum_created_temp_tables (Float) —

    The value to assign to the #sum_created_temp_tables property

  • :sum_select_full_join (Float) —

    The value to assign to the #sum_select_full_join property

  • :sum_select_full_range_join (Float) —

    The value to assign to the #sum_select_full_range_join property

  • :sum_select_range (Float) —

    The value to assign to the #sum_select_range property

  • :sum_select_range_check (Float) —

    The value to assign to the #sum_select_range_check property

  • :sum_select_scan (Float) —

    The value to assign to the #sum_select_scan property

  • :sum_sort_merge_passes (Float) —

    The value to assign to the #sum_sort_merge_passes property

  • :sum_sort_range (Float) —

    The value to assign to the #sum_sort_range property

  • :sum_sort_rows (Float) —

    The value to assign to the #sum_sort_rows property

  • :sum_sort_scan (Float) —

    The value to assign to the #sum_sort_scan property

  • :sum_no_index_used (Float) —

    The value to assign to the #sum_no_index_used property

  • :sum_no_good_index_used (Float) —

    The value to assign to the #sum_no_good_index_used property

  • :first_seen (DateTime) —

    The value to assign to the #first_seen property

  • :last_seen (DateTime) —

    The value to assign to the #last_seen property

  • :quantile95 (Float) —

    The value to assign to the #quantile95 property

  • :quantile99 (Float) —

    The value to assign to the #quantile99 property

  • :quantile999 (Float) —

    The value to assign to the #quantile999 property

  • :heat_wave_offloaded (Float) —

    The value to assign to the #heat_wave_offloaded property

  • :heat_wave_out_of_memory (Float) —

    The value to assign to the #heat_wave_out_of_memory property



292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 292

def initialize(attributes = {})
  return unless attributes.is_a?(Hash)

  # convert string to symbol for hash key
  attributes = attributes.each_with_object({}) { |(k, v), h| h[k.to_sym] = v }

  self.schema_name = attributes[:'schemaName'] if attributes[:'schemaName']

  raise 'You cannot provide both :schemaName and :schema_name' if attributes.key?(:'schemaName') && attributes.key?(:'schema_name')

  self.schema_name = attributes[:'schema_name'] if attributes[:'schema_name']

  self.digest = attributes[:'digest'] if attributes[:'digest']

  self.digest_text = attributes[:'digestText'] if attributes[:'digestText']

  raise 'You cannot provide both :digestText and :digest_text' if attributes.key?(:'digestText') && attributes.key?(:'digest_text')

  self.digest_text = attributes[:'digest_text'] if attributes[:'digest_text']

  self.count_star = attributes[:'countStar'] if attributes[:'countStar']

  raise 'You cannot provide both :countStar and :count_star' if attributes.key?(:'countStar') && attributes.key?(:'count_star')

  self.count_star = attributes[:'count_star'] if attributes[:'count_star']

  self.sum_timer_wait = attributes[:'sumTimerWait'] if attributes[:'sumTimerWait']

  raise 'You cannot provide both :sumTimerWait and :sum_timer_wait' if attributes.key?(:'sumTimerWait') && attributes.key?(:'sum_timer_wait')

  self.sum_timer_wait = attributes[:'sum_timer_wait'] if attributes[:'sum_timer_wait']

  self.min_timer_wait = attributes[:'minTimerWait'] if attributes[:'minTimerWait']

  raise 'You cannot provide both :minTimerWait and :min_timer_wait' if attributes.key?(:'minTimerWait') && attributes.key?(:'min_timer_wait')

  self.min_timer_wait = attributes[:'min_timer_wait'] if attributes[:'min_timer_wait']

  self.avg_timer_wait = attributes[:'avgTimerWait'] if attributes[:'avgTimerWait']

  raise 'You cannot provide both :avgTimerWait and :avg_timer_wait' if attributes.key?(:'avgTimerWait') && attributes.key?(:'avg_timer_wait')

  self.avg_timer_wait = attributes[:'avg_timer_wait'] if attributes[:'avg_timer_wait']

  self.max_timer_wait = attributes[:'maxTimerWait'] if attributes[:'maxTimerWait']

  raise 'You cannot provide both :maxTimerWait and :max_timer_wait' if attributes.key?(:'maxTimerWait') && attributes.key?(:'max_timer_wait')

  self.max_timer_wait = attributes[:'max_timer_wait'] if attributes[:'max_timer_wait']

  self.max_controlled_memory = attributes[:'maxControlledMemory'] if attributes[:'maxControlledMemory']

  raise 'You cannot provide both :maxControlledMemory and :max_controlled_memory' if attributes.key?(:'maxControlledMemory') && attributes.key?(:'max_controlled_memory')

  self.max_controlled_memory = attributes[:'max_controlled_memory'] if attributes[:'max_controlled_memory']

  self.max_total_memory = attributes[:'maxTotalMemory'] if attributes[:'maxTotalMemory']

  raise 'You cannot provide both :maxTotalMemory and :max_total_memory' if attributes.key?(:'maxTotalMemory') && attributes.key?(:'max_total_memory')

  self.max_total_memory = attributes[:'max_total_memory'] if attributes[:'max_total_memory']

  self.sum_cpu_time = attributes[:'sumCpuTime'] if attributes[:'sumCpuTime']

  raise 'You cannot provide both :sumCpuTime and :sum_cpu_time' if attributes.key?(:'sumCpuTime') && attributes.key?(:'sum_cpu_time')

  self.sum_cpu_time = attributes[:'sum_cpu_time'] if attributes[:'sum_cpu_time']

  self.sum_lock_time = attributes[:'sumLockTime'] if attributes[:'sumLockTime']

  raise 'You cannot provide both :sumLockTime and :sum_lock_time' if attributes.key?(:'sumLockTime') && attributes.key?(:'sum_lock_time')

  self.sum_lock_time = attributes[:'sum_lock_time'] if attributes[:'sum_lock_time']

  self.sum_errors = attributes[:'sumErrors'] if attributes[:'sumErrors']

  raise 'You cannot provide both :sumErrors and :sum_errors' if attributes.key?(:'sumErrors') && attributes.key?(:'sum_errors')

  self.sum_errors = attributes[:'sum_errors'] if attributes[:'sum_errors']

  self.sum_warnings = attributes[:'sumWarnings'] if attributes[:'sumWarnings']

  raise 'You cannot provide both :sumWarnings and :sum_warnings' if attributes.key?(:'sumWarnings') && attributes.key?(:'sum_warnings')

  self.sum_warnings = attributes[:'sum_warnings'] if attributes[:'sum_warnings']

  self.sum_rows_affected = attributes[:'sumRowsAffected'] if attributes[:'sumRowsAffected']

  raise 'You cannot provide both :sumRowsAffected and :sum_rows_affected' if attributes.key?(:'sumRowsAffected') && attributes.key?(:'sum_rows_affected')

  self.sum_rows_affected = attributes[:'sum_rows_affected'] if attributes[:'sum_rows_affected']

  self.sum_rows_sent = attributes[:'sumRowsSent'] if attributes[:'sumRowsSent']

  raise 'You cannot provide both :sumRowsSent and :sum_rows_sent' if attributes.key?(:'sumRowsSent') && attributes.key?(:'sum_rows_sent')

  self.sum_rows_sent = attributes[:'sum_rows_sent'] if attributes[:'sum_rows_sent']

  self.sum_rows_examined = attributes[:'sumRowsExamined'] if attributes[:'sumRowsExamined']

  raise 'You cannot provide both :sumRowsExamined and :sum_rows_examined' if attributes.key?(:'sumRowsExamined') && attributes.key?(:'sum_rows_examined')

  self.sum_rows_examined = attributes[:'sum_rows_examined'] if attributes[:'sum_rows_examined']

  self.sum_created_temp_disk_tables = attributes[:'sumCreatedTempDiskTables'] if attributes[:'sumCreatedTempDiskTables']

  raise 'You cannot provide both :sumCreatedTempDiskTables and :sum_created_temp_disk_tables' if attributes.key?(:'sumCreatedTempDiskTables') && attributes.key?(:'sum_created_temp_disk_tables')

  self.sum_created_temp_disk_tables = attributes[:'sum_created_temp_disk_tables'] if attributes[:'sum_created_temp_disk_tables']

  self.sum_created_temp_tables = attributes[:'sumCreatedTempTables'] if attributes[:'sumCreatedTempTables']

  raise 'You cannot provide both :sumCreatedTempTables and :sum_created_temp_tables' if attributes.key?(:'sumCreatedTempTables') && attributes.key?(:'sum_created_temp_tables')

  self.sum_created_temp_tables = attributes[:'sum_created_temp_tables'] if attributes[:'sum_created_temp_tables']

  self.sum_select_full_join = attributes[:'sumSelectFullJoin'] if attributes[:'sumSelectFullJoin']

  raise 'You cannot provide both :sumSelectFullJoin and :sum_select_full_join' if attributes.key?(:'sumSelectFullJoin') && attributes.key?(:'sum_select_full_join')

  self.sum_select_full_join = attributes[:'sum_select_full_join'] if attributes[:'sum_select_full_join']

  self.sum_select_full_range_join = attributes[:'sumSelectFullRangeJoin'] if attributes[:'sumSelectFullRangeJoin']

  raise 'You cannot provide both :sumSelectFullRangeJoin and :sum_select_full_range_join' if attributes.key?(:'sumSelectFullRangeJoin') && attributes.key?(:'sum_select_full_range_join')

  self.sum_select_full_range_join = attributes[:'sum_select_full_range_join'] if attributes[:'sum_select_full_range_join']

  self.sum_select_range = attributes[:'sumSelectRange'] if attributes[:'sumSelectRange']

  raise 'You cannot provide both :sumSelectRange and :sum_select_range' if attributes.key?(:'sumSelectRange') && attributes.key?(:'sum_select_range')

  self.sum_select_range = attributes[:'sum_select_range'] if attributes[:'sum_select_range']

  self.sum_select_range_check = attributes[:'sumSelectRangeCheck'] if attributes[:'sumSelectRangeCheck']

  raise 'You cannot provide both :sumSelectRangeCheck and :sum_select_range_check' if attributes.key?(:'sumSelectRangeCheck') && attributes.key?(:'sum_select_range_check')

  self.sum_select_range_check = attributes[:'sum_select_range_check'] if attributes[:'sum_select_range_check']

  self.sum_select_scan = attributes[:'sumSelectScan'] if attributes[:'sumSelectScan']

  raise 'You cannot provide both :sumSelectScan and :sum_select_scan' if attributes.key?(:'sumSelectScan') && attributes.key?(:'sum_select_scan')

  self.sum_select_scan = attributes[:'sum_select_scan'] if attributes[:'sum_select_scan']

  self.sum_sort_merge_passes = attributes[:'sumSortMergePasses'] if attributes[:'sumSortMergePasses']

  raise 'You cannot provide both :sumSortMergePasses and :sum_sort_merge_passes' if attributes.key?(:'sumSortMergePasses') && attributes.key?(:'sum_sort_merge_passes')

  self.sum_sort_merge_passes = attributes[:'sum_sort_merge_passes'] if attributes[:'sum_sort_merge_passes']

  self.sum_sort_range = attributes[:'sumSortRange'] if attributes[:'sumSortRange']

  raise 'You cannot provide both :sumSortRange and :sum_sort_range' if attributes.key?(:'sumSortRange') && attributes.key?(:'sum_sort_range')

  self.sum_sort_range = attributes[:'sum_sort_range'] if attributes[:'sum_sort_range']

  self.sum_sort_rows = attributes[:'sumSortRows'] if attributes[:'sumSortRows']

  raise 'You cannot provide both :sumSortRows and :sum_sort_rows' if attributes.key?(:'sumSortRows') && attributes.key?(:'sum_sort_rows')

  self.sum_sort_rows = attributes[:'sum_sort_rows'] if attributes[:'sum_sort_rows']

  self.sum_sort_scan = attributes[:'sumSortScan'] if attributes[:'sumSortScan']

  raise 'You cannot provide both :sumSortScan and :sum_sort_scan' if attributes.key?(:'sumSortScan') && attributes.key?(:'sum_sort_scan')

  self.sum_sort_scan = attributes[:'sum_sort_scan'] if attributes[:'sum_sort_scan']

  self.sum_no_index_used = attributes[:'sumNoIndexUsed'] if attributes[:'sumNoIndexUsed']

  raise 'You cannot provide both :sumNoIndexUsed and :sum_no_index_used' if attributes.key?(:'sumNoIndexUsed') && attributes.key?(:'sum_no_index_used')

  self.sum_no_index_used = attributes[:'sum_no_index_used'] if attributes[:'sum_no_index_used']

  self.sum_no_good_index_used = attributes[:'sumNoGoodIndexUsed'] if attributes[:'sumNoGoodIndexUsed']

  raise 'You cannot provide both :sumNoGoodIndexUsed and :sum_no_good_index_used' if attributes.key?(:'sumNoGoodIndexUsed') && attributes.key?(:'sum_no_good_index_used')

  self.sum_no_good_index_used = attributes[:'sum_no_good_index_used'] if attributes[:'sum_no_good_index_used']

  self.first_seen = attributes[:'firstSeen'] if attributes[:'firstSeen']

  raise 'You cannot provide both :firstSeen and :first_seen' if attributes.key?(:'firstSeen') && attributes.key?(:'first_seen')

  self.first_seen = attributes[:'first_seen'] if attributes[:'first_seen']

  self.last_seen = attributes[:'lastSeen'] if attributes[:'lastSeen']

  raise 'You cannot provide both :lastSeen and :last_seen' if attributes.key?(:'lastSeen') && attributes.key?(:'last_seen')

  self.last_seen = attributes[:'last_seen'] if attributes[:'last_seen']

  self.quantile95 = attributes[:'quantile95'] if attributes[:'quantile95']

  self.quantile99 = attributes[:'quantile99'] if attributes[:'quantile99']

  self.quantile999 = attributes[:'quantile999'] if attributes[:'quantile999']

  self.heat_wave_offloaded = attributes[:'heatWaveOffloaded'] if attributes[:'heatWaveOffloaded']

  raise 'You cannot provide both :heatWaveOffloaded and :heat_wave_offloaded' if attributes.key?(:'heatWaveOffloaded') && attributes.key?(:'heat_wave_offloaded')

  self.heat_wave_offloaded = attributes[:'heat_wave_offloaded'] if attributes[:'heat_wave_offloaded']

  self.heat_wave_out_of_memory = attributes[:'heatWaveOutOfMemory'] if attributes[:'heatWaveOutOfMemory']

  raise 'You cannot provide both :heatWaveOutOfMemory and :heat_wave_out_of_memory' if attributes.key?(:'heatWaveOutOfMemory') && attributes.key?(:'heat_wave_out_of_memory')

  self.heat_wave_out_of_memory = attributes[:'heat_wave_out_of_memory'] if attributes[:'heat_wave_out_of_memory']
end

Instance Attribute Details

#avg_timer_wait ⇒ Float

[Required] The average execution time.

Returns:

  • (Float) 


37
38
39
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 37

def avg_timer_wait
  @avg_timer_wait
end

#count_star ⇒ Float

[Required] The number Of times the query has been executed.

Returns:

  • (Float) 


25
26
27
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 25

def count_star
  @count_star
end

#digest ⇒ String

[Required] The digest information of the normalized query.

Returns:

  • (String) 


17
18
19
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 17

def digest
  @digest
end

#digest_text ⇒ String

[Required] The normalized query.

Returns:

  • (String) 


21
22
23
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 21

def digest_text
  @digest_text
end

#first_seen ⇒ DateTime

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

Returns:

  • (DateTime) 


133
134
135
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 133

def first_seen
  @first_seen
end

#heat_wave_offloaded ⇒ Float

The number of query executions offloaded to HeatWave.

Returns:

  • (Float) 


153
154
155
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 153

def heat_wave_offloaded
  @heat_wave_offloaded
end

#heat_wave_out_of_memory ⇒ Float

The number of query executions with HeatWave out-of-memory errors.

Returns:

  • (Float) 


157
158
159
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 157

def heat_wave_out_of_memory
  @heat_wave_out_of_memory
end

#last_seen ⇒ DateTime

[Required] The date and time the query was last seen.

Returns:

  • (DateTime) 


137
138
139
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 137

def last_seen
  @last_seen
end

#max_controlled_memory ⇒ Integer

The maximum amount of controlled memory used by a statement during execution.

Returns:

  • (Integer) 


45
46
47
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 45

def max_controlled_memory
  @max_controlled_memory
end

#max_timer_wait ⇒ Float

[Required] The slowest the query has been executed.

Returns:

  • (Float) 


41
42
43
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 41

def max_timer_wait
  @max_timer_wait
end

#max_total_memory ⇒ Integer

The maximum amount of memory used by a statement during execution.

Returns:

  • (Integer) 


49
50
51
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 49

def max_total_memory
  @max_total_memory
end

#min_timer_wait ⇒ Float

[Required] The fastest the query has been executed.

Returns:

  • (Float) 


33
34
35
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 33

def min_timer_wait
  @min_timer_wait
end

#quantile95 ⇒ Float

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

Returns:

  • (Float) 


141
142
143
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 141

def quantile95
  @quantile95
end

#quantile99 ⇒ Float

[Required] The 99th percentile of the query latency.

Returns:

  • (Float) 


145
146
147
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 145

def quantile99
  @quantile99
end

#quantile999 ⇒ Float

[Required] The 99.9th percentile of the query latency.

Returns:

  • (Float) 


149
150
151
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 149

def quantile999
  @quantile999
end

#schema_name ⇒ String

[Required] 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:

  • (String) 


13
14
15
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 13

def schema_name
  @schema_name
end

#sum_cpu_time ⇒ Integer

The total amount of time spent on CPU for this statement.

Returns:

  • (Integer) 


53
54
55
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 53

def sum_cpu_time
  @sum_cpu_time
end

#sum_created_temp_disk_tables ⇒ Float

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

Returns:

  • (Float) 


81
82
83
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 81

def sum_created_temp_disk_tables
  @sum_created_temp_disk_tables
end

#sum_created_temp_tables ⇒ Float

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

Returns:

  • (Float) 


85
86
87
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 85

def sum_created_temp_tables
  @sum_created_temp_tables
end

#sum_errors ⇒ Float

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

Returns:

  • (Float) 


61
62
63
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 61

def sum_errors
  @sum_errors
end

#sum_lock_time ⇒ Float

[Required] The total amount of time that has been spent waiting for table locks.

Returns:

  • (Float) 


57
58
59
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 57

def sum_lock_time
  @sum_lock_time
end

#sum_no_good_index_used ⇒ Float

[Required] The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes u201CRange Checked For Each Record.u201D

Returns:

  • (Float) 


129
130
131
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 129

def sum_no_good_index_used
  @sum_no_good_index_used
end

#sum_no_index_used ⇒ Float

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

Returns:

  • (Float) 


125
126
127
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 125

def sum_no_index_used
  @sum_no_index_used
end

#sum_rows_affected ⇒ Float

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

Returns:

  • (Float) 


69
70
71
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 69

def sum_rows_affected
  @sum_rows_affected
end

#sum_rows_examined ⇒ Float

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

Returns:

  • (Float) 


77
78
79
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 77

def sum_rows_examined
  @sum_rows_examined
end

#sum_rows_sent ⇒ Float

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

Returns:

  • (Float) 


73
74
75
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 73

def sum_rows_sent
  @sum_rows_sent
end

#sum_select_full_join ⇒ Float

[Required] 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:

  • (Float) 


89
90
91
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 89

def sum_select_full_join
  @sum_select_full_join
end

#sum_select_full_range_join ⇒ Float

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

Returns:

  • (Float) 


93
94
95
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 93

def sum_select_full_range_join
  @sum_select_full_range_join
end

#sum_select_range ⇒ Float

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

Returns:

  • (Float) 


97
98
99
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 97

def sum_select_range
  @sum_select_range
end

#sum_select_range_check ⇒ Float

[Required] 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:

  • (Float) 


101
102
103
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 101

def sum_select_range_check
  @sum_select_range_check
end

#sum_select_scan ⇒ Float

[Required] 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:

  • (Float) 


105
106
107
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 105

def sum_select_scan
  @sum_select_scan
end

#sum_sort_merge_passes ⇒ Float

[Required] 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:

  • (Float) 


109
110
111
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 109

def sum_sort_merge_passes
  @sum_sort_merge_passes
end

#sum_sort_range ⇒ Float

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

Returns:

  • (Float) 


113
114
115
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 113

def sum_sort_range
  @sum_sort_range
end

#sum_sort_rows ⇒ Float

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

Returns:

  • (Float) 


117
118
119
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 117

def sum_sort_rows
  @sum_sort_rows
end

#sum_sort_scan ⇒ Float

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

Returns:

  • (Float) 


121
122
123
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 121

def sum_sort_scan
  @sum_sort_scan
end

#sum_timer_wait ⇒ Float

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

Returns:

  • (Float) 


29
30
31
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 29

def sum_timer_wait
  @sum_timer_wait
end

#sum_warnings ⇒ Float

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

Returns:

  • (Float) 


65
66
67
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 65

def sum_warnings
  @sum_warnings
end

Class Method Details

.attribute_map ⇒ Object

Attribute mapping from ruby-style variable name to JSON key.



160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 160

def self.attribute_map
  {
    # rubocop:disable Style/SymbolLiteral
    'schema_name': :'schemaName',
    'digest': :'digest',
    'digest_text': :'digestText',
    'count_star': :'countStar',
    'sum_timer_wait': :'sumTimerWait',
    'min_timer_wait': :'minTimerWait',
    'avg_timer_wait': :'avgTimerWait',
    'max_timer_wait': :'maxTimerWait',
    'max_controlled_memory': :'maxControlledMemory',
    'max_total_memory': :'maxTotalMemory',
    'sum_cpu_time': :'sumCpuTime',
    'sum_lock_time': :'sumLockTime',
    'sum_errors': :'sumErrors',
    'sum_warnings': :'sumWarnings',
    'sum_rows_affected': :'sumRowsAffected',
    'sum_rows_sent': :'sumRowsSent',
    'sum_rows_examined': :'sumRowsExamined',
    'sum_created_temp_disk_tables': :'sumCreatedTempDiskTables',
    'sum_created_temp_tables': :'sumCreatedTempTables',
    'sum_select_full_join': :'sumSelectFullJoin',
    'sum_select_full_range_join': :'sumSelectFullRangeJoin',
    'sum_select_range': :'sumSelectRange',
    'sum_select_range_check': :'sumSelectRangeCheck',
    'sum_select_scan': :'sumSelectScan',
    'sum_sort_merge_passes': :'sumSortMergePasses',
    'sum_sort_range': :'sumSortRange',
    'sum_sort_rows': :'sumSortRows',
    'sum_sort_scan': :'sumSortScan',
    'sum_no_index_used': :'sumNoIndexUsed',
    'sum_no_good_index_used': :'sumNoGoodIndexUsed',
    'first_seen': :'firstSeen',
    'last_seen': :'lastSeen',
    'quantile95': :'quantile95',
    'quantile99': :'quantile99',
    'quantile999': :'quantile999',
    'heat_wave_offloaded': :'heatWaveOffloaded',
    'heat_wave_out_of_memory': :'heatWaveOutOfMemory'
    # rubocop:enable Style/SymbolLiteral
  }
end

.swagger_types ⇒ Object

Attribute type mapping.



205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 205

def self.swagger_types
  {
    # rubocop:disable Style/SymbolLiteral
    'schema_name': :'String',
    'digest': :'String',
    'digest_text': :'String',
    'count_star': :'Float',
    'sum_timer_wait': :'Float',
    'min_timer_wait': :'Float',
    'avg_timer_wait': :'Float',
    'max_timer_wait': :'Float',
    'max_controlled_memory': :'Integer',
    'max_total_memory': :'Integer',
    'sum_cpu_time': :'Integer',
    'sum_lock_time': :'Float',
    'sum_errors': :'Float',
    'sum_warnings': :'Float',
    'sum_rows_affected': :'Float',
    'sum_rows_sent': :'Float',
    'sum_rows_examined': :'Float',
    'sum_created_temp_disk_tables': :'Float',
    'sum_created_temp_tables': :'Float',
    'sum_select_full_join': :'Float',
    'sum_select_full_range_join': :'Float',
    'sum_select_range': :'Float',
    'sum_select_range_check': :'Float',
    'sum_select_scan': :'Float',
    'sum_sort_merge_passes': :'Float',
    'sum_sort_range': :'Float',
    'sum_sort_rows': :'Float',
    'sum_sort_scan': :'Float',
    'sum_no_index_used': :'Float',
    'sum_no_good_index_used': :'Float',
    'first_seen': :'DateTime',
    'last_seen': :'DateTime',
    'quantile95': :'Float',
    'quantile99': :'Float',
    'quantile999': :'Float',
    'heat_wave_offloaded': :'Float',
    'heat_wave_out_of_memory': :'Float'
    # rubocop:enable Style/SymbolLiteral
  }
end

Instance Method Details

#==(other) ⇒ Object

Checks equality by comparing each attribute.

Parameters:

  • other (Object) —

    the other object to be compared



512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 512

def ==(other)
  return true if equal?(other)

  self.class == other.class &&
    schema_name == other.schema_name &&
    digest == other.digest &&
    digest_text == other.digest_text &&
    count_star == other.count_star &&
    sum_timer_wait == other.sum_timer_wait &&
    min_timer_wait == other.min_timer_wait &&
    avg_timer_wait == other.avg_timer_wait &&
    max_timer_wait == other.max_timer_wait &&
    max_controlled_memory == other.max_controlled_memory &&
    max_total_memory == other.max_total_memory &&
    sum_cpu_time == other.sum_cpu_time &&
    sum_lock_time == other.sum_lock_time &&
    sum_errors == other.sum_errors &&
    sum_warnings == other.sum_warnings &&
    sum_rows_affected == other.sum_rows_affected &&
    sum_rows_sent == other.sum_rows_sent &&
    sum_rows_examined == other.sum_rows_examined &&
    sum_created_temp_disk_tables == other.sum_created_temp_disk_tables &&
    sum_created_temp_tables == other.sum_created_temp_tables &&
    sum_select_full_join == other.sum_select_full_join &&
    sum_select_full_range_join == other.sum_select_full_range_join &&
    sum_select_range == other.sum_select_range &&
    sum_select_range_check == other.sum_select_range_check &&
    sum_select_scan == other.sum_select_scan &&
    sum_sort_merge_passes == other.sum_sort_merge_passes &&
    sum_sort_range == other.sum_sort_range &&
    sum_sort_rows == other.sum_sort_rows &&
    sum_sort_scan == other.sum_sort_scan &&
    sum_no_index_used == other.sum_no_index_used &&
    sum_no_good_index_used == other.sum_no_good_index_used &&
    first_seen == other.first_seen &&
    last_seen == other.last_seen &&
    quantile95 == other.quantile95 &&
    quantile99 == other.quantile99 &&
    quantile999 == other.quantile999 &&
    heat_wave_offloaded == other.heat_wave_offloaded &&
    heat_wave_out_of_memory == other.heat_wave_out_of_memory
end

#build_from_hash(attributes) ⇒ Object

Builds the object from hash

Parameters:

  • attributes (Hash) —

    Model attributes in the form of hash

Returns:

  • (Object) —

    Returns the model itself



578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 578

def build_from_hash(attributes)
  return nil unless attributes.is_a?(Hash)

  self.class.swagger_types.each_pair do |key, type|
    if type =~ /^Array<(.*)>/i
      # check to ensure the input is an array given that the the attribute
      # is documented as an array but the input is not
      if attributes[self.class.attribute_map[key]].is_a?(Array)
        public_method("#{key}=").call(
          attributes[self.class.attribute_map[key]]
            .map { |v| OCI::Internal::Util.convert_to_type(Regexp.last_match(1), v) }
        )
      end
    elsif !attributes[self.class.attribute_map[key]].nil?
      public_method("#{key}=").call(
        OCI::Internal::Util.convert_to_type(type, attributes[self.class.attribute_map[key]])
      )
    end
    # or else data not found in attributes(hash), not an issue as the data can be optional
  end

  self
end

#eql?(other) ⇒ Boolean

Parameters:

  • other (Object) —

    the other object to be compared

Returns:

  • (Boolean)

See Also:

  • `==` method


558
559
560
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 558

def eql?(other)
  self == other
end

#hash ⇒ Fixnum

Calculates hash code according to all attributes.

Returns:

  • (Fixnum) —

    Hash code



567
568
569
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 567

def hash
  [schema_name, digest, digest_text, count_star, sum_timer_wait, min_timer_wait, avg_timer_wait, max_timer_wait, max_controlled_memory, max_total_memory, sum_cpu_time, sum_lock_time, sum_errors, sum_warnings, sum_rows_affected, sum_rows_sent, sum_rows_examined, sum_created_temp_disk_tables, sum_created_temp_tables, sum_select_full_join, sum_select_full_range_join, sum_select_range, sum_select_range_check, sum_select_scan, sum_sort_merge_passes, sum_sort_range, sum_sort_rows, sum_sort_scan, sum_no_index_used, sum_no_good_index_used, first_seen, last_seen, quantile95, quantile99, quantile999, heat_wave_offloaded, heat_wave_out_of_memory].hash
end

#to_hash ⇒ Hash

Returns the object in the form of hash

Returns:

  • (Hash) —

    Returns the object in the form of hash



611
612
613
614
615
616
617
618
619
620
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 611

def to_hash
  hash = {}
  self.class.attribute_map.each_pair do |attr, param|
    value = public_method(attr).call
    next if value.nil? && !instance_variable_defined?("@#{attr}")

    hash[param] = _to_hash(value)
  end
  hash
end

#to_s ⇒ String

Returns the string representation of the object

Returns:

  • (String) —

    String presentation of the object



605
606
607
 
# File 'lib/oci/database_management/models/my_sql_data_summary.rb', line 605

def to_s
  to_hash.to_s
end