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....? regards, Nilnandan Joshi DBA-SDU Juriscape 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 but >> 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/[EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Frequently-MyISAM-TABLE-corruption.....Pls-help-tf3715472.html#a10412877 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/[EMAIL PROTECTED]