MySQL Forums :: NDB clusters :: FragLog Files


Advanced Search

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
FragLog Files 53 Brad Fuller 03/16/2017 09:41AM
Re: FragLog Files 32 Mikael Ronström 03/16/2017 10:33AM
Re: FragLog Files 22 Brad Fuller 03/16/2017 10:45AM
Re: FragLog Files 21 Mikael Ronström 03/17/2017 02:31AM


Sorry, only registered users may post in this forum.

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.