Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register


2
(click on this box to dismiss)

How can you safely delete log files ?

Hello,

I have the following problem. For some reason, several hundred files with the name xe_lgar001,xe_lgar002,...,xlgar411 files have appeared in the folder for my database named "xe". I have read that they are log files used for backup, but they keep appearing (about 1-2 per day) and each of them is about 40 MB. Also, none of them have disappeared and I even have files since December 16 last year. Is there a way to enable their automatic cleanup ?

Is there any way to safely delete the log files and limit their creation?

Ovidiu

링크 댓글 쓰기 (0) 선택된 답변
질문시간 2년 전
ovidiuv
55
69 답변들
1

The _lgar files are transaction log archive files. As explained in the Managing Archive Logs section of the CUBRID Manual, you should never delete those files manually (using file system commands), there is no way of knowing which of them are in use.

You can configure how much archives the CUBRID server keeps by configuring the Logging Related Parameters. The ones you are interested in are log_max_archives and force_remove_log_archivesTake care when configuring these parameters because setting them wrong might have an impact on CUBRID performance.

링크 댓글 쓰기 (0)
답변시간 2년 전
ginarrbrik
516




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: