MySQL Forums
Forum List  »  NDB clusters

Re: MySQL Cluster data nodes fails with 7200: LCP fragment scan watchdog
Posted by: Mikael Ronström
Date: January 16, 2018 06:43PM

Hard to say without more insights into your use case.
But some parameters that control disks are
1) MinDiskWriteSpeed, MaxDiskWriteSpeed*
Control speed of writing checkpoints to disk
2) NoOfFragmentLogParts, NoOfFragmentLogFiles, FragmentLogFileSize
Controls size of REDO logs
Speed of writing REDO logs is dependent on the amount of
write transactions.
3) If u have disk columns, the DiskPageBufferMemory is an important
configuration parameter to set.
4) TimeBetweenGlobalCheckpoints
Sets time between flush disk writes to ensure transactions are durable

Options: ReplyQuote




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.