MySQL configure and command

[mysqld]
max_connections=2000
max_connect_errors=65535
connect_timeout=20
skip-name-resolve

SHOW VARIABLES LIKE '%max%'
mysqladmin flush-hosts

Repair Tables
mysqlcheck --all-databases
mysqlcheck --repair --all-databases
mysql> REPAIR TABLE table1;

發佈留言

*