Is there a way to force cleanup memory?

Hi!

After running a large SQL query, the memory usage can go very high.

I have to wait like one hour for the memory usage to go down to normal. Is there a command to force the influxdb to do the cleanup (or garbage collection?) So that I don’t have to wait such long time to start another job?

Thank you!

Hi!

After running a large SQL query, the memory usage can go very high.

That’s not unusual.

I have to wait like one hour for the memory usage to go down to normal.

Why? What problem do you get if you try to run another query after 10
minutes, instead of waiting for 60?

Antony.

It is likely this is mmapped memory and not actual reserved memory space. This means that it’ll be freed when other applications on the host need it.

However, to confirm; you can take a heap snapshot after a large query and share it with us - this will allow us to debug.

Hi Antony

Why? What problem do you get if you try to run another query after 10
minutes, instead of waiting for 60?

The 90% usage looks pretty scary. I will try to run jobs next time. Thank you!