Hello Mischa, [...] >Second question: >What is it good for having more than one "normal-not mirrored" logfile when >u use automatic backup?
The automatic log backup starts to work if log_segment_size log pages were written to the log. In the default case this is after 1/3 used logsize and then only this 1/3 logsize is backuped. So you will loose log in case of a log volume damage and you can avoid this with a mirrored log. >Third question: >If u use automatic backup for the logfile and for example >log_segment_size(ed) 3000 pages, what >logfile size do u recommend? The default calculation for log_segment_size is logsize/3 so if you have a preferred log_segment_size because it defines the log backup size (in online mode) as well then use 3*log_segment_size for the logsize. If you set log_segment_size to 0 the default will be automatically calculated during param_checkall. Once the value is calculated it will not change automatically if you add additional log volumes. Kind regards, Uwe -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
