Appfog - Spring application - Disk usage

java mysql spring appfog
Azincourt picture Azincourt · Jul 4, 2014 · Viewed 10.1k times · Source

I have a Spring application running on Appfog.
App is connected to a Mysql DB and doesn't use disk storage (it only perform select or insert queries).
I noticed that the disk usage increased constantly in time (My database is very small, it can't be over 300MB).
This is a screenshot: enter image description here
Why disk usage doesn't remain fixed?
Thanks

Answer

Matthias Steinbauer picture Matthias Steinbauer · Sep 2, 2014

We experienced similar behaviour with one of our apps. In our case we were using Hibernate with C3P0 resource pooling backed by EHCache as the storage backend provider. The default EHCache configuration has disk cache enabled which caches queries and loaded entities to the default Java temp dir. In cloud environments like Appfrog often the temp dir sits inside your user directory and thus accounts for your storage quota.

Obviously this cache can grow larger in size than the original database since the query cache may hold many different query results which can lead to data duplication in the disk cache.

Related questions

Using env variable in Spring Boot's application.properties

We are working on a Spring Boot web app and the database we are using is MySql; the setup we have is we first test it locally (means we need to instal MySql on our PC); then we push to …

Read More
Unable to get spring boot to automatically create database schema

I'm unable to get spring boot to automatically load my database schema when I start it up. Here is my application.properties: spring.datasource.url=jdbc:mysql://localhost:3306/test spring.datasource.username=test spring.datasource.password= spring.datasource.driverClassName = com.…

Read More
Why Spring's jdbcTemplate.batchUpdate() so slow?

I'm trying to find the faster way to do batch insert. I tried to insert several batches with jdbcTemplate.update(String sql), where sql was builded by StringBuilder and looks like: INSERT INTO TABLE(x, y, i) VALUES(1,2,3), (1,2,3), ... , (1,2,3) Batch size …

Read More