mysql

type Base struct {
	HostAndPort string
	Retries     int
}

type DumpSlow struct {
	Count     int
	User      string
	Time      string
	Lock      string
	Rows      float64
	Statement string
}

type InformationSchemaTables struct {
	Catalog              string        `db:"TABLE_CATALOG"`
	Schema               string        `db:"TABLE_SCHEMA"`
	Name                 string        `db:"TABLE_NAME"`
	Engine               string        `db:"ENGINE"`
	Version              int           `db:"VERSION"`
	RowFormat            string        `db:"ROW_FORMAT"`
	Rows                 uint64        `db:"TABLE_ROWS"`
	AvgRowLength         uint64        `db:"AVG_ROW_LENGTH"`
	DataLength           uint64        `db:"DATA_LENGTH"`
	MaxDataLength        uint64        `db:"MAX_DATA_LENGTH"`
	IndexLength          uint64        `db:"INDEX_LENGTH"`
	DataFree             uint64        `db:"DATA_FREE"`
	AutoIncrement        sql.NullInt64 `db:"AUTO_INCREMENT"`
	TableCollation       string        `db:"TABLE_COLLATION"`
	DataAndIndexLength   uint64
	DataAndIndexLengthMB float64
	DataAndIndexLengthGB float64
}

type MysqlDumpSlow struct {
	Data     map[string][]DumpSlow
	Options  string
	FilePath string
}

type MysqlInformationSchemaTables struct {
	Data map[string][]InformationSchemaTables
	Base
}

type MysqlProcesslist struct {
	Data map[string][]Processlist
	Base
}

type Processlist struct {
	Id           int            `db:"Id"`
	User         string         `db:"User"`
	Host         string         `db:"Host"`
	Db           sql.NullString `db:"db"`
	Command      string         `db:"Command"`
	Time         int            `db:"Time"`
	State        string         `db:"State"`
	Info         string         `db:"Info"`
	RowsSent     int            `db:"Rows_sent"`
	RowsExamined int            `db:"Rows_examined"`
}