Re: Error with "Read Backup"
Thanks again for your assistance.
I set all tables to READ_BACKUP=0, but the resource usage didn't return to normal. I then restarted the cluster. While the first data node was restarting, the second one crashed. I then restarted both of them and the cluster seemed fine. Resource usage stayed high until I ran "analyze tables". Then resource usage dropped, but I don't know if it was because of the analyze command or just a coincidence. I then made a few tables READ_BACKUP=1. At the moment, ndbmtd is only using 17% of CPU. That is compared to 500% earlier.
Since CPU usage is low now, I'll leave NoOfFragmentLogParts alone for now.
Subject
Views
Written By
Posted
1019
August 29, 2017 03:25PM
540
August 29, 2017 03:50PM
466
August 30, 2017 08:52AM
555
August 31, 2017 03:15AM
497
August 31, 2017 04:30AM
581
August 31, 2017 10:52AM
544
August 31, 2017 12:41PM
608
August 31, 2017 01:57PM
620
August 31, 2017 02:00PM
Re: Error with "Read Backup"
580
August 31, 2017 04:37PM
564
August 31, 2017 04:59PM
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.