|
»
« Return to Thread: Frequently MyISAM TABLE corruption.....Pls help
Re: Frequently MyISAM TABLE corruption.....Pls help
by Dan Buettner-2
::
Rate this Message:
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@...> 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=lists@...
> >
> >
> >
>
> --
> 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=drbuettner@...
>
>
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@...> 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=lists@...
> >
> >
> >
>
> --
> 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=drbuettner@...
>
>
« Return to Thread: Frequently MyISAM TABLE corruption.....Pls help
| Free embeddable forum powered by Nabble | Forum Help |
