query

Documentation

Index

• func GetByDBID(c *gin.Context)
• func GetByHostInfo(c *gin.Context)
• func GetByMySQLClusterID(c *gin.Context)
• func GetByMySQLServerID(c *gin.Context)
• func GetBySQLID(c *gin.Context)

Functions

func GetByDBID

func GetByDBID(c *gin.Context)

@Tags query @Summary get slow queries by db id @Accept application/json @Param token body string true "token" @Param db_id body int true "db id" @Param start_time body string true "start time" @Param end_time body string true "end time" @Param limit body int true "limit" @Param offset body int true "offset" @Param login_name body string true "account name or employee id" @Produce application/json @Success 200 {string} string "{"queries":[{"sql_id":"F9A57DD5A41825CA","fingerprint":"select sleep(?)","example":"select sleep(3)","db_name":"","exec_count":1,"total_exec_time":3,"avg_exec_time":3,"rows_examined_max":0}]}" @Router /api/v1/query/db [post]

func GetByHostInfo

func GetByHostInfo(c *gin.Context)

@Tags query @Summary get slow queries by mysql server host ip and port number @Accept application/json @Param token body string true "token" @Param host_ip body string true "mysql server host ip" @Param port_num body int true "mysql server port number" @Param start_time body string true "start time" @Param end_time body string true "end time" @Param limit body int true "limit" @Param offset body int true "offset" @Param login_name body string true "account name or employee id" @Produce application/json @Success 200 {string} string "{"queries":[{"sql_id":"F9A57DD5A41825CA","fingerprint":"select sleep(?)","example":"select sleep(3)","db_name":"","exec_count":1,"total_exec_time":3,"avg_exec_time":3,"rows_examined_max":0}]}" @Router /api/v1/query/host-info [post]

func GetByMySQLClusterID

func GetByMySQLClusterID(c *gin.Context)

@Tags query @Summary get slow queries by mysql server id @Accept application/json @Param token body string true "token" @Param mysql_cluster_id body int true "mysql cluster id" @Param start_time body string true "start time" @Param end_time body string true "end time" @Param limit body int true "limit" @Param offset body int true "offset" @Param login_name body string true "account name or employee id" @Produce application/json @Success 200 {string} string "{"queries":[{"sql_id":"F9A57DD5A41825CA","fingerprint":"select sleep(?)","example":"select sleep(3)","db_name":"","exec_count":1,"total_exec_time":3,"avg_exec_time":3,"rows_examined_max":0}]}" @Router /api/v1/query/cluster [post]

func GetByMySQLServerID

func GetByMySQLServerID(c *gin.Context)

@Tags query @Summary get slow queries by mysql server id @Accept application/json @Param token body string true "token" @Param mysql_server_id body int true "mysql server id" @Param start_time body string true "start time" @Param end_time body string true "end time" @Param limit body int true "limit" @Param offset body int true "offset" @Param login_name body string true "account name or employee id" @Produce application/json @Success 200 {string} string "{"queries":[{"sql_id":"F9A57DD5A41825CA","fingerprint":"select sleep(?)","example":"select sleep(3)","db_name":"","exec_count":1,"total_exec_time":3,"avg_exec_time":3,"rows_examined_max":0}]}" @Router /api/v1/query/server [post]

func GetBySQLID

func GetBySQLID(c *gin.Context)

@Tags query @Summary get slow query by query id @Accept application/json @Param token body string true "token" @Param mysql_server_id body int true "mysql server id" @Param sql_id body string true "sql id" @Param start_time body string true "start time" @Param end_time body string true "end time" @Param limit body int true "limit" @Param offset body int true "offset" @Param login_name body string true "account name or employee id" @Produce application/json @Success 200 {string} string "{"queries":[{"sql_id":"F9A57DD5A41825CA","fingerprint":"select sleep(?)","example":"select sleep(3)","db_name":"","exec_count":1,"total_exec_time":3,"avg_exec_time":3,"rows_examined_max":0}]}" @Router /api/v1/query/sql [post]