Re: 64MB Limit on MyISAM indexes?
Hi, I'm having that same problem, but I only have about 1.3 million rows in my table, and the size is only about 190MB or so. This started with 3.23.21 (Which had this problem, look in the changelog), but it is also continuing after upgrading to 3.23.36. I have a 3.23.36 slave that is replication off of the one above, and that one now has a index that is well over 100MB. Weird thing is that the db files are 100% the same(ie, they are both from the same tar'ed mysql directory/files), so this could suggest it has to do with glibc or somesuch. The working on is a RH7(glibc 2.2) box and the non-working is an old slackware 4.0(libc 5.4.46) box with some upgrades. However, from the manual: MySQL requires libc Version 5.4.12 or newer. It's known to work with libc 5.4.46. So that shouldn't be a problem either. Both are running 2.2.19 on i386. Thanks, Ole Gjerde Mimer 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 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 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 hope I don't have to go back to ISAM tables... - 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
RE: 64MB Limit on MyISAM indexes?
-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
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 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 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 hope I don't have to go back to ISAM tables... Any suggestions? Thanks, Jeff Brewer Spam filter bypass: (database,sql,query) - 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 - 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