Some additional resources for fixing corrupt MyISAM tables: http://dev.mysql.com/doc/refman/5.0/en/myisam-table-problems.html http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html http://dev.mysql.com/doc/refman/5.0/en/table-maintenance.html , especially: http://dev.mysql.com/doc/refman/5.0/en/repair.html
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, Dan On 5/10/07, Nilnandan <[EMAIL PROTECTED]> 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....? 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]
