Working with huge (2GB+) tables in MySQL?

The table is crashing my server

[erikcw]

Hi all,

I have a database that has a pretty large table. Right now it is about 2GB and growing every day. What can I do to optimize this?

I'm getting a mysql error 144 right now. I've tried repairing the table but it doesn't seem to work.

Have I reached a size limitation of mysql or linux?

Right now I keep both the active data the user is working on as well as a backup copy of the data in the same table (for an undo function). Maybe splitting the working data and the backup data into seperate tables would improve performance?

Thanks for your help!

[eelixduppy]

You may be able to find information here [dev.mysql.com]. It states that with Linux 2.2-Intel 32-bit, the max size a table can be is 2GB (LFS: 4GB). Good luck!

[linux_19]

Thanks very much for the links and the info...I am now reading about the mysql tables on mysql homepage