Hi Michael, in online mode there must must exist as many unsaved log pages as defined by LOG_SEGMENT_SIZE. In admin mode you can really backup everthing which is currently in the log volume. kind regards Uwe
> -----Original Message----- > From: Michael Mostkowiak [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 4. November 2003 18:03 > To: [EMAIL PROTECTED] > Subject: LOG Problem :/ > > > Hi all, > > I enter the following command: > > dbmcli -uUTL -d TESTDB -u dbm,dbm -c backup_start LOG > > I expect the logarea to be empty, but it is NOT! My logfiles become > bigger and bigger. > > "Used Size" is 11%....i will 0% after writing logfile.. > > -rw-r--r-- 1 tgb tgb 311227 Nov 4 12:38 > backup_gz_logP_03110409_aa > -rw-r--r-- 1 tgb tgb 6156146 Nov 4 13:39 > backup_gz_logP_03110410_aa > -rw-r--r-- 1 tgb tgb 19563541 Nov 4 14:39 > backup_gz_logP_03110411_aa > -rw-r--r-- 1 tgb tgb 46139017 Nov 4 15:39 > backup_gz_logP_03110412_aa > -rw-r--r-- 1 tgb tgb 71146131 Nov 4 16:40 > backup_gz_logP_03110413_aa > -rw-r--r-- 1 tgb tgb 90091461 Nov 4 17:40 > backup_gz_logP_03110414_aa > -rw-r--r-- 1 tgb tgb 110344617 Nov 4 18:40 > backup_gz_logP_03110415_aa > -rw-r--r-- 1 tgb tgb 127209615 Nov 4 19:26 > backup_gz_logP_03110416_aa > > > Log Writing = > ON > Log Automatic Overwrite = > OFF > Max. Size (KB) = 4799984 > Backup Segment Size (KB) = 1600000 > Used Size (KB) = 545112 > Used Size (%) = 11 > Not Saved (KB) = 543016 > Not Saved (%) = 11 > Log Since Last Data Backup (KB) = 0 > Savepoints = 410 > Checkpoints = 0 > Physical Reads = 29647 > Physical Writes = 76308 > Queue Size (KB) = 400 > Queue Overflows = 0 > Group Commits = 13 > Waits for Logwriter = 9949 > Max. Waits = 4 > Average Waits = 0 > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
