Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-10050

use READ-COMMITTED transaction isolation level in MySQL as with others

    XMLWordPrintable

Details

    • Task
    • Resolution: Unresolved
    • Major
    • SaaS
    • SaaS
    • None
    • None
    • False
    • None
    • False
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started

    Description

      Ideally we would use READ COMMITTED transaction isolation level on MySQL as well which defaults to REPEATABLE READ. The other 2 supported databases already default to READ COMMITTED. REPEATABLE READ doesn't seem to enhance operation, rather it is slower and even might be harmful when having code like:

      if object.value = check
        object.another_value = something
      end
      

      Update: Use https://github.com/brianmario/mysql2#initial-command-on-connect-and-reconnect

      – old info below –

      We can monkey patch MySQL2 adapter, some ideas:
      https://stackoverflow.com/a/34432139/520567

      Or just hook to the `checkout` connection adapter hook, some ideas:
      https://stackoverflow.com/a/57547710/520567

      Or check what we have about transactions already in
      https://github.com/3scale/porta/blob/master/app/lib/api_authentication/by_access_token.rb

      Attachments

        Activity

          People

            Unassigned Unassigned
            akostadi1@redhat.com Aleksandar Kostadinov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: