I setout a clean /tmp path with no ResultSpooler*.bin file.
then I execute 60 query.
via my ambush log.
I found it create 2430 ResultSpooler files.
and delete 1746 tmp files with no use(In memory)
and delete 564 tmp files with OnDiskResultIterator close().
also residue 120 tmps file in /tmp path. never be deleted.
1. why 60 query create 2430 tmp files
2. InMemoryResultIterator I think it didn't need create tmp file ever.
3. how to resolve the 120 Lethean tmp files.