• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql db /hibernate -- running out of space

 
Adrian Burlington
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21586
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, so I can go to sleep with no worries?
 
Paul Clapham
Sheriff
Posts: 21586
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic