List:General Discussion« Previous MessageNext Message »
From:Dan Buettner Date:May 10 2007 3:14pm
Subject:Re: Frequently MyISAM TABLE corruption.....Pls help
View as plain text  
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 <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....?
>
> 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/mysql?unsub=1
> >
> >
> >
>
> --
> 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/mysql?unsub=1
>
>

Thread
Frequently MyISAM TABLE corruption.....Pls helpNilnandan9 May
  • Re: Frequently MyISAM TABLE corruption.....Pls helpGerald L. Clark9 May
    • Re: Frequently MyISAM TABLE corruption.....Pls helpNilnandan10 May
      • Re: Frequently MyISAM TABLE corruption.....Pls helpDan Buettner10 May
      • Re: Frequently MyISAM TABLE corruption.....Pls helpNilnandan2 Jul
  • Re: Frequently MyISAM TABLE corruption.....Pls helpViSolve DB Team2 Jul