Re: Error 1034: 136 when fixing table from Create Index on long table

2002-10-22 Thread Chris Stoughton
a file system which allow to create files greater than 2 GB for exemple ? Original Message - From: <[EMAIL PROTECTED]> To: "Jocelyn Fournier" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 1:33 AM Subject: Re: Error 1034: 136 when fixing table from Create Index on

Re: Error 1034: 136 when fixing table from Create Index on long table

2002-10-21 Thread Jocelyn Fournier
ED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 12:26 AM Subject: Error 1034: 136 when fixing table from Create Index on long table > I am running 3.23.52-Max under Linux. > > I now have a table with 54M rows: > > mysql> select count(*)

Error 1034: 136 when fixing table from Create Index on long table

2002-10-21 Thread Chris Stoughton
I am running 3.23.52-Max under Linux. I now have a table with 54M rows: mysql> select count(*) from targetTsObj; +--+ | count(*) | +--+ | 54549046 | +--+ 1 row in set (0.05 sec) Creating an index on this takes 1 hour 10 minutes, with this error: mysql> create index targ