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;

Comments

No comments yet. Why don’t you start the discussion?

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *

*