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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
