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

Implement hidden PK for RBR of no-unique key table

    XMLWordPrintable

Details

    Description

      Performance of row event applying on no-unique key table is inferior and degrades
      with growing size of the table.
      This task aims at replacement of table scanning with key lookup, and such key - or a hidden "PK" - would be created
      automatically. It may not be visible to the user as a part of the table def like the row id of Innodb is never exposed.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-21181 Automatic invisible primary key

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-28412 Introduce sql_require_primary_key

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30557 Adding invisible SERIAL column primary key on slave break row base replication

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. MDEV-19506 Remove the global sequence DICT_HDR_ROW_ID for DB_ROW_ID

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

          Task - A task that needs to be done. MDEV-24830 Write a warning to error log if Galera replicates InnoDB table with no primary key

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25551 Assertion `mode_ == m_local || transaction_.is_streaming()` failed in BF abort

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30430 Enabling system versioning on tables without primary key breaks replication

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link MySQL Invisible Column: part II

          Activity

            People

              Elkin Andrei Elkin
              Elkin Andrei Elkin
              Votes:
              1 Vote for this issue
              Watchers:
              9 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.