> -----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 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 MyISAM tables able to handle 
> large indexes?

I've had ISAM and now have MyISAM indexes larger than 2 GB, so yes.

> I hope I don't have to go back to ISAM tables...
> Any suggestions?

Haven't seen that error before, so I can't help you.

--  
Un saludo / Venlig hilsen / Regards

Jesper Frank Nemholt
Unix System Manager
Compaq Computer Corporation

Phone : +34 699 419 171
E-Mail: [EMAIL PROTECTED] 

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to