2 GB file limit with linux. Fact or Fiction?
I'm using INNODB style tables in MySQL 4.1.4 gamma on Linux Fedora Core 2 (2.6.10).
I have seen several references in various discussion forums to a 2 GB file size limitation for linux and suggestions that this will affect my usage of MySQL.
To test for this problem, so far I have:
o Created and copied a 4GB file. (By successively using cat to concatenate two copies of the same file together until I got a 4GB file, and then using cp to copy it. Seemed to behave fine.)
o Loaded a single InnoDB table with 8GB of data (16384 copies of a half MB blob).
o Successfully backed up the database holding the above table using the mysqldump command line utility.
o Restored this database by running the SQL script created by mysqldump.
o Ran a few simple queries on the restored database -- seems ok.
Is there really a 2GB file-size issue that will ever affect my MySQL operation in any way (other than associated performance issues like backup and restore times)?
Subject
Written By
Posted
2 GB file limit with linux. Fact or Fiction?
March 28, 2005 12:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.