mysql

Documentation

Index

• type Handler
• type MySQLHandler
  • func NewHandler(doer doer) MySQLHandler
  • func (h *MySQLHandler) MySQLServiceQueryStatistics(ctx context.Context, project string, serviceName string, ...) ([]QueryOut, error)
• type MySqlserviceQueryStatisticsIn
• type QueryOut

Types

type Handler

type Handler interface {
	// MySQLServiceQueryStatistics fetch MySQL service query statistics
	// POST /v1/project/{project}/service/{service_name}/mysql/query/stats
	// https://api.aiven.io/doc/#tag/Service:_MySQL/operation/MySQLServiceQueryStatistics
	MySQLServiceQueryStatistics(ctx context.Context, project string, serviceName string, in *MySqlserviceQueryStatisticsIn) ([]QueryOut, error)
}

type MySQLHandler

type MySQLHandler struct {
	// contains filtered or unexported fields
}

func NewHandler

func NewHandler(doer doer) MySQLHandler

func (*MySQLHandler) MySQLServiceQueryStatistics

func (h *MySQLHandler) MySQLServiceQueryStatistics(ctx context.Context, project string, serviceName string, in *MySqlserviceQueryStatisticsIn) ([]QueryOut, error)

type MySqlserviceQueryStatisticsIn

type MySqlserviceQueryStatisticsIn struct {
	Limit   *int    `json:"limit,omitempty"`    // Limit for number of results
	Offset  *int    `json:"offset,omitempty"`   // Offset for retrieved results based on sort order
	OrderBy *string `json:"order_by,omitempty"` // Sort order can be either asc or desc and multiple comma separated columns with their own order can be specified: :asc,:desc. Accepted sort columns are: avg_timer_wait, count_star, digest, digest_text, first_seen, last_seen, max_timer_wait, min_timer_wait, query_sample_seen, query_sample_text, query_sample_timer_wait, quantile_95, quantile_99, quantile_999, schema_name, sum_created_tmp_disk_tables, sum_created_tmp_tables, sum_errors, sum_lock_time, sum_no_good_index_used, sum_no_index_used, sum_rows_affected, sum_rows_examined, sum_rows_sent, 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_timer_wait, sum_warnings
}

MySqlserviceQueryStatisticsIn MySQLServiceQueryStatisticsRequestBody

type QueryOut

type QueryOut struct {
	AvgTimerWait            *float64 `json:"avg_timer_wait,omitempty"`              // Query statistic
	CountStar               *float64 `json:"count_star,omitempty"`                  // Query statistic
	Digest                  *string  `json:"digest,omitempty"`                      // Query statistic
	DigestText              *string  `json:"digest_text,omitempty"`                 // Query statistic
	FirstSeen               *string  `json:"first_seen,omitempty"`                  // Query statistic
	LastSeen                *string  `json:"last_seen,omitempty"`                   // Query statistic
	MaxTimerWait            *float64 `json:"max_timer_wait,omitempty"`              // Query statistic
	MinTimerWait            *float64 `json:"min_timer_wait,omitempty"`              // Query statistic
	Quantile95              *float64 `json:"quantile_95,omitempty"`                 // Query statistic
	Quantile99              *float64 `json:"quantile_99,omitempty"`                 // Query statistic
	Quantile999             *float64 `json:"quantile_999,omitempty"`                // Query statistic
	QuerySampleSeen         *string  `json:"query_sample_seen,omitempty"`           // Query statistic
	QuerySampleText         *string  `json:"query_sample_text,omitempty"`           // Query statistic
	QuerySampleTimerWait    *string  `json:"query_sample_timer_wait,omitempty"`     // Query statistic
	SchemaName              *string  `json:"schema_name,omitempty"`                 // Query statistic
	SumCreatedTmpDiskTables *float64 `json:"sum_created_tmp_disk_tables,omitempty"` // Query statistic
	SumCreatedTmpTables     *float64 `json:"sum_created_tmp_tables,omitempty"`      // Query statistic
	SumErrors               *float64 `json:"sum_errors,omitempty"`                  // Query statistic
	SumLockTime             *float64 `json:"sum_lock_time,omitempty"`               // Query statistic
	SumNoGoodIndexUsed      *float64 `json:"sum_no_good_index_used,omitempty"`      // Query statistic
	SumNoIndexUsed          *float64 `json:"sum_no_index_used,omitempty"`           // Query statistic
	SumRowsAffected         *float64 `json:"sum_rows_affected,omitempty"`           // Query statistic
	SumRowsExamined         *float64 `json:"sum_rows_examined,omitempty"`           // Query statistic
	SumRowsSent             *float64 `json:"sum_rows_sent,omitempty"`               // Query statistic
	SumSelectFullJoin       *float64 `json:"sum_select_full_join,omitempty"`        // Query statistic
	SumSelectFullRangeJoin  *float64 `json:"sum_select_full_range_join,omitempty"`  // Query statistic
	SumSelectRange          *float64 `json:"sum_select_range,omitempty"`            // Query statistic
	SumSelectRangeCheck     *float64 `json:"sum_select_range_check,omitempty"`      // Query statistic
	SumSelectScan           *float64 `json:"sum_select_scan,omitempty"`             // Query statistic
	SumSortMergePasses      *float64 `json:"sum_sort_merge_passes,omitempty"`       // Query statistic
	SumSortRange            *float64 `json:"sum_sort_range,omitempty"`              // Query statistic
	SumSortRows             *float64 `json:"sum_sort_rows,omitempty"`               // Query statistic
	SumSortScan             *float64 `json:"sum_sort_scan,omitempty"`               // Query statistic
	SumTimerWait            *float64 `json:"sum_timer_wait,omitempty"`              // Query statistic
	SumWarnings             *float64 `json:"sum_warnings,omitempty"`                // Query statistic
}