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?). If so, is there any posibility to split indexes in more than one physicaly file (one index=one file and not all indexes in one file)... or do you know any hack which makes me able to adress files larger than 4 GB on a linux system?
Thanks in advance and sorry for the poor english :) Stefan --------------------------------------------------------------------- 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
