I’m using jar verstion of metabase and running it using java -jar metabase.jar.
its uses H2 database by default.
I have added oracle Datasource for creating some dashboard and questions. day by day the file metabase.db.mv.db is keep on incresing. if I remove this file all my saved dashboards and questions will be deleted.
I have to reduce this file size without losing the dashboards. I have created 35 questions and 5 dashboards will this take 13 GB of space?
Please help me to reduce the space of this file or help me to take a backup of dashboards and questions which I saved.
They’re the H2 database that stores all the Metabase information.
Migrate to MySQL or Postgress if you’re using Metabase for anything more for evaluation.
I have a similar situation. My metabase.db.mv.db is just 59MB where as my metabase.db.trace.db is 1.5GB. What will happen if I just delete my metabase.db.trace.db and keep metabase.db.mv.db?
I do not need any query logs from the past but have to save user data, pulses, questions, etc…
@r-maya
The metabase.db.trace.db is a debug/trace log - it’s not the query log - so it should be okay to remove that file.
The query logs are stored in metabase.db.mv.db - including all other metadata.
My trace file is growing too!
How can I stop it? Can I delete the trace file?
I have a lot of database there. For example the syslog db from all my server and syslog from my firewall contains a lot of logs but 17 GB is a lot of data only for metabase.
We’re running version 0.35.3. I have been watching the trace file for a few months now. No more bloating!
I’m aware of all the warnings for using Postgres, I just haven’t had the time to fully understand the migration steps and make that happen, so I’m just glad H2 seems to be running smoother these days.