List:General Discussion« Previous MessageNext Message »
From:Thomas Spahni Date:December 18 2003 11:51am
Subject:Re: Sporadic myisam table corruption.
View as plain text  
Hi,

either this should be properly debugged (if the problem persists with
4.0.17) or it is a hardware glitch. MyIsam tables have proven quite stable
anch changing to InnoDB might be looking for trouble (if hardware is the
culprit). But it's true that InnoDB could be much more efficient in your
environment.

Thomas Spahni


On Fri, 12 Dec 2003, Victor Medina wrote:

> Change myisam format to something else, like InoDB or BDB
>
> Best Regards!
>
> On Fri, 2003-12-12 at 15:05, James E Hicks III wrote:
> > I'm having sporadic myisam table corruption. This table is constantly being
> > added to, updated, and deleted from. PHPMyAdmin reports that "The table is in
> > use" when I try to access this table after corruption.  After I perform this
> > step in the correct directory everything goes back to normal.
> >
> > myisamchk --recover troubled_table
> >
> > After reading the mysql manual page I changed all the VARCHAR fields to CHAR
> > fields, hoping my problem would dissapear. This change has had no effect on
> > my problem. The only things in the error log are start ups and shutdowns
> > performed nightly.
> >
> > Here's the table definition.
> >
> > CREATE TABLE troubled_table (
> >   office smallint(4) unsigned NOT NULL default '0',
> >   ticket_id char(30) NOT NULL default '',
> >   item_quantity mediumint(8) unsigned NOT NULL default '0',
> >   from_face char(30) NOT NULL default '',
> >   from_down decimal(6,1) unsigned NOT NULL default '0.0',
> >   from_up decimal(6,1) unsigned NOT NULL default '0.0',
> >   from_depth decimal(6,1) unsigned NOT NULL default '0.0',
> >   to_face char(30) NOT NULL default '',
> >   to_down decimal(6,1) unsigned NOT NULL default '0.0',
> >   to_up decimal(6,1) unsigned NOT NULL default '0.0',
> >   to_depth decimal(6,1) unsigned NOT NULL default '0.0',
> >   associated_document char(30) NOT NULL default '',
> >   PRIMARY KEY  (office,ticket_id),
> >   KEY move_id (ticket_id)
> > ) TYPE=MyISAM COMMENT='Material Move Orders';
> >
> > mysql --version says:
> >
> > mysql  Ver 12.20 Distrib 4.0.13, for pc-linux-gnu (i686)
> >
> > What can I try now?
> >
> > James Hicks
>

Thread
Sporadic myisam table corruption.James E Hicks III12 Dec
  • Re: Sporadic myisam table corruption.Victor Medina12 Dec
    • Re: Sporadic myisam table corruption.Thomas Spahni18 Dec
      • Re: Sporadic myisam table corruption.Victor Medina18 Dec
        • Re: Sporadic myisam table corruption.Arne K. Haaje18 Dec