Sample Header Ad - 728x90

Why slave_parallel_workers affects TPM

0 votes
1 answer
980 views
I ran a few HammerDB benchmarks and mess with the configurations. And I notice different values of slave_parallel_workers have a considerable impact on TPM. As far as I understand, slave_parallel_workers only affects how quickly the transactions are being applied from the relay log. Yet, all the possible HA/DR setups, including async replication, semi-sync replication, and group replication will not wait for the transactions to be applied on the secondary node(s) before committing. To my understanding, slave_parallel_workers should only affect replication lag and have zero impact on TPM while this is clearly not the case. Am I missing something? **Edit:** To clear any confusion, I expect the value of slave_parallel_workers will have no impact on TPM. While the reality is the higher the value of slave_parallel_workers is, the higher the TPM is. So I'm hoping someone would be able to explain the reason for that. **Edit 2:** All transactions are done on the primary node.
Asked by Matthew Kwong (113 rep)
Jun 28, 2021, 03:39 AM
Last activity: Dec 8, 2022, 09:03 AM