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

3 tables missing in P_S of MariaDB 10.0 compared to MySQL 5.6.9

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.0
    • 10.0.4
    • None
    • None
    • na

    Description

      MariaDB misses 3 tables in P_S compared to MySQL
      The most important is host_cache.
      And the less important.
      session_account_connect_attrs
      and
      session_connect_attrs

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          erkules erkan yanar created issue -
          elenst Elena Stepanova added a comment -

          For the record, that's exactly what 10.0.0 release notes say (https://kb.askmonty.org/en/mariadb-1000-release-notes/):
          "Performance schema — from MySQL 5.6.5 (without host cache)"

          I believe the other two tables were added later, in 5.6.6 or so.

          elenst Elena Stepanova added a comment - For the record, that's exactly what 10.0.0 release notes say ( https://kb.askmonty.org/en/mariadb-1000-release-notes/): "Performance schema — from MySQL 5.6.5 (without host cache)" I believe the other two tables were added later, in 5.6.6 or so.
          elenst Elena Stepanova added a comment -

          I'm setting Fix version to 10.0.2 assigning to Monty just so it's on somebody's radar, while in fact it should be fixed automatically by the next merge with higher versions of P_S.

          elenst Elena Stepanova added a comment - I'm setting Fix version to 10.0.2 assigning to Monty just so it's on somebody's radar, while in fact it should be fixed automatically by the next merge with higher versions of P_S.
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Fix Version/s 10.0.2 [ 11900 ]
          Assignee Michael Widenius [ monty ]
          serg Sergei Golubchik made changes -
          Assignee Michael Widenius [ monty ] Sergei Golubchik [ serg ]
          serg Sergei Golubchik made changes -
          Priority Minor [ 4 ] Major [ 3 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Michael Widenius [ monty ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.3 [ 12900 ]
          Fix Version/s 10.0.2 [ 11900 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.4 [ 13101 ]
          Fix Version/s 10.0.3 [ 12900 ]
          timour Timour Katchaounov (Inactive) made changes -
          Assignee Michael Widenius [ monty ] Timour Katchaounov [ timour ]
          timour Timour Katchaounov (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          timour Timour Katchaounov (Inactive) added a comment -

          Host cache table:
          http://dev.mysql.com/doc/refman/5.6/en/host-cache-table.html
          http://dev.mysql.com/worklog/task/?id=5259

          timour Timour Katchaounov (Inactive) added a comment - Host cache table: http://dev.mysql.com/doc/refman/5.6/en/host-cache-table.html http://dev.mysql.com/worklog/task/?id=5259
          timour Timour Katchaounov (Inactive) made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          timour Timour Katchaounov (Inactive) added a comment -

          The host_cache table was merged locally. It will be pushed together with all remaining PS changes on the server side.

          timour Timour Katchaounov (Inactive) added a comment - The host_cache table was merged locally. It will be pushed together with all remaining PS changes on the server side.
          timour Timour Katchaounov (Inactive) made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          timour Timour Katchaounov (Inactive) made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          timour Timour Katchaounov (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 25932 ] MariaDB v2 [ 42388 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 42388 ] MariaDB v3 [ 61317 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 61317 ] MariaDB v4 [ 146348 ]

          People

            timour Timour Katchaounov (Inactive)
            erkules erkan yanar
            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.