宝塔面板如何检查mysql检查数据库_Mysql无法启动的常规检查方法

[client]

#password   = your_password

port        = 3306

socket      = /tmp/mysql.sock

[mysqld]

port        = 3306

socket      = /tmp/mysql.sock

datadir = /www/server/data

skip-external-locking

performance_schema_max_table_instances=400

table_definition_cache=400

table_open_cache = 128

key_buffer_size = 32M

max_allowed_packet = 1M

table_open_cache = 128

sort_buffer_size = 768K

net_buffer_length = 8K

read_buffer_size = 768K

read_rnd_buffer_size = 256K

myisam_sort_buffer_size = 8M

thread_cache_size = 16

query_cache_size = 16M

tmp_table_size = 32M

explicit_defaults_for_timestamp = true

#skip-networking

#skip-name-resolve

max_connections = 500

max_connect_errors = 100

open_files_limit = 65535

sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIO

log-bin=mysql-bin

binlog_format=mixed

server-id   = 1

expire_logs_days = 3

#loose-innodb-trx=0

#loose-innodb-locks=0

#loose-innodb-lock-waits=0

#loose-innodb-cmp=0

#loose-innodb-cmp-per-index=0

#loose-innodb-cmp-per-index-reset=0

#loose-innodb-cmp-reset=0

#loose-innodb-cmpmem=0

#loose-innodb-cmpmem-reset=0

#loose-innodb-buffer-page=0

#loose-innodb-buffer-page-lru=0

#loose-innodb-buffer-pool-stats=0

#loose-innodb-metrics=0

#loose-innodb-ft-default-stopword=0

#loose-innodb-ft-inserted=0

#loose-innodb-ft-deleted=0

#loose-innodb-ft-being-deleted=0

#loose-innodb-ft-config=0

#loose-innodb-ft-index-cache=0

#loose-innodb-ft-index-table=0

#loose-innodb-sys-tables=0

#loose-innodb-sys-tablestats=0

#loose-innodb-sys-indexes=0

#loose-innodb-sys-columns=0

#loose-innodb-sys-fields=0

#loose-innodb-sys-foreign=0

#loose-innodb-sys-foreign-cols=0

default_storage_engine = InnoDB

innodb_data_home_dir = /www/server/data

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /www/server/data

innodb_buffer_pool_size = 128M

innodb_log_file_size = 32M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size = 32M

sort_buffer_size = 768K

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout