8 messages in com.mysql.lists.mysqlRe: InnoDB File Size
FromSent OnAttachments
Gurupartap Davis06 Feb 2002 12:43 
Heikki Tuuri07 Feb 2002 13:02 
Heikki Tuuri07 Feb 2002 13:02 
Gurupartap Davis08 Feb 2002 16:32 
Gurupartap Davis08 Feb 2002 16:32 
Kyle Hayes08 Feb 2002 18:59 
Heikki Tuuri09 Feb 2002 03:10 
Heikki Tuuri09 Feb 2002 03:10 
Subject:Re: InnoDB File Size
From:Gurupartap Davis (par@yahoo.com)
Date:02/08/2002 04:32:23 PM
List:com.mysql.lists.mysql

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 <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-cyon=best@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php