Re: 64MB Limit on MyISAM indexes?

2001-04-23 Thread Ole Gjerde
AS - Original Message - From: ryc [EMAIL PROTECTED] To: Jeff Brewer [EMAIL PROTECTED]; MySQL Mail List [EMAIL PROTECTED] Sent: Saturday, April 21, 2001 2:59 AM Subject: Re: 64MB Limit on MyISAM indexes? You need to change the maxrows on the table. It is in the documentation, I dont remember the exact

64MB Limit on MyISAM indexes?

2001-04-20 Thread Jeff Brewer
I've got tables in ISAM format whose indexes are way over 64 MB. However, when I try to create a MyISAM table with an index that big I get errors and confirming that with myisamchk I get: myisamchk: warning: Keyfile is almost full, 67107839 of 67107839 used Which is essentially 64MB. Are

RE: 64MB Limit on MyISAM indexes?

2001-04-20 Thread Nemholt, Jesper Frank
-Original Message- From: Jeff Brewer [mailto:[EMAIL PROTECTED]] Sent: viernes, 20 de abril de 2001 18:24 To: MySQL Mail List Subject: 64MB Limit on MyISAM indexes? I've got tables in ISAM format whose indexes are way over 64 MB. However, when I try to create a MyISAM table

Re: 64MB Limit on MyISAM indexes?

2001-04-20 Thread ryc
You need to change the "maxrows" on the table. It is in the documentation, I dont remember the exact syntax something like "alter table tablename set maxrows=1" for tables larger than 2gigs. ryan I've got tables in ISAM format whose indexes are way over 64 MB. However, when I try to