https://github.com/osquery/osquery logo
Title
j

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?
k

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.
l

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:
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

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.