wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes mysql db /hibernate -- running out of space Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "mysql db /hibernate -- running out of space " Watch "mysql db /hibernate -- running out of space " New topic
Author

mysql db /hibernate -- running out of space

Adrian Burlington
Ranch Hand

Joined: Jun 16, 2009
Posts: 75
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
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

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

Joined: Jun 16, 2009
Posts: 75
Thanks, so I can go to sleep with no worries?
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

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!
 
Don't get me started about those stupid light bulbs.
 
subject: mysql db /hibernate -- running out of space
 
Similar Threads
File upload/download question
program running properly but values are not reflecting in database
OutOfMemory Error
Hibernate
Running the same Application(different name) giving error