Database Administration (MOSC)

MOSC Banner

Is there an example of Connection Sharing released in MySQL Router 8.0.32

edited Jan 26, 2023 2:23AM in Database Administration (MOSC) 1 commentAnswered ✓

The Connection Sharing document states that SQL statements that rely on the previous session state will not work when Connection Sharing is enabled unless it is inside the transaction.


It also does not support user variables, temporary tables, or prepared statements, and even transactions and LOCK TABLES do not support Connection Sharing until they are closed or unlocked.


So, what do they share? I would appreciate it if you could let me know if there is a suitable example.


Thank you

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center