Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38132

Slow query enable needs session reconnections

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • N/A
    • Server
    • None

    Description

      Hello MariaDB Team,

      When we enable slow query logs, the connection sessions does not have it enabled. And it needs reconnection to log to slow query which should not be a proper design.
      Since the slow query log is a global variables, when it is turned ON, it should be enabled for all sessions including connected one.
      It should not require reconnection.

      Reproduction steps -
      1) Connect two mariadb sessions at same time with slow query logs to OFF
      2) In first session

      set global slow_query_log=ON;
      

      3) In another session check

      show variables like '%slow_query_log%';
      

      4) It shows off and no slow query gets logged from that session.

      It should log the query from all session and should not require reconnection.

      Regards,
      Yunus Shaikh.

      Attachments

        Activity

          People

            Unassigned Unassigned
            yunushaikh Yunus Shaikh
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.