Search code examples
google-app-enginegoogle-cloud-sql

Change Global isolation level in google clould SQL


I need to change the isolation level in the google cloud SQL , I searched a lot , but could not find it any where When i did

SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED

It gets changed , but only for that session and not for global , ie all other subsequent are not changed.

Thanks


Solution

  • The ISOLATION LEVEL is reset every time an instance warms up . so the only option now is to set it every time you create a connection