Details

    • Task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.6.0
    • OTHER
    • None

    Description

      Distribute sys schema with MariaDB.

      Quite possibly it'll need some changes to work with MariaDB 10.6, so we'll need to clone the repo and apply our changes.
      In MySQL it's part of mysqld binary (for --initialize, I suppose). The repo is small, we can just include it in the server repo, as it's not a separate independent project really.

      Attachments

        Issue Links

          Activity

            danblack Daniel Black added a comment -

            I did only provide oli a cross version compatible solution 2 days ago https://github.com/FromDual/mariadb-sys/pull/2

            danblack Daniel Black added a comment - I did only provide oli a cross version compatible solution 2 days ago https://github.com/FromDual/mariadb-sys/pull/2

            Alexey, please review the current bb-10.6-sysschema

            wlad Vladislav Vaintroub added a comment - Alexey, please review the current bb-10.6-sysschema
            midenok Aleksey Midenkov added a comment - - edited

            There should be server option to switch SYS schema initialization on/off. Other test suites should run server without SYS schema and their results should not be affected. We do not want to enable SYS schema by default, do we? Users who need it will add corresponding option to their config files. Users who don't need it will not be dissatisfied by an unwanted entry in SHOW DATABASES.

            Please tweak a little bit README.md file to reflect current state of things regarding the installation.

            Otherwise looks good to me.

            midenok Aleksey Midenkov added a comment - - edited There should be server option to switch SYS schema initialization on/off. Other test suites should run server without SYS schema and their results should not be affected. We do not want to enable SYS schema by default, do we? Users who need it will add corresponding option to their config files. Users who don't need it will not be dissatisfied by an unwanted entry in SHOW DATABASES. Please tweak a little bit README.md file to reflect current state of things regarding the installation. Otherwise looks good to me.
            wlad Vladislav Vaintroub added a comment - - edited

            We do want to enable sys schema by default, just like others do. There is no way to disable it in MySQL 8.0

            Let me quote https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html
            "
            For new installations, the sys schema is installed by default during data directory initialization if you use mysqld with the --initialize or --initialize-insecure option. If this is not desired, you can drop the sys schema manually after initialization if it is unneeded."

            wlad Vladislav Vaintroub added a comment - - edited We do want to enable sys schema by default, just like others do. There is no way to disable it in MySQL 8.0 Let me quote https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html " For new installations, the sys schema is installed by default during data directory initialization if you use mysqld with the --initialize or --initialize-insecure option. If this is not desired, you can drop the sys schema manually after initialization if it is unneeded."
            ralf.gebhardt Ralf Gebhardt added a comment -

            The performance schema plugin is loaded by default with load option "FORCED", so it makes sense to have the sys schema installed by default, too

            ralf.gebhardt Ralf Gebhardt added a comment - The performance schema plugin is loaded by default with load option "FORCED", so it makes sense to have the sys schema installed by default, too

            People

              wlad Vladislav Vaintroub
              serg Sergei Golubchik
              Votes:
              21 Vote for this issue
              Watchers:
              26 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.