mysql查看mylog命令,myisamlog命令

看Understanding MySQL Internals的Configuration

Variables一章时，看到一个log-isam参数，这个参数用来查看myisam的工作过程。

myisamlog处理MyISAM日志文件内容。

象这样调用myisamlog：

shell> myisamlog

[options] [logfile-name [tbl_name]

...]

常用操作是更新(-u)。如果恢复完成(-r)，所有写和可能的更新以及删除操作完成并且只统计错误。如果没有给出日志文件名，使用myisam.log作为日志文件名。如果在命令行中指定了表名，只更新那些指定的表。

myisamlog理解下面的选项：

-?，-I

显示一个帮助消息并退出。

-c N

只执行N个命令。

-f N

指定打开文件的最大数目。

-F filepath/

TODO

-i

退出之前显示详细信息。

-o offset

指定起始偏移量。

-p N

从路径中移除N个组件。

-r

恢复。

-R record-pos-file record-pos

指定记录位置文件和记录位置。

-u

更新。

-v

Verbose模式。产生更多输出。该选项可以多次使用以便产生越来越多的输出。

-w write-file

指定写文件。

-V

显示版本信息。

/usr/local/mysql/bin/myisamlog -iv isam.log

./mysql/host: open -> 7

./mysql/host: extra(13) -> 0

./mysql/host: extra(12) -> 0

./mysql/host: extra(5) -> 0

./mysql/user: open -> 9

./mysql/user: extra(13) -> 0

./mysql/user: extra(12) -> 0

./mysql/user: extra(5) -> 0

./mysql/db: open -> 11

./mysql/db: extra(13) -> 0

./mysql/db: extra(12) -> 0

./mysql/db: extra(5) -> 0

./mysql/host: extra(3) -> 0

./mysql/host: extra(4) -> 0

./mysql/user: extra(3) -> 0

./mysql/user: extra(4) -> 0

./mysql/db: extra(3) -> 0

./mysql/db: extra(4) -> 0

./mysql/db: extra(2) -> 0

./mysql/user: extra(2) -> 0

./mysql/host: extra(2) -> 0

./mysql/time_zone_leap_second: open -> 13

./mysql/time_zone_leap_second: extra(13) -> 0

./mysql/time_zone_leap_second: extra(12) -> 0

./mysql/time_zone_leap_second: extra(5) -> 0

./mysql/time_zone_name: open -> 15

./mysql/time_zone_name: extra(13) -> 0

./mysql/time_zone_name: extra(12) -> 0

./mysql/time_zone_name: extra(5) -> 0

./mysql/time_zone: open -> 17

./mysql/time_zone: extra(13) -> 0

./mysql/time_zone: extra(12) -> 0

./mysql/time_zone: extra(5) -> 0

./mysql/time_zone_transition_type: open -> 19

./mysql/time_zone_transition_type: extra(13) ->

0

./mysql/time_zone_transition_type: extra(12) ->

0

./mysql/time_zone_transition_type: extra(5) ->

0

./mysql/time_zone_transition: open -> 21

./mysql/time_zone_transition: extra(13) -> 0

./mysql/time_zone_transition: extra(12) -> 0

./mysql/time_zone_transition: extra(5) -> 0

./mysql/time_zone_transition: close -> 0

./mysql/time_zone_transition_type: close -> 0

./mysql/time_zone: close -> 0

./mysql/time_zone_name: close -> 0

./mysql/time_zone_leap_second: close -> 0

./mysql/tables_priv: open -> 13

./mysql/tables_priv: extra(13) -> 0

./mysql/tables_priv: extra(12) -> 0

./mysql/tables_priv: extra(5) -> 0

./mysql/columns_priv: open -> 15

./mysql/columns_priv: extra(13) -> 0

./mysql/columns_priv: extra(12) -> 0

./mysql/columns_priv: extra(5) -> 0

/tmp/#sql_47e_0: write at 30848, length=1585 ->

0

/tmp/#sql_47e_0: write at 32332, length=1585 ->

0

/tmp/#sql_47e_0: write at 33816, length=1585 ->

0

/tmp/#sql_47e_0: write at 35300, length=1585 ->

0

/tmp/#sql_47e_0: write at 36784, length=1585 ->

0

/tmp/#sql_47e_0: write at 38268, length=1586 ->

0

/tmp/#sql_47e_0: write at 39752, length=1586 ->

0

/tmp/#sql_47e_0: write at 41236, length=1585 ->

0

/tmp/#sql_47e_0: write at 42720, length=1585 ->

0

/tmp/#sql_47e_0: write at 44204, length=1585 ->

0

/tmp/#sql_47e_0: write at 45688, length=1654 ->

0

Commands Used

count Errors Recover errors

open 333 0 0

write 19417 95 0

update 1209 0 0

delete 20 0 0

close 333 0 0

extra 51961 0 0

Total 73273 95 0

User time 0.06, System time 0.08

Maximum resident set size 0, Integral resident set size 0

Non-physical pagefaults 575, Physical pagefaults 0, Swaps 0

Blocks in 0 out 0, Messages in 0 out 0, Signals 0

Voluntary context switches 784, Involuntary context switches

107