摘要：開啟慢查詢值當(dāng)前會(huì)話全局會(huì)話啟動(dòng)到現(xiàn)在啟用時(shí)間查詢次數(shù)添加次數(shù)更新次數(shù)刪除次數(shù)連接次數(shù)慢查詢次數(shù)查詢慢查詢時(shí)間默認(rèn)秒設(shè)置慢查詢時(shí)間數(shù)據(jù)庫備份備份數(shù)據(jù)庫刷新日志沒有數(shù)據(jù)只導(dǎo)出表結(jié)構(gòu)在每個(gè)語句之前增加一個(gè)密碼數(shù)據(jù)庫名

show [session|global] status "值";
session：當(dāng)前會(huì)話
global：全局會(huì)話(Mysql啟動(dòng)到現(xiàn)在)


# Mysql 啟用時(shí)間
MySQL > show status like "uptime";

# 查詢次數(shù)
MySQL > show status like "com_select";

# 添加次數(shù)
MySQL > show status like "com_insert";

# 更新次數(shù)
MySQL > show status like "com_delete";

# 刪除次數(shù)
MySQL > show status like "com_delete";

# 連接次數(shù)
MySQL > show status like "connections";

# 慢查詢次數(shù)
MySQL > show status like "slow_queries";

# 查詢慢查詢時(shí)間（默認(rèn)10秒）
MySQL > show variables like "long_query_tiem";

# 設(shè)置慢查詢時(shí)間
MySQL > set long_query_time=1;

# 備份數(shù)據(jù)庫
# -l
# -F 刷新bin-log日志
# -d 沒有數(shù)據(jù),只導(dǎo)出表結(jié)構(gòu)
# --add-drop-table 在每個(gè)create語句之前增加一個(gè)drop table
/usr/local/mysql/bin/mysqldump -h127.0.0.1 -uroot -p密碼 數(shù)據(jù)庫名 -l -F > /data/ceshi.sql
/usr/local/mysql/bin/mysqldump -h127.0.0.1 -uroot -p密碼 -d --add-drop-table 數(shù)據(jù)庫名 > /data/ceshi.sql

# 導(dǎo)入數(shù)據(jù)庫
# -v 查看導(dǎo)入詳細(xì)信息
# -f 遇到錯(cuò)誤直接跳過，繼續(xù)執(zhí)行
/usr/local/mysql/bin/mysql -h127.0.0.1 -uroot -pwoshishui ceshi -v -f  flush logs;

# 查看bin-log日志
MySQL > show master status;