Redhat 7.3 Kernel linux-2.4.18-3
Rgds Terence ----- Original Message ----- From: "Richard Gabriel" <[EMAIL PROTECTED]> To: "Terence" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 12, 2003 2:02 AM Subject: Re: Error 127, some questions What OS/kernel are you running? Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 ----- Original Message ----- From: "Terence" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 11, 2003 2:28 AM Subject: Error 127, some questions > Dear List, > > We have several tables experiencing table error 127 quite often, sometimes > several times per day. I have read the relevant posts recently, including > http://www.mysql.com/doc/en/Repair.html > > Forgive me for my lack of technical expertise in these questions: > > 1) The SQL statements are all INSERTS (using all fields - see below for > table structure), so is it possible, say when a client server goes down > during an insert, that somehow the data only gets inserted "half-way"? > > 2) From other posts, it seems that one common column is a date or timestamp > field. Could this be the problem? > > 3) There are no (very few - once a month for statistical reporting) selects > done on the tables, so we don't know when the problem occurs, so is there a > way to monitor the tables? > > 4) It only affects my tables with more than 10k-20k inserts per day. > > 5) Is moving to InnoDB a way to possible solve the above? > > 6) We occasionally experience "Mysql server has gone away" - due to network > congestion, could this cause problems? > > I am using MyISAM tables, MySQL version 3.23-49a. > > CREATE TABLE /*!32300 IF NOT EXISTS*/ vine ( > id int(25) unsigned NOT NULL auto_increment, > username varchar(50) , > url text , > timeaccess datetime , > remote_addr varchar(30) , > include varchar(50) , > PRIMARY KEY (id), > UNIQUE id (id), > INDEX others (include,username) > ); > > > > Thanks alot for your help. > > Rgds > Terence > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]