4Gb post table limit?

[krohnathlonman]

On a test forum of mine I've been doing some scaling tests and my post table is about 4.1Gb and now when I try to insert more data I get an error that says
mysql error: The table 'post' is full

mysql error number: 1114

Is this something that's been covered here before cause I can't find an answer in the searches I've done so far.

[Steve Machol]

http://dev.mysql.com/doc/mysql/en/Full_table.html

[Icheb]

The most probable reason would be that the operating system's file size limit has been reached, especially since your table is 4 gb large. I don't think there's anything that can be done short of recompiling the kernel and specifying a larger file size limit.

[krohnathlonman]

This ended up working great for me:

ALTER TABLE post MAX_ROWS=1000000000

Any recent OS will support above 4.1Gb files without recompiling the kernel. The test forum I'm putting together currently has a 6Gb post table and growing rather quickly.