470,636 Members | 1,582 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

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/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1607

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

18 posts views Thread by Geoff Cox | last post: by
4 posts views Thread by PRadyut | last post: by
reply views Thread by rlueneberg | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.