mysql table corruption 1

[baggins2000]

I am running mysql on a RH 7.0 system with ext2 file system. On one of my tables whenever I get a little over 2G the table becomes corrupted and not matter what recovery method I use, I end up having to drop the table and start all over recreating the table. Is there an upper limit to table sizes? This is mysql version 3.23.32. Any help or ideas appreciated.

 

[Bastien]

Hi

Check the limits on the table space allocated by RH. Each table in MySQL is stored as a separate file and MySQL tables sizes are really dependant on the OS for Max size.

hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[baggins2000]

Would you happen to know where I would find this in a Red Hat system. This definitely sounds like the source of the problem.