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
Last activity: Dec 8, 2022, 09:03 AM