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

INPLACE ADD|DROP partitions in MyRocks

Details

    • New Feature
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 8.0.x, Not 5.6.x, Not 5.7.x
    • 8.0.25-15 (Q2 2021)
    • MyRocks
    • None

    Description

      from https://www.percona.com/blog/2020/08/04/the-road-story-of-a-myrocks-mariadb-migration/#comment-10972703

       

       

      ALTER TABLE mytable ADD PARTITION (PARTITION p8 VALUES LESS THAN (8000000))’;
      from InnoDB master to MyRocks replica, I get:
      [ERROR] [MY-010584] [Repl] Slave SQL for channel ”: Error ‘Got error 10 ‘Operation aborted: Failed to acquire lock due to rocksdb_max_row_locks limit’ from ROCKSDB’ on query. Default database: ‘xyz’. Query: ‘ALTER TABLE xyz.mytable ADD PARTITION (PARTITION p8 VALUES LESS THAN (8000000))’, Error_code: MY-001296
      [Warning] [MY-010584] [Repl] Slave: Inplace partition altering is not supported Error_code: MY-000138
      1.) is there any chance to execute ALTER TABLE through replication?
      2.) is there any plan to support ADD/DROP PARTITION without rebuilding the whole table?
      For us, this is a show stopper. I really wanted to use MyRocks, but I can’t
      

       

      Attachments

        Issue Links

          Activity

            People

              przemyslaw.skibinski Przemyslaw Skibinski
              vadimtk Vadim Tkachenko
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist