Hi team, we are seeing the DB increased 1GB last ...
# fleet
j
Hi team, we are seeing the DB increased 1GB last month. Will the size of DB keep growing?
k
Is it the DB itself or the bin logs? We had to set a more agressive log rotation on the big logs for our deployment. The other thing that will likely take up some space is software inventory if you enabled that recently.
l
Hi @Jincheng Yin! A MySQL query like the following could help us determine which are the tables that are consuming a lot of space:
Copy code
SELECT table_name, round(((data_length + index_length) / 1024 / 1024), 2) AS size_mb FROM information_schema.TABLES WHERE table_schema = "fleet" ORDER BY size_mb DESC;
j
Thanks, we enabled the software inventory check and added more hosts. Will keep monitoring this if it's keep growing.