1.两者的区别:
The ib_logfile's hold statements affecting innodb tables only. If a crash occurs they are automatically used to complete any innodb transactions that didn't complete before the crash.
The bin logs record all statements that update data, regardless of engine. They are useful when you have to restore a backup and then roll forward to particular point in time and also to review what statements have been run.
iblogfile is temporary, only live till the data is updated into the tablespace, after which the space is reused.
binary log is more or a permanent and you have to purge the old logs yourself when it is not requried anymore.
2.如何查看两者的内容
使用下面的命令查看binlog里的内容
$ mysqlbinlog mysql-bin.<logfile-number>
注意:mysqlbinlog位于mysql的bin目录下,如果你的my.cnf的配置里面有:
[client]
default-character-set=utf8
执行时报unknown variable 'default-character-set=utf8'错误,这时可以改成:
[client]
loose-character-set = utf8
使用宽泛的设置,参见:http://blog.csdn.net/fafa211/article/details/2361066
使用下面的命令查看ib_logfile里的内容
$ strings ib_logfile<file-no.>
- 大小: 9.1 KB
- 大小: 42.6 KB
分享到:
相关推荐
pls_interger 和binary_integer的区别与多种数据类型说明
wgetwin-1_5_3_1-binary,包含可用实例,已经实际测试过
sersync工作原理:由inotify服务监控目录,当目录/文件发生变化时触发rsync服务进行推送,完成数据同步。
Binary image producer. Code is in C language. Binary thresholding is made.
indicator binary options sniper jr
1、sersync是基于Inotify开发的,类似于Inotify-tools的工具 2、sersync可以记录下被监听目录中发生变化的(包括增加、删除、修改)具体某一个文件或某一个目录的名字,然后使用rsync同步的时候,只同步发生变化的...
Convert Motorola & Intel Hex file to Binary file
linux文件实时同步; 与rsync组合使用,构成linux文件实时同步常用方案
sgn-master_TheGiven_binary_源码
详细说明了利用C++进行二进制文件读写的操作,适合初级学员进行借鉴。
在Linux中使用命令行方式的下载工具wget,在windows中也可以使用,直接用wget命令: ...具体参数可以用wget --help 查看 很强大的命令行下载工具,在单位做自动部署应用程序脚本时就用到它了。拿出来跟大家分享。
excelent indicator for binary option 85 winn
binary genetic algorithm
sersync2.5.4_64bit_binary_stable_final.tar.gz安装包 本安装包压缩为zip文件 使用unzip解压之后就是正常的tar.gz文件
2021_Semantic-aware Binary Code Representation with BERT PPT.pdf
信息安全_数据安全_cwe_checker:Hunting Binary Code 安全可信 安全设计 数字取证 云安全 安全风险
this code for creat binary image from threshold function in openCV library
help for convert float number to binary num
Produce an IBM (ideal binary mask) processed mixture. The first variable is required. When the second variable is not provided the function returns an all-one masked signal.
Both HTTP and FTP retrievals can be time-stamped, thus Wget can see if the remote file has changed since last retrieval and automatically retrieve the new version if it has. Wget supports proxy ...