How to archive least used data?
===

Environment: JSF2, persistence with Hibernate, MySQL

I have a database that is rappidly filling because of a table with image data. That data is never searched but only directly accessed by id. Problem is that it stays in the database and so enlarges the backups and the runtime memory usage of the database.

I'm thinking that there could possibly be multiple solutions:

 - Tell MySQL that the table should not be cached and/or kept in memory.
 - Don't use MySQL at all for that table. Just let persistence know that this should be stored on disk directly.
 - ???

But I haven't found a way to do either. Please advice.

Thanks,
Milo van der Zee

 
