Storage optimisation for 15k devices

gpsvangpstsofia month ago

Hello, I'm using Traccar on a Contabo server with 1.2 TB of storage, but it's getting filled up every week. How can I fix this issue? I want to retain data for at least 90 days. Please suggest the best way to handle this situation.

Anton Tananaeva month ago

How much data are your devices reporting? Have you checked which files are taking up the storage? Is it logs or database?

gpsvangpstsofia month ago

Majorly storage is occupied by /var/lib/mysql folder ~ 900 GB
logs were around ~ 300 GB

Can you help me with the best approach to go ahead.

Anton Tananaeva month ago

What inside the mysql folder takes that space?

gpsvangpstsofia month ago

There’s a series of these binlog files in mysql folder, each with a size of 101Mb as you can see in the screenshot.
My traccar version is 5.12. This is only one day data for my 3500 devices. By combining all it is taking my 34 GB space for just 1 day data.

Attached image for my storage: https://ibb.co/YFHGYcjg

Anton Tananaeva month ago

Purge binary logs first and then disable them.