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

merge 5.7 innodb

Details

    • 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2, 10.1.17-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4

    Description

      merge 5.7 innodb and xtradb, preferably both at the same time.

      Attachments

        1. i5714.diff
          7 kB
        2. i579.diff
          14 kB

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-6697 Improve foreign keys warnings/errors

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-9820 global option to enable page compression for all new tables

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11000 Compatibility issues between 10.2 and MySQL 5.7

          • Major - Major loss of function.
          • Closed
          includes

          Task - A task that needs to be done. MDEV-4697 UPDATE_TIME field for XtraDB / InnoDB

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-6614 Merge InnoDB: fix index->lock contention from MySQL 5.7

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-7455 Speed up crash recovery

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-8923 [PATCH] port innodb_buffer_pool_dump_pct + have buffer pool dump and reload set as default

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-9311 Make innodb_buffer_pool_size dynamic

          • 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-9330 Make 5.7 InnoDB compile with MariaDB 10.2

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9476 Fix merge errors on merge 5.7 InnoDB to MariaDB 10.2

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

          Task - A task that needs to be done. MDEV-15223 Document that InnoDB's native partitioning was not merged into MariaDB

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-19294 Remove TABLESPACE-related commands

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20562 btr_cur_open_at_rnd_pos() fails to return error for corrupted page

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10813 Clean-up InnoDB atomics, memory barriers and mutexes

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

          Task - A task that needs to be done. MDEV-12309 Test migration from MySQL 5.7 with named tablespaces to MariaDB 10.2

          • Major - Major loss of function.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Fix Version/s 10.1.x-Beta [ 15801 ]
            Fix Version/s 10.1.0 [ 12200 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1.0 [ 12200 ]
            Fix Version/s 10.1.x-Beta [ 15801 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ]
            dbart Daniel Bartholomew made changes -
            Fix Version/s 10.1.1 [ 16100 ]
            Fix Version/s 10.1.0 [ 12200 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 38929 ] MariaDB v2 [ 42495 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1.x-Beta [ 15801 ]
            Fix Version/s 10.1.1 [ 16100 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.1.2 [ 15801 ]
            serg Sergei Golubchik made changes -
            GeoffMontee Geoff Montee (Inactive) added a comment -

            Will this merge include online truncation of InnoDB undo tablespaces? Would that be included in 10.1 or 10.2?

            http://mysqlserverteam.com/online-truncate-of-innodb-undo-tablespaces/

            GeoffMontee Geoff Montee (Inactive) added a comment - Will this merge include online truncation of InnoDB undo tablespaces? Would that be included in 10.1 or 10.2? http://mysqlserverteam.com/online-truncate-of-innodb-undo-tablespaces/
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 42495 ] MariaDB v3 [ 61460 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1 [ 16100 ]
            serg Sergei Golubchik made changes -
            svoj Sergey Vojtovich added a comment -

            Please note that 5.7.9 InnoDB is unstable on Power8. We'll likely have to fix it again.

            svoj Sergey Vojtovich added a comment - Please note that 5.7.9 InnoDB is unstable on Power8. We'll likely have to fix it again.
            serg Sergei Golubchik added a comment -

            Question: what to do with Boost.Geometry

            serg Sergei Golubchik added a comment - Question: what to do with Boost.Geometry
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1 [ 21 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1 [ 21 ] 10.2.0-1, 5.5.47-1 [ 21, 22 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1, 5.5.47-1 [ 21, 22 ] 10.2.0-1 [ 21 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            serg Sergei Golubchik made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            jplindst Jan Lindström (Inactive) made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1 [ 21 ] 10.2.0-1, 10.2.0-8 [ 21, 41 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1, 10.2.0-8 [ 21, 41 ] 10.2.0-1, 10.2.0-8, 10.2.0-9 [ 21, 41, 43 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            serg Sergei Golubchik made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1, 10.2.0-8, 10.2.0-9 [ 21, 41, 43 ] 10.2.0-1, 10.2.0-8, 10.2.0-9, 10.2.0-10 [ 21, 41, 43, 46 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1, 10.2.0-8, 10.2.0-9, 10.2.0-10 [ 21, 41, 43, 46 ] 10.2.0-1, 10.2.0-8, 10.2.0-9 [ 21, 41, 43 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            danblack Daniel Black made changes -
            danblack Daniel Black added a comment -

            svoj, I've started to look for them. https://github.com/linux-on-ibm-power/mysql-server/tree/5.7-POWER_FIXES has the ones I've need to make 5.7 stable though honestly most are ones you've found already and fixed.

            http://bugs.mysql.com/bug.php?id=79378 might be one that applies though I haven't reproduced it on MariaDB yet.

            danblack Daniel Black added a comment - svoj , I've started to look for them. https://github.com/linux-on-ibm-power/mysql-server/tree/5.7-POWER_FIXES has the ones I've need to make 5.7 stable though honestly most are ones you've found already and fixed. http://bugs.mysql.com/bug.php?id=79378 might be one that applies though I haven't reproduced it on MariaDB yet.
            svoj Sergey Vojtovich added a comment -

            danblack, thanks for looking for them. Let's hope these fixes will be accepted by mysql.

            svoj Sergey Vojtovich added a comment - danblack , thanks for looking for them. Let's hope these fixes will be accepted by mysql.
            danblack Daniel Black made changes -
            GeoffMontee Geoff Montee (Inactive) added a comment -

            Will this merge include the fix for this upstream bug?

            https://jira.mariadb.org/browse/MDEV-4697

            GeoffMontee Geoff Montee (Inactive) added a comment - Will this merge include the fix for this upstream bug? https://jira.mariadb.org/browse/MDEV-4697
            serg Sergei Golubchik made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1, 10.2.0-8, 10.2.0-9 [ 21, 41, 43 ] 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.51 & 10.2 [ 21, 41, 43, 85 ]
            GieltjE Michiel Hazelhof added a comment -

            There seem to be quite a few improvements noted in: https://blogs.oracle.com/mysqlinnodb/entry/innodb_5_7_performance_improvements
            Are all these planned to be included?

            GieltjE Michiel Hazelhof added a comment - There seem to be quite a few improvements noted in: https://blogs.oracle.com/mysqlinnodb/entry/innodb_5_7_performance_improvements Are all these planned to be included?
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2 [ 21, 41, 43, 85 ] 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2, 10.1.17-1 [ 21, 41, 43, 85, 87 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2, 10.1.17-1 [ 21, 41, 43, 85, 87 ] 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2, 10.1.17-1, 10.2.2-1 [ 21, 41, 43, 85, 87, 89 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2, 10.1.17-1, 10.2.2-1 [ 21, 41, 43, 85, 87, 89 ] 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2, 10.1.17-1, 10.2.2-1, 10.2.2-2 [ 21, 41, 43, 85, 87, 89, 92 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2, 10.1.17-1, 10.2.2-1, 10.2.2-2 [ 21, 41, 43, 85, 87, 89, 92 ] 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2, 10.1.17-1, 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 21, 41, 43, 85, 87, 89, 92, 94 ]
            jplindst Jan Lindström (Inactive) made changes -
            Attachment i579.diff [ 42505 ]
            Attachment i5714.diff [ 42506 ]
            jplindst Jan Lindström (Inactive) added a comment -

            Attached server changes I have done while merged 5.7.9 and 5.7.14.

            jplindst Jan Lindström (Inactive) added a comment - Attached server changes I have done while merged 5.7.9 and 5.7.14.
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2, 10.1.17-1, 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 21, 41, 43, 85, 87, 89, 92, 94 ] 10.2.0-1, 10.2.0-8, 10.2.0-9, 5.5.51 & 10.2.2, 10.1.17-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4 [ 21, 41, 43, 85, 87, 89, 92, 94, 96 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Jan Lindström [ jplindst ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            serg Sergei Golubchik added a comment -

            GieltjE, most will be. All changes inside InnoDB will be included. If there will be optimizations that don't work without corresponding server changes — they might not work (we will merge some correspondent server changes, but not all).

            serg Sergei Golubchik added a comment - GieltjE , most will be. All changes inside InnoDB will be included. If there will be optimizations that don't work without corresponding server changes — they might not work (we will merge some correspondent server changes, but not all).
            svoj Sergey Vojtovich made changes -
            serg Sergei Golubchik made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            Fix Version/s 10.2.2 [ 22013 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            jplindst Jan Lindström (Inactive) made changes -
            Summary merge 5.7 innodb and xtradb merge 5.7 innodb
            elenst Elena Stepanova made changes -
            GeoffMontee Geoff Montee (Inactive) added a comment -

            Did this merge include "ALTER TABLE ...

            {DISCARD|IMPORT}

            PARTITION" for InnoDB tables?

            https://jira.mariadb.org/browse/MDEV-10568

            GeoffMontee Geoff Montee (Inactive) added a comment - Did this merge include "ALTER TABLE ... {DISCARD|IMPORT} PARTITION" for InnoDB tables? https://jira.mariadb.org/browse/MDEV-10568
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 61460 ] MariaDB v4 [ 132322 ]

            People

              jplindst Jan Lindström (Inactive)
              serg Sergei Golubchik
              Votes:
              10 Vote for this issue
              Watchers:
              16 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.