blog迁移
本blog已迁移至http://www.noodba.com/,本blog不再更新。谢谢大家关注
linux io tools
linux 下我们可以通过iostat 从整体上来观察io的情况,但是这个不能跟踪到某个process。iotop是一个类似top的检测process IO 的Python 项目,如果有兴趣,大家可以研究一下。但是对于那种多线程的应用,如my...
Mysql Binary Log (3)
Binlog file structure All events have a common general structure consisting of an event header followed by event data:+===================+| event header |+===================...
Mysql Binary Log (2)
如果binlog_format是为ROW的,可以用--base64-output=DECODE-ROWS参数。(--verbose,-v Reconstruct row events and display them ascommented SQL statements. If this option is given twice...
Mysql Binary Log (1)
查看log:mysql> showbinary logs;+------------------+-----------+| Log_name | File_size |+------------------+-----------+| m...