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

Better table discovery

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.2
    • None

    Description

      Table discovery, that was created for NDB, works by frm shipping, the engine needs to provide a correct frm file for discovery to work. This can be made much more usable for the engine, if it would be able to provide a filled TABLE_SHARE structure, or an SQL CREATE TABLE statement (or an frm, for backward compatibility).

      Also, there should be a status variable to profile table definition cache misses, that caused a table to be discovered.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-4261 Use tabledef_version in TABLE_SHARE::get_table_ref_version()

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

          Task - A task that needs to be done. MDEV-4262 P_S discovery

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-4263 allow automatic table re-discover

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4441 DROP DATABASE with a newly created ARCHIVE table does not work

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4449 SEQUENCE depends on TEST_SQL_DISCOVERY for discovering tables upon DDL

          • 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-4466 Partitioned Aria table created by a previous version is recognized as TEST_SQL_DISCOVERY

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4467 Assertion `error != 0' fails on select from a FEDERATED table which points at SEQUENCE table

          • 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-656 LP:771934 - archive discovery very slow

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

          Task - A task that needs to be done. MDEV-4146 CONNECT engine

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-4259 transactional DDL

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-4260 Don't create frm files for temporary tables

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4442 Definition of ARCHIVE table is not re-discovered after replacing ARZ file

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

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Assignee Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.2 [ 11900 ]
            serg Sergei Golubchik made changes -
            Description Table discovery, that was created for NDB, works by frm shipping, the engine needs to provide a correct frm file for discovery to work. This can be made much more usable for the engine, if it would be able to provide a filled TABLE_SHARE structure, or an SQL {{CREATE TABLE}} statement (or an frm, for backward compatibility). Table discovery, that was created for NDB, works by frm shipping, the engine needs to provide a correct frm file for discovery to work. This can be made much more usable for the engine, if it would be able to provide a filled TABLE_SHARE structure, or an SQL {{CREATE TABLE}} statement (or an frm, for backward compatibility).

            Also, there should be a status variable to profile table definition cache misses, that caused a table to be discovered.
            serg Sergei Golubchik made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 24708 ] MariaDB v2 [ 45008 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 45008 ] MariaDB v3 [ 65520 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 65520 ] MariaDB v4 [ 132025 ]

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.