Hi! I just tried with 3.23.48 on Linux-2.4.16-SMP-64GB (ext2 I think), and a 5000 MB data file was created.
Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com -----Original Message----- From: Gurupartap Davis <[EMAIL PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, February 09, 2002 2:32 AM Subject: Re: InnoDB File Size >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