Hello,
I have a table, not too large (200,000+). It crashes all the time. I
should qualifiy that: it crashes when I perform updates to it. I can
qualify that further, and say that it crashes when I update certain fields.
One more thing, the fields that it crashes seem to all be part of a fulltext
index. So, I'm wondering if maybe fulltext indexes for my version of MySQL
are unstable, should I elminate them, upgrade or what.
Here is what I've got:
MySQL (4.0.0-alpha) running on a FREEBSD Box
Latest ODBC drivers for MySQL running on a Win2k box - all of my code is in
ASP and uses ADO / SQL via the MYSql ODBC.
I've included the structure of the table below.
Thanks for the help!!
Karl
CREATE TABLE submit (
submitid int(11) NOT NULL auto_increment,
name varchar(50) default '',
title varchar(80) NOT NULL default '',
url varchar(100) NOT NULL default '',
email varchar(50) default '',
keywords varchar(255) NOT NULL default '',
subject varchar(50) default '',
phone varchar(50) default '',
company varchar(50) default '',
address1 varchar(50) default '',
address2 varchar(50) default '',
city varchar(50) default '',
state varchar(25) default '',
zipcode varchar(25) default '',
country varchar(50) default '',
description varchar(255) default NULL,
service varchar(30) NOT NULL default '',
dbedit timestamp(14) NOT NULL,
amount varchar(16) NOT NULL default '0',
submitdate datetime default NULL,
phone2 varchar(30) NOT NULL default '',
callstatus char(2) NOT NULL default 'NC',
notes varchar(255) NOT NULL default 'Add your comments here (max 255
char.)',
caller varchar(10) NOT NULL default '',
followupdate varchar(15) NOT NULL default '',
pending enum('Y','N') default 'Y',
famappvd enum('Y','N') default 'N',
optkeywords varchar(255) NOT NULL default '',
opturl varchar(255) NOT NULL default '',
srvcOptCode varchar(16) NOT NULL default '',
srvcAuthCode varchar(16) NOT NULL default '',
srvcExpDate date NOT NULL default '0000-00-00',
srvcStatus varchar(10) NOT NULL default '',
preferred int(11) NOT NULL default '0',
submittedby varchar(15) NOT NULL default '',
PRIMARY KEY (submitid),
UNIQUE KEY url_unique (url),
KEY service (service),
KEY name_index (name),
KEY opturl_index (opturl),
KEY optkeywords_index (optkeywords),
KEY submitdate_index (submitdate),
FULLTEXT KEY full_4_index (title,keywords,description,url)
) TYPE=MyISAM PACK_KEYS=1;
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
