Yes, I saw that before...My filesize was limited to 2GB before, but now with a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB data file now, right?
So something's wrong... as I said before, I have successfully created a 9GB file on this machine before, so the filesystem isn't to blame for a 4GB limitation... > >From http://www.innodb.com/ibman.html : > > .... > MySQL/InnoDB-3.23.44, November 2, 2001 > > You can define foreign key constraints on InnoDB tables. An example: FOREIGN > KEY (col1) REFERENCES table2(col2). > You can create > 4 GB data files in those file systems that allow it. > .... > > Thus > 4 G files should be available also on 4.0.1. > > Best regards, > > Heikki Tuuri > Innobase Oy > "Gurupartap Davis" wrote in message ... > >I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB > >data files, > >but mysql is telling me that the files must be <= 4096MB > > > >This is on a RedHat 7.2 box with redhat's 2.4.9-13 enterprise kernel on a > >reiserfs filesystem... > > > >I don't think there should be such a low limit...I accidentally made a 9GB > >log file the other day. > > > >Is this a limit of innodb? Is there somewhere I can adjust this limit? > > > >Thanks > >-Partap Davis > >Syncrasy, LLC --------------------------------------------------------------------- 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