Bug 34411 - mysql maxes out at 4GB file size for mysql tables (loading tables stops here)
mysql maxes out at 4GB file size for mysql tables (loading tables stops here)
Product: Red Hat Linux
Classification: Retired
Component: mysql (Show other bugs)
i386 Linux
medium Severity medium
: ---
: ---
Assigned To: Patrick Macdonald
David Lawrence
Depends On:
  Show dependency treegraph
Reported: 2001-04-02 21:29 EDT by Kurt Zingler
Modified: 2007-04-18 12:32 EDT (History)
0 users

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2001-04-13 10:46:13 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Kurt Zingler 2001-04-02 21:29:21 EDT
I have 2 machines that are having the same problem
(2CPU/PIII with wolverine and 1CPU/PII with fisher)

There is one very large table in a mysql db I am using.
When I try to load that table, it refuses to add any more records (380K records, 4GB [4,294,939,020]).
There are a number of related bugs for tcsh and db2, but they all have a problem at the old 2GB limit.
I have tried this from both the bash and tcsh and had similar results.

I am using ext2, with the default 4096 block size, on 9GB and 18GB drives
Comment 1 Trond Eivind Glomsrxd 2001-04-03 11:51:33 EDT
Can you try the mysql rpms (3.23.36-1) from http://people.redhat.com/teg/mysql?
Comment 2 Trond Eivind Glomsrxd 2001-04-06 15:43:04 EDT
Have you had the time to do this?

Also, how do you try to load it?
Comment 3 Kurt Zingler 2001-04-06 18:50:51 EDT
I upgraded mysql, mysql-devel, and mysql-server, and then I tried to reload additional data to that tablespace and
I got the same error.
I attempted to load data using:
"mysql> load data local infile 'dna-table.10' replace into dna"
and I get:
"I get "ERROR 2013: Lost connection to MySQL server during query" as soon as I get to the first new (non-replace) record.
If I do a full new load
"mysql> load data local infile 'dna-table.11' into dna"
I get and immediate server disconnect
ERROR 2006: MySQL server has gone away
No connection.  Trying to reconnect...
Connection id:   6
Current database: ensembl

ERROR 2013: Lost connection to MySQL server during query

Sorry for the delay in the reply.
Comment 4 Kurt Zingler 2001-04-06 21:30:25 EDT
I tried a client upgrade as well.  As expected, that made no difference.
Comment 5 Trond Eivind Glomsrxd 2001-04-13 10:46:08 EDT
I've confirmed that MySQL has problems with files bigger than 4GB... it does
identify large file support during configure, but it doesn't seem to use it.
Comment 6 Trond Eivind Glomsrxd 2001-04-17 14:41:01 EDT
Tables need to be configured in a specific way... take a look at


Note You need to log in before you can comment on or make changes to this bug.