• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

mysql db /hibernate -- running out of space

 
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Marshal
Posts: 28258
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks, so I can go to sleep with no worries?
 
Paul Clapham
Marshal
Posts: 28258
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic