# fleet

Jincheng Yin

04/18/2023, 9:37 AM
Hi team, we are seeing the DB increased 1GB last month. Will the size of DB keep growing?

Keith Swagler

04/18/2023, 12:57 PM
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.

Lucas Rodriguez

04/18/2023, 4:16 PM
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;

Jincheng Yin

04/19/2023, 10:28 AM
Thanks, we enabled the software inventory check and added more hosts. Will keep monitoring this if it's keep growing.