Hi,
Perhaps try to upgrade first from 4.0.0 to 4.0.3 to see if the problem still
happens ? (many fixes have been introduced, especially on FT search)
Regards,
Jocelyn
----- Original Message -----
From: "Karl J. Stubsjoen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 01, 2002 3:35 AM
Subject: Request for help - Table Crashing
> 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
>
>
>
>
---------------------------------------------------------------------
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
