MySQL Forums
Forum List  »  NDB clusters

Re: FragLog Files
Posted by: Mikael Ronström
Date: March 16, 2017 10:33AM

The simple answer is no.
These FragLog files are the REDO log files and we allocate all of them
at the initial start and also ensure that the files are written such that
we don't run out of filespace in the middle of execution.

In your case it seems like you generate about 512M Redo Log per 3 days.
So for your workload this is a bit oversized. At the same time if you
at some time have to restore a backup you might need more REDO log
during the restore. So important to not set the REDO log size too small.

To change the number of FragLog files you need to do the following.
1) Change the NoOfFragmentLogFiles configuration for this node 4.
2) Restart management server to read in the new config file
3) Perform an initial restart of node 4.

An initial node restart is an online change.

This will take some time, but after that your REDO log files will take less
space.

It is always good to have a homogenous cluster. So should do this for all
nodes and at most one node per node group at a time.



Edited 1 time(s). Last edit at 03/16/2017 10:34AM by Mikael Ronström.

Options: ReplyQuote


Subject
Views
Written By
Posted
1365
March 16, 2017 09:41AM
Re: FragLog Files
1274
March 16, 2017 10:33AM
671
March 16, 2017 10:45AM
872
March 17, 2017 02:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.