Hello Alexey,

with a log queue count greater 1 every log page is only written once to the
volume.
Otherwise a logpage is furthermore filled after writing until it is full.
So the log pages are less filled if you have more then one log queue.
Short transactions sharpen the conditions.

If you have no high collision rate on the logqueue1 region you need not to
increase the LogQueueCount.

Kind regards
Uwe
 

>-----Original Message-----
>From: Alexey Gaidukov [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, December 13, 2005 7:57 AM
>To: maxdb@lists.mysql.com
>Subject: LOG_QUEUE_COUNT and LOG AREA size
>
>I have multiprocessor MAXDB 7.6.00.16 server. LOG Area size is 
>600Mb. At 
>the first I had LOG_QUEUE_COUNT=1. Usually Log area was full after one 
>week. When I set LOG_QUEUE_COUNT=4 then log area is getting full after 
>one day.
>
>Why when LOG_QUEUE_COUNT=4 then log area stay full so quickly?
>
>
>Thank in advance,
>Alexei Gaidukov
>
>-- 
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to