Skip Menu |

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 119122
Status: resolved
Priority: 0/
Queue: DBD-mysql

Owner: Nobody in particular
Requestors: Daniel.van.Eeden [...]

Bug Information
Severity: Wishlist
Broken in: (no value)
Fixed in: (no value)

Subject: RFE: Support for tracking session information
Date: Sun, 4 Dec 2016 13:19:05 +0100
To: bug-DBD-mysql [...]
From: Daniël van Eeden <Daniel.van.Eeden [...]>
Hello, In MySQL 5.7 it is possible to enable tracking of certain session attributes. These are the global variables which control that: session_track_gtids session_track_schema session_track_state_change session_track_system_variables From the MySQL C API these can be used to get access to the data: mysql_session_track_get_first() mysql_session_track_get_next() The main use case I see is to insert a record on a master and then get the GTID back which then can be used with WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() on the replica to ensure the row did replicate to the replica. The other way of doing this would be to @@global.gtid_executed, but that needs an extra roundtrip. So it would be nice if DBD::mysql would expose the session tracking data. Daniël

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to