[#MDEV-7557] Option to put into slow log any transaction that was retried in parallel replication

[MDEV-7557] Option to put into slow log any transaction that was retried in parallel replication Created: 2015-02-07 Updated: 2015-03-19
Status:	Open
Project:	MariaDB Server
Component/s:	Replication
Affects Version/s:	10.1.3
Fix Version/s:	10.1

Type:

Bug

Priority:

Minor

Reporter:

Kristian Nielsen

Assignee:

Kristian Nielsen

Resolution:

Unresolved

Votes:

Labels:

parallelslave, replication

Description

In optimistic parallel replication (~~MDEV-6676~~), we speculatively apply
transactions in parallel, even if they might conflict. If too many conflicts
happen, excessive retry might degrade performance.

The DBA needs some way to monitor for such problems. One good way would seem
to have an option to add to the slow query log any transactions that were
retried due to parallel replication conflicts. Possibly with extra information
such as duration of transaction and similar.

Comments

Comment by Sergei Golubchik [ 2015-03-19 ]

I'm not sure that slow log is a good match for this kind of events

Generated at Thu Feb 08 07:20:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.

[MDEV-7557] Option to put into slow log any transaction that was retried in parallel replication Created: 2015-02-07 Updated: 2015-03-19