Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Can anybody tell me that how can we reduce the redo log file size or can we remove the redo log file size in MySQL Cluster and also what will be the impact of it on performance of cluster.Also can we disable Redo logging in MySQL cluster.

share|improve this question

1 Answer 1

You can decrease the size of redo log files by decreasing parameter NoOfFragmentLogFiles which defines no. of fragment files or by reducing size of each fragment file by parameter FragmentLogFileSize. By default NoOfFragmentLogFiles=16 and FragmentLogFileSize=16M. Hence total redo log files size will be 256MB and there are 4 of these if you will look into your file directory system; D8 D9 D10 D11; If your NoOfReplicas parameter is 1 then only one redo log file will take upto size 256MB and rest will have an apparent size of 256MB not actual.You can see the redo usage by executing command all dump 2398; on management node and look into node's ndb_"NODEID"_out.log. You will see redo files usage.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.