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

Mariadb default for performance_schema differs from MySQL 5.6.x

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.0
        • Fix Version/s: 10.0.5
        • Component/s: None
        • Labels:
          None
        • Environment:
          na

          Description

          MySQL changed the default for performance_schema from 5.5 to 5.6 from OFF to ON.MariaDB has the MySQL 5.5 behavior having performance_schema=OFF as default.
          So MariaDB 10.0 is not a drop-in replacement for MySQL 5.6

            Gliffy Diagrams

              Attachments

                Issue Links

                is blocked by

                Task - A task that needs to be done. MDEV-3932 5.6 merge

                • Blocker - Blocks development and/or testing work, production could not run.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  I think it was enabled by default in 5.6.6, while 10.0.0 is on 5.6.5 PS-wise.

                  Show
                  elenst Elena Stepanova added a comment - I think it was enabled by default in 5.6.6, while 10.0.0 is on 5.6.5 PS-wise.
                  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 probably 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 probably be fixed automatically by the next merge with higher versions of P_S.
                  Hide
                  Permalink
                  sanja Oleksandr Byelkin added a comment -

                  Performance schema looks like enabled (probably merged with automatic size). I'll check it as soon as server will be build.

                  Show
                  sanja Oleksandr Byelkin added a comment - Performance schema looks like enabled (probably merged with automatic size). I'll check it as soon as server will be build.
                  Hide
                  Permalink
                  sanja Oleksandr Byelkin added a comment -

                  I checked that now in 10.0 performance_schema is ON by default.

                  Show
                  sanja Oleksandr Byelkin added a comment - I checked that now in 10.0 performance_schema is ON by default.

                    People

                    • Assignee:
                      sanja Oleksandr Byelkin
                      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 - 1 hour
                        1h
                        Remaining:
                        Remaining Estimate - 1 hour
                        1h
                        Logged:
                        Time Spent - Not Specified
                        Not Specified