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

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.0
        • Fix Version/s: 10.0.4
        • Component/s: None
        • Labels:
          None
        • Environment:
          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

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                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.

                Show
                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.
                Hide
                Permalink
                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.

                Show
                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.
                Hide
                Permalink
                timour Timour Katchaounov 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

                Show
                timour Timour Katchaounov 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
                Hide
                Permalink
                timour Timour Katchaounov added a comment -

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

                Show
                timour Timour Katchaounov 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

                  • Assignee:
                    timour Timour Katchaounov
                    Reporter:
                    erkules erkan yanar
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 2 days, 3 hours
                      2d 3h