Garbage Collection on AutoLoader

[nolanlavender00]

Once a week, I get very long run times with AutoLoader. The spark job says it is done, but garbage collection keeps rising on the driver. I assume this is because of the backfill interval that I am using with FileNotification Type. I have this set to do so every week.

Is my suspicion right? If so how could I handle this and is the Backfill Interval necessary?

[Kaniz_Fatma]

Hi @nolanlavender008​, You can reduce the backfill interval to a more frequent interval allowing timely processing of incoming files. You could experiment with different intervals to balance processing efficiency and resource utilization.

Another approach could be to implement a mechanism that prevents the backlog of files from building up in the first place. For example, you could consider setting up a monitoring system that alerts you when the number of unprocessed files reaches a certain threshold and then trigger the AutoLoader job manually to process the files.

[Anonymous]

Hi @nolanlavender008​ 

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you. 

Cheers!