Hello,
This is my 2nd post, not to sound pushy, just raising the urgency of my
dilemna. My table is crashing way to often (I'd like it to not crash at
all).
I'm not sure what to do, how to trouble shoot, and how to fix my problem. I
will post the structure of the table here, as well as the pertinent
hardware/software supporting my DB.
I'm wondering if the problem might be with the FullText indexes?
Please Advise.
Karl
TABLE STRUCTURE:
--------------------------------------------
# MySQL dump 8.16
#
# Host: Database: submitsearch
#--------------------------------------------------------
# Server version 4.0.0-alpha
#
# Table structure for table 'submit'
#
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;
SERVER OPERATING SYSTEM / SOFTWARE:
-----------------------------------------------
ASP Script IIS 5.0
Windows 2000 Server Running MySQL ODBC
Makes ODBC connection with MySQL server
FreeBSD Box with MySQL 4.0.0-alpha
---------------------------------------------------------------------
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
