Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4892

Re-implement expanded fast index creation in 8.0 DD

    XMLWordPrintable

Details

    • Admin & Maintenance Task
    • Status: Done
    • Critical
    • Resolution: Fixed
    • 8.0.x, Not 5.7.x
    • 8.0.15-5
    • None
    • None

    Description

      A straightforward port from 5.7 does not work due the need of having to pass valid dd::Table objects around, including for intermediate stages of ALTER TABLE. Thus, re-implement in proper 8.0 data dictionary way.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. PS-5403 Assertion failure: handler0alter.cc:3703:table->has_instant_cols()

          • Critical - Blocks Percona development and/or testing work.
          • Done

          Admin & Maintenance Task - For Percona Internal usage only PS-5401 QA For PS-4892 (Re-implementation of expanded fast index creation in 8.0 DD)

          • Medium - Minor loss of function, or other problem where easy workaround is present.
          • Done
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. PS-4803 [PS8QA] ALTER TABLE ... ADD INDEX ... LOCK crash | handle_fatal_signal (sig=11) in dd_table_has_instant_cols

          • Critical - Blocks Percona development and/or testing work.
          • Done

          Bug - A problem which impairs or prevents the functions of the product. PS-4884 [PS8QA] Enabling expand_fast_index_creation leads to handle_fatal_signal (sig=11) in dd_write_index

          • Critical - Blocks Percona development and/or testing work.
          • Done

          Bug - A problem which impairs or prevents the functions of the product. PS-4886 [PS8QA] expand_fast_index_creation sig11 in opt, sig6 (Assertion failure: handler0alter.cc:1114:old_dd_tab != __null) on debug

          • Critical - Blocks Percona development and/or testing work.
          • Done

          Bug - A problem which impairs or prevents the functions of the product. PS-4928 [PS8QA] handle_fatal_signal (sig=11) in ha_innopart::prepare_inplace_alter_table

          • Critical - Blocks Percona development and/or testing work.
          • Done
          relates to

          Bug - A problem which impairs or prevents the functions of the product. PS-5195 Possible to enable expand_fast_index_creation variable when functionality not implemented

          • High - Crashes, loss of data, severe memory leak.
          • Done

          Bug - A problem which impairs or prevents the functions of the product. PS-6014 ALTER TABLE PARTITION BY RANGE crashes mysql when expand_fast_index_creation=1

          • Medium - 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. PS-5124 Disable expanded fast index creation option until PS-4892 is implemented

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

          Activity

            People

              satya.bodapati Satya Bodapati
              laurynas.biveinis Laurynas Biveinis (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 week, 4 hours, 15 minutes
                  1w 4h 15m

                  Smart Checklist