2006年8月21日月曜日

Blogエントリー消滅かと


一瞬、DBを完全に壊して、Blogのエントリが全て消えたのかと焦った。



ちょっと調べた。


hacmini:/var/lib/mysql/MT# ls -l|more
合計 141132
-rw-rw---- 1 mysql mysql 65 2005-11-06 16:12 db.opt
-rw-rw---- 1 mysql mysql 460 2006-08-20 18:39 mt_author.MYD
-rw-rw---- 1 mysql mysql 6144 2006-08-20 18:39 mt_author.MYI
-rw-rw---- 1 mysql mysql 9748 2006-07-16 13:41 mt_author.frm
-rw-rw---- 1 mysql mysql 1948 2006-08-20 18:39 mt_blog.MYD
-rw-rw---- 1 mysql mysql 5120 2006-08-20 18:39 mt_blog.MYI
-rw-rw---- 1 mysql mysql 16094 2006-01-16 02:38 mt_blog.frm
-rw-rw---- 1 mysql mysql 4912 2006-08-20 18:39 mt_category.MYD
-rw-rw---- 1 mysql mysql 9216 2006-08-20 18:39 mt_category.MYI
-rw-rw---- 1 mysql mysql 9026 2006-07-16 13:41 mt_category.frm
-rw-rw---- 1 mysql mysql 280704 2006-08-20 18:39 mt_comment.MYD
-rw-rw---- 1 mysql mysql 84992 2006-08-20 18:39 mt_comment.MYI
-rw-rw---- 1 mysql mysql 9386 2006-01-16 02:38 mt_comment.frm
-rw-rw---- 1 mysql mysql 108 2006-08-20 18:39 mt_config.MYD
-rw-rw---- 1 mysql mysql 2048 2006-08-20 18:39 mt_config.MYI
-rw-rw---- 1 mysql mysql 8602 2006-01-16 02:38 mt_config.frm
-rw-rw---- 1 mysql mysql 67107624 2006-08-20 03:25 mt_entry.MYD
-rw-rw---- 1 mysql mysql 2575360 2006-08-20 18:39 mt_entry.MYI
-rw-r----- 1 root root 59179008 2006-08-20 01:05 mt_entry.TMD
-rw-rw---- 1 mysql mysql 9644 2006-01-16 02:38 mt_entry.frm
-rw-rw---- 1 mysql mysql 0 2006-08-20 18:39 mt_fileinfo.MYD
-rw-rw---- 1 mysql mysql 1024 2006-08-20 18:39 mt_fileinfo.MYI
hacmini:/var/lib/mysql/MT#

このmt_entry.TMDってのはなんだっけ?




取り合えず、消してみた。


hacmini:/var/lib/mysql/MT# mv mt_entry.TMD mt_entry.TMD.bak
hacmini:/var/lib/mysql/MT# sync
hacmini:/var/lib/mysql/MT# myisamchk -r *.MYI|more
- recovering (with sort) MyISAM-table 'mt_author.MYI'
Data records: 4
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'mt_blog.MYI'
Data records: 5
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'mt_category.MYI'
Data records: 81
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'mt_comment.MYI'
Data records: 978
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
---------
- recovering (with sort) MyISAM-table 'mt_config.MYI'
Data records: 1
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'mt_entry.MYI'
Data records: 40891
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
---------
- recovering (with sort) MyISAM-table 'mt_fileinfo.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
---------
- recovering (with sort) MyISAM-table 'mt_ipbanlist.MYI'
Data records: 172
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'mt_log.MYI'
Data records: 942
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'mt_notification.MYI'
Data records: 5
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'mt_objecttag.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'mt_permission.MYI'
Data records: 13
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'mt_placement.MYI'
Data records: 40886
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'mt_plugindata.MYI'
Data records: 9
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'mt_session.MYI'
Data records: 57
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'mt_tag.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'mt_tbping.MYI'
Data records: 190
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
---------
- recovering (with sort) MyISAM-table 'mt_template.MYI'
Data records: 113
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'mt_templatemap.MYI'
Data records: 24
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'mt_trackback.MYI'
Data records: 40809
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
hacmini:/var/lib/mysql/MT#



その後、復活。

ファイルのタイムスタンプから推測するに、myisamcheckを中断したときに、tempファイルが中途半端に出来てたみたいだな。

それが悪さをしていたんだろう。


1 件のコメント:

  1. myisamchk というコマンドがあること自体どうなのよ?
    とか言ってたぽすぐれフリークな人がいたことを思い出したw

    返信削除