Missing the primary key on the slave always causes the big events to replicate/apply slowly as it needs to do a full table scan due to missing primary index. So B & D
Not A. The thread is normally very fast and a master can have multiple slaves.
Tables not having primary keys can cause replication slowness.
I have seen a master execute many queries in parallel but a slave executes them serially.
The correct answers are:
A. The master is most probably too busy to transmit data and the slave needs to wait for more data.
D. The master is producing a large volume of events in parallel but the slave is processing them serially.
Explanation:
A. When the "Seconds_Behind_Master" value is steadily growing, it indicates that the slave is falling behind the master because it's waiting for data from the master. This can happen if the master is busy and cannot transmit data to the slave as quickly as the slave can process it.
D. If the master is producing a large volume of events (changes) in parallel, but the slave is processing them serially (one by one), it can lead to a situation where the slave falls behind the master. The slave might not be able to keep up with the incoming changes, causing the "Seconds_Behind_Master" value to increase.
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
abpg
2 months agoMOHAMEDMOIDEEN
10 months, 2 weeks agomarklv
1 year, 1 month agomarklv
1 year, 1 month agonkanike1
1 year, 3 months agoFelipeK
1 year, 4 months ago