Re: Fulltext index is not being built with large database

[sascha mantscheff]

Hi Matt, thanks for the help.

Meanwhile the index has been built, and I assume it's a problem of 
terminal sessions:

At first I tried it with a remote mysql client issuing the ALTER TABLE 
command. This session was closed after some inactivity.

Then I logged in to the database host and retried - same result.

Then I packed the commands in a shell script which I ran with nohup - no 
results whatsoever. No error log entry, no index, no nohup.out.

Then I tried it again with a terminal session, but this time I configured 
the terminal program to send null bytes every 60 seconds to keep the 
connection open. And voila - after 19 hours the index was built. So it may 
be a flaw, a bug or even a feature in the mysql client/server protocol - I 
assume I'll never know.

But the index works, and it's speed, ease of use and maintainability will 
be strong arguments against htdig.

s.m.

Am Sat, 10 Apr 2004 04:01:15 -0500 hat Matt W <[EMAIL PROTECTED]> 
geschrieben:

Hi sascha,

How's the space on your datadir partition (or wherever this table is)?
I believe MySQL creates the temp tables during ALTER in the DB
directory, not the tmpdir.
If the space there is OK, have you checked the error log for anything
related?
Matt

----- Original Message -----
From: "sascha mantscheff"
Sent: Friday, April 09, 2004 4:21 PM
Subject: Fulltext index is not being built with large database

I'm trying to build a fulltext index on a table with about 4 million
entries with 2 varchar and one text field.
The indexing starts and runs for about 1/2 to 1 hour, then the process
stops without any error message. And leaves me with no index. I
checked
for the size in tmp and redirected it to a partition with 50GB space
(about 15 times as much as the database tables).
Mysql runs on gentoo-linux 2.4 with 800MB RAM with server version
4.0.17.
Any clues, hints or tips?
Thank you.
sascha mantscheff



--
sascha mantscheff
hahnenbach
51570 windeck
[EMAIL PROTECTED]
telefon +49-2292-922 492
telefax +49-2292-922 493
mobil +49-171-620 0380
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]