Some additional resources for fixing corrupt MyISAM tables:
http://dev.mysql.com/doc/refman/5.0/en/table-maintenance.html , especially:
I don't know for sure as it will depend on your data and your indices, but
with 580 MB of data, 122000 records, and 22 indices, I would expect that
your index file should be larger than it is (just 32 MB). I would suggest
that perhaps your index file is corrupt and needs to be rebuilt - look at
the stage 2 and stage 3 procedures mentioned in the repair page (last URL
above). Be sure to make backup copies! Read it and understand it before
you do it!
Best of luck,
On 5/10/07, Nilnandan <nandan_it@stripped> wrote:
> Hello Gerald,
> Data_length Max_data_length Index_length
> 596483288 281474976710655 33758208
> 580 MB is table size and 32MB is index size.....
> The default maximum MyISAM size is 4GB.
> Now, tell me where is an issue....?
> Nilnandan Joshi
> Gerald L. Clark-2 wrote:
> > Nilnandan wrote:
> >> Hello all,
> >> I have one server which has mysql 5.0.27 installed. There is one table
> >> named
> >> table1.
> >> that table has 122000 records..It has 114 fields and 22 indexes.
> >> Now this table always been corrupt. I have try to found the solution
> >> i
> >> couldn't.
> >> Pls help me ASAP. I have used CHECK and REPAIR option I have given here
> >> the
> >> output.....
> >> 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Table 'table1' is marked as
> >> crashed and should be repaired
> >> 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Sort aborted
> >> >
> > How big is the index file? the data file?
> > Has either reached the file size limit of your filesystem,
> > or the default maximum MyISAM size?
> > --
> > Gerald L. Clark
> > Supplier Systems Corporation
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> View this message in context:
> Sent from the MySQL - General mailing list archive at Nabble.com.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1