Storage optimisation for 15k devices
How much data are your devices reporting? Have you checked which files are taking up the storage? Is it logs or database?
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.
What inside the mysql folder takes that space?
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
Purge binary logs first and then disable them.
Hello Anton, I have this consulmo problem in the binlog, how do I disable it?
Have you tried searching online? You need to add disable_log_bin to the MySQL config file.
yes, the path is right of the folder: mysqld.cnf .
skip-log-bin
tks
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.