Quote:
By the way, I dont have any checkpoiint calls , could that be my
problem?
Yes, log files are only removed after a checkpoint, after the data has
actually hit the disk.
Thanks for your reply, but I thought checkpoints just flush the
current log file and uncommitted stuff. In my situation, new log files
are constantly being created, for exmaple, when the files have reached
upto log.1000, I would imagine, log.0001 can be safely removed? |
Not necessarily. This depends on factors such as log file and cache
file size. It's only permitted to remove those log files if the
transactions recorded within them have completed, and their updates
are reflected in the on-disk database files. A checkpoint ensures
this.