mysqlbinlog --help #查看mysql的binlog日志文件记录的信息 Usage: mysqlbinlog [options] log-files
思路 Nginx 官方其实给出了如何滚动日志的说明: Rotating Log-files In order to rotate log files, they need to be renamed first
Usage: mysqlbinlog.exe [options] log-files -?, --help Display this help and exit.
TABLE `tmp_proxies_priv` /* generated by server */ 4.MySQL二进制文件读取工具mysqlbinlog 命令格式:mysqlbinlog [参数] log-files
-------------------+ 3 rows in set (0.00 sec) 使用命令mysqlbinlog查看二进制日志内容: 基本语法: mysqlbinlog [options] log-files
restart mysqld具体日志格式详解由于日志是以二进制方式存储的,不能直接读取,需要通过二进制日志查询工具mysqlbinlog来查看,具体语法:mysqlbinlog [options] log-files