This has been discussed before back in 2002, and then in Feb of 2003
when I did a search on Google Groups for MySQL Table Sizes. Back then,
people said go here:
http://www.mysql.com/doc/en/Table_size.html
However, people have posted replies at the bottom of this page saying
that this information is severely out of date.
Okay, so has anyone taken the latest stable release of their version
of Linux, plus the latest MySQL, and tried a test to see how much they
could cram into a table? I think people are saying it's 8 terrabytes.
Specifically, one poster in the link I have for you above wrote:
"I spent an hour after reading your web page (several times over)
trying to figure out my max file size, and I never installed any
patches, nor have I even heard of LFS, yet my current Linux is happy
with 7+gig files (the limit is 2^64 bytes)."
So, what is it? I have Red Hat 9 and I'm using the version of MySQL
that came with it, although much of my RH9 has been updated using
Up2Date, including a recent MySQL update. I don't have any idea how to
find out the version of my kernel, but the kernel logfile on my system
says:
Linux version 2.4.20-8 (bh*******@porky.devel.redhat.com) (gcc version
3.2.2 20030222 (Red Hat Linux 3.2.2-5)) #1 Thu Mar 13 17:54:28 EST
2003
....so I think I'm on the type of kernel (2.4.20) that supports this
large file size.
Please let me know because I'm considering whether to do my next PHP
website project in PostgreSQL or MySQL, and the table size limitation
would be a well, biggie.