Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » repair table returns cryptic message
icon5.gif  repair table returns cryptic message [message #1114] Wed, 18 April 2007 23:33 Go to previous message
mysqlNewDBA
Messages: 4
Registered: April 2007
Junior Member
I have an MyIsam table (> 1.5GB big) that crushes quite often. Repair table or myisamchk -r returns messages similar to the following:

Key 1 - Found wrong stored record at 973620836
Found link that points at 3546642079552990793 (outside data file) at 973620852
Found block with too small length at 973620868; Skipped

what does that mean?


some times i get the error message

Wrong bytesec: 32- 32- 32 at 662630684; Skipped

what does that mean?

server version: 5.0.22-Debian_0ubuntu6.06.2-log
2 dual core amd opteron processors @ 2Ghz
8GB Ram
supports large files
Report message to a moderator
[Message index]

Read Message
Read Message
Read Message
Previous Topic:slow query w/ an inner join
Next Topic:Optimize query with indexes all over the place
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 00:35:08 EDT 2009

Total time taken to generate the page: 0.00891 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.