Hi!
On Jan 13, Kurt Haegeman wrote:
> Hi,
>
> When trying to create a fulltext index on my large table, I get the
> following error:
>
> ERROR 1034 (HY000): 121 when fixing table
>
> I'm using version 4.1.1-alpha of the MySQL database, a source-compiled
> version with the --with-raid option. I'm trying to build a newpaper
> article search engine. I've built an 'articles' table with the following
> DDL:
>
> CREATE TABLE articles (
> filename varchar(40) default NULL,
> source varchar(30) default NULL,
> pubdate varchar(30) default NULL,
> text text
> )
> TYPE=MyISAM
> DEFAULT CHARSET=latin1
> MAX_ROWS=10000000
> AVG_ROW_LENGTH=2366
> RAID_TYPE=striped
> RAID_CHUNKS=16
> RAID_CHUNKSIZE=2048;
>
> I've inserted 7806867 articles in dutch and french into it, which gives
> me a table of about 16Gb, leaving 75+Gb of free space on my Compaq
> Proliant DL380G2, 1.2Gb RAM. The kernel is compiled with HIGHMEM
> support, and the MySQL database is using a cnf based on my-huge.cnf.
>
> Somebody knows where to start looking?
What is the exact command that generates en error ?
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]