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

performance_schema not to use md5 for digest

    XMLWordPrintable

Details

    Description

      Currently the performance schema uses md5 digests.

      A SHA256 hash is more modern and while the use doesn't require cryptographic security, its an easy enough change MySQL implementation.

      XXH3, added to MariaDB in MDEV-9826, Is being implemented as a much faster algorithm.

      Please note that the MariaDB PS DIGEST feature is not a security feature and is not meant to be used as such.
      MariaDB's current implementation is purely for query identification in statistics, not database activity monitoring etc.
      As such, a fast hashing algo like XXH3 is a significantly better choice than the slow SHA256.
      More generally, XXH3 is not a secure hash, and it should not be used for security purposes.

      Attachments

        Issue Links

          is part of

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25372 Deprecate SHA-1 algorithm from mariadb-server

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-26318 update P_S to 8.0.x

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-9826 better hash algorithms for PARTITION BY KEY

          • Major - Major loss of function.
          • Closed
          has action item

          DOCS-6054 Loading...

          Activity

            People

              Roel Roel Van de Paar
              danblack Daniel Black
              Sergei Golubchik Sergei Golubchik
              Votes:
              3 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.