Hi all! I also agree with you, it might be a hardware problem, but i also must note, that in a environment with very often writes to the db, myisam tables are not always the best choice, that's why i suggested a change to InnoDB tables, a problem with sql or logic is more likely to happen that a hardware glitch
Just my two cents here :) On Thu, 2003-12-18 at 07:51, Thomas Spahni wrote: > 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 > > -- ...................................................................... * _ _ ______ _____ _ .. * \ \ \ | ____| __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * > > > | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | |____| | / ____ \|_| || www.superferreteria.com.ve * /_/_/ |______|_| /_/ \_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice ...................................................................... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]