頻繁查詢 mysql,查看mysql數據庫是否有訪問?
1.首先確認你日志是否啟用了MySQL>showvariableslike'log_bin';
2.如果啟用了,即ON那日志文件就在MySQL的安裝目錄的data目錄下
3.怎樣知道當前的日志MySQL>showmasterstatus;
4.看二進制日志文件用MySQLbinlog shell>MySQLbinlogmail-bin.000001
或者shell>MySQLbinlogmail-bin.000001|tail
1.首先確認你日志是否啟用了MySQL>showvariableslike'log_bin';
2.如果啟用了,即ON那日志文件就在MySQL的安裝目錄的data目錄下
3.怎樣知道當前的日志MySQL>showmasterstatus;
4.看二進制日志文件用MySQLbinlog shell>MySQLbinlogmail-bin.000001
或者shell>MySQLbinlogmail-bin.000001|tail