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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
