mysql

package
v3.2.6 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Jul 3, 2026 License: BSD-3-Clause Imports: 17 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type App

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

func NewApp

func NewApp(t *gotext.Locale, setting biz.SettingRepo, databaseServer biz.DatabaseServerRepo) *App

func (*App) GetConfig

func (s *App) GetConfig(w http.ResponseWriter, r *http.Request)

GetConfig 获取配置

func (*App) GetConfigTune

func (s *App) GetConfigTune(w http.ResponseWriter, r *http.Request)

GetConfigTune 获取 MySQL 配置调整参数

func (*App) GetRootPassword

func (s *App) GetRootPassword(w http.ResponseWriter, r *http.Request)

GetRootPassword 获取root密码

func (*App) Load

func (s *App) Load(w http.ResponseWriter, r *http.Request)

Load 获取负载

func (*App) Route

func (s *App) Route(r chi.Router)

func (*App) SetRootPassword

func (s *App) SetRootPassword(w http.ResponseWriter, r *http.Request)

SetRootPassword 设置root密码

func (*App) SlowLog

func (s *App) SlowLog(w http.ResponseWriter, r *http.Request)

SlowLog 获取慢查询日志

func (*App) Status added in v3.2.2

func (s *App) Status() string

func (*App) UpdateConfig

func (s *App) UpdateConfig(w http.ResponseWriter, r *http.Request)

UpdateConfig 保存配置

func (*App) UpdateConfigTune

func (s *App) UpdateConfigTune(w http.ResponseWriter, r *http.Request)

UpdateConfigTune 更新 MySQL 配置调整参数

type ConfigTune

type ConfigTune struct {
	// 常规设置
	Port                 string `form:"port" json:"port" validate:"number && min:1 && max:65535"`
	MaxConnections       string `form:"max_connections" json:"max_connections"`
	MaxConnectErrors     string `form:"max_connect_errors" json:"max_connect_errors"`
	DefaultStorageEngine string `form:"default_storage_engine" json:"default_storage_engine"`
	TableOpenCache       string `form:"table_open_cache" json:"table_open_cache"`
	MaxAllowedPacket     string `form:"max_allowed_packet" json:"max_allowed_packet"`
	OpenFilesLimit       string `form:"open_files_limit" json:"open_files_limit"`
	// 性能调整
	KeyBufferSize        string `form:"key_buffer_size" json:"key_buffer_size"`
	SortBufferSize       string `form:"sort_buffer_size" json:"sort_buffer_size"`
	ReadBufferSize       string `form:"read_buffer_size" json:"read_buffer_size"`
	ReadRndBufferSize    string `form:"read_rnd_buffer_size" json:"read_rnd_buffer_size"`
	JoinBufferSize       string `form:"join_buffer_size" json:"join_buffer_size"`
	ThreadCacheSize      string `form:"thread_cache_size" json:"thread_cache_size"`
	ThreadStack          string `form:"thread_stack" json:"thread_stack"`
	TmpTableSize         string `form:"tmp_table_size" json:"tmp_table_size"`
	MaxHeapTableSize     string `form:"max_heap_table_size" json:"max_heap_table_size"`
	MyisamSortBufferSize string `form:"myisam_sort_buffer_size" json:"myisam_sort_buffer_size"`
	// InnoDB
	InnodbBufferPoolSize      string `form:"innodb_buffer_pool_size" json:"innodb_buffer_pool_size"`
	InnodbLogBufferSize       string `form:"innodb_log_buffer_size" json:"innodb_log_buffer_size"`
	InnodbFlushLogAtTrxCommit string `form:"innodb_flush_log_at_trx_commit" json:"innodb_flush_log_at_trx_commit" validate:"in:0,1,2"`
	InnodbLockWaitTimeout     string `form:"innodb_lock_wait_timeout" json:"innodb_lock_wait_timeout"`
	InnodbMaxDirtyPagesPct    string `form:"innodb_max_dirty_pages_pct" json:"innodb_max_dirty_pages_pct"`
	InnodbReadIoThreads       string `form:"innodb_read_io_threads" json:"innodb_read_io_threads"`
	InnodbWriteIoThreads      string `form:"innodb_write_io_threads" json:"innodb_write_io_threads"`
	// 日志
	SlowQueryLog  string `form:"slow_query_log" json:"slow_query_log"`
	LongQueryTime string `form:"long_query_time" json:"long_query_time"`
}

ConfigTune MySQL 配置调整

type SetRootPassword

type SetRootPassword struct {
	Password string `form:"password" json:"password" validate:"required && password"`
}

type UpdateConfig

type UpdateConfig struct {
	Config string `form:"config" json:"config" validate:"required"`
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL