> Hello all,
> I have one server which has mysql 5.0.27 installed. There is one table named
> 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 but i
> Pls help me ASAP. I have used CHECK and REPAIR option I have given here the
> 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