mysql 查詢 分別,查看mysql數(shù)據(jù)庫(kù)是否有訪問(wèn)?
1.首先確認(rèn)你日志是否啟用了MySQL>showvariableslike'log_bin';
2.如果啟用了,即ON那日志文件就在MySQL的安裝目錄的data目錄下
3.怎樣知道當(dāng)前的日志MySQL>showmasterstatus;
4.看二進(jìn)制日志文件用MySQLbinlog shell>MySQLbinlogmail-bin.000001
或者shell>MySQLbinlogmail-bin.000001|tail