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
          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.
          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) 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.

          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.