help !
日志中出现的(红色字体),对象损坏指的是什么??11:53:39Maximum server connections 816
11:53:39Checkpoint Statistics - Avg. Txn Block Time 0.025, # Txns blocked 6, Plog used 43263, Llog used 34982
11:58:49Checkpoint Completed:duration was 9 seconds.
11:58:49Fri Jul 23 - loguniq 21395, logpos 0x1670c630, timestamp: 0xb546d33b Interval: 20836
11:58:49Maximum server connections 816
11:58:49Checkpoint Statistics - Avg. Txn Block Time 0.004, # Txns blocked 4, Plog used 35908, Llog used 25064
12:00:22Logical Log 21395 Complete, timestamp: 0xb549de19.
12:00:22Logical Log 21394 - Backup Started
12:02:37Logical Log 21394 - Backup Completed
12:02:37Logical Log 21395 - Backup Started
12:02:45Logical Log 21395 - Backup Completed
12:03:58Checkpoint Completed:duration was 9 seconds.
12:03:58Fri Jul 23 - loguniq 21396, logpos 0x42297b8, timestamp: 0xb550dd36 Interval: 20837
12:03:58Maximum server connections 816
12:03:58Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 1, Plog used 35710, Llog used 25892
12:03:58Some objects had damaged,please run oncheck to check status
12:09:02Checkpoint Completed:duration was 5 seconds.
12:09:02Fri Jul 23 - loguniq 21396, logpos 0x996e4c0, timestamp: 0xb55a0149 Interval: 20838
12:09:02Maximum server connections 816
12:09:02Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 2, Plog used 25311, Llog used 22963
12:14:10Checkpoint Completed:duration was 8 seconds.
12:14:10Fri Jul 23 - loguniq 21396, logpos 0xf2ff2b8, timestamp: 0xb5630ef0 Interval: 20839 回复 1# yes110
想知道具体问题,所以建议你用oncheck,比如索引oncheck -cI,数据可以用oncheck -cD或一起都可以,不过如果数据量比较大,而且检查过程中锁表,可以指定表一个个检查。遇到小问题可修复的话,oncheck会提示的,index就别修复了,干掉重建吧。 回复yes110
想知道具体问题,所以建议你用oncheck,比如索引oncheck -cI,数据可以用oncheck -c ...
3sane 发表于 2010-07-23 14:24 http://bbs.chinaunix.net/images/common/back.gif
只能用oncheck 一个个检查过去吗?很耗时呀。。:dizzy: oncheck -pr
oncheck -cc
oncheck -cDI
页:
[1]