• 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
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Devaka Cooray
  • Ron McLeod
  • paul wheaton
Saloon Keepers:
  • Tim Moores
  • Piet Souris
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Frits Walraven
  • Scott Selikoff

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: 27451
88
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: 27451
88
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!
 
So it takes a day for light to pass through this glass? So this was yesterday's tiny ad?
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic