On Thu, Apr 11, 2002 at 10:46:43AM +0200, Stefan Siefert wrote: > Hi all, > > we have a little problem with the size of our index file. We need to > set a lot of combined Indexes and singel Indexes (we have a table > with ca. 40.000.000 entries and something about 20 Columns). I'm > pretty sure that the index file will get over the 4 GB size. We use > Linux 2.4.x with a new glibc and MySQL compiled with > --enable-largefile. I'm not sure, but this means we are limited to > at least 4GB per file (or am I wrong?).
We have RedHat 7.1 and 7.2 based machines that have files much larger than 4GB on them. We have a 9GB .MYD file in at least one place. There's no reason a .MYI file can't be that large. We're using the standard MySQL binaries on box of those machines. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 63 days, processed 1,712,121,041 queries (312/sec. avg) --------------------------------------------------------------------- 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