mysql db /hibernate -- running out of space

[Adrian Burlington]

Hi Guys,

We've been using mysql for quite some time (2yr) and learned that the size of the db tends to grow over time. Currently, if we dump my db we get a 3.2GB file. I'm aware that mySql can hold up to 4GB of data (I guess only on 32bit os).

If this continues, we may find that the db doesn't work properly anymore. What are the options we have? Can anyone advise/recommend what should we do in order to have the db working properly in the long run without the fear of running out of space? We store only TEXT! no photos/videos or any stream, text only!

*we're using hibernate

Thanks for any pointers.

[Paul Clapham]

Adrian Burlington wrote:I'm aware that mySql can hold up to 4GB of data (I guess only on 32bit os).

You've got a rumour? I've got a fact: http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html.

Those limits are per table, not per database. So if you're still using Windows 98 and are therefore still using FAT32, then yes, you're going to be limited to 4 GB per table; read the cautionary note in that link I posted about that.

[Adrian Burlington]

Thanks, so I can go to sleep with no worries?

[Paul Clapham]

LOL! There's always something available to worry about, isn't there?

But you could do a stress test: add data to your database until something blows up. Correction: a COPY of your database, on some other machine!