[b]Binary Logs[/b]
MYCNF="/etc/my.cnf"
BINLOG=`grep log-bin ${MYCNF} | cut -d'=' -f2`
echo ${BINLOG}
DIR=`dirname${BINLOG}`
cd ${DIR}
ls -lh *
cat *.index
/opt/mysql/binlog/mysql-bin
[b]Binary Log Analysis[/b]
[quote]The mysqlbinlog utility is the recommended tool for reading binary logs[/quote]
mysqlbinlog `pwd` /mysql-bin.000001
[quote]It is possible to record the slow query infomation into the mysql.slow_log table useing the log_format configuration option.This can be of benefit if enable for a few seconds to record all SQL statements, which then can be mined for additional information, including the read/write ratio and breaddown on per-table basis.[/quote]
stat mysql-bin.000001
[quote]stat looks like a ls -l output[/quote]
The information about the binary log in MySQL can be found with the SHOW MASTER STATUS command:
mysql -uroot -p -e "SHOW MASTER STATUS\g"
the binary log names follow a base_name.nnnnnn convention, where nnnnnn represents a sequential file number. This number is increamented when the individual binary log raches the size as specified by max_binlog_size, the server is restarted, or the FLUSH [BINARY] LOGS statement is issued
[url]http://ronaldbradford.com/blog/mysql-dml-stats-per-table-2009-09-09/[/url]
MYCNF="/etc/my.cnf"
BINLOG=`grep log-bin ${MYCNF} | cut -d'=' -f2`
echo ${BINLOG}
DIR=`dirname${BINLOG}`
cd ${DIR}
ls -lh *
cat *.index
/opt/mysql/binlog/mysql-bin
[b]Binary Log Analysis[/b]
[quote]The mysqlbinlog utility is the recommended tool for reading binary logs[/quote]
mysqlbinlog `pwd` /mysql-bin.000001
[quote]It is possible to record the slow query infomation into the mysql.slow_log table useing the log_format configuration option.This can be of benefit if enable for a few seconds to record all SQL statements, which then can be mined for additional information, including the read/write ratio and breaddown on per-table basis.[/quote]
stat mysql-bin.000001
[quote]stat looks like a ls -l output[/quote]
The information about the binary log in MySQL can be found with the SHOW MASTER STATUS command:
mysql -uroot -p -e "SHOW MASTER STATUS\g"
the binary log names follow a base_name.nnnnnn convention, where nnnnnn represents a sequential file number. This number is increamented when the individual binary log raches the size as specified by max_binlog_size, the server is restarted, or the FLUSH [BINARY] LOGS statement is issued
[url]http://ronaldbradford.com/blog/mysql-dml-stats-per-table-2009-09-09/[/url]