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

Engine cannot be altered to S3 from MyISAM for a 110Gb table.

    XMLWordPrintable

    Details

      Description

      Branch: 10.3-enterprise
      Commit: e8fa172cc11366d1c3938295771cbe5184d12c17
      Version: 10.3.16-MariaDB

      > CREATE TABLE BigTable (id int, b int, PRIMARY KEY (id)) engine=MyISAM
      > insert into BigTable select seq,-seq from seq_1_to_99
      > insert into BigTable select seq,-seq from seq_100_to_2000000000
      Query OK, 1999999901 rows affected (1 hour 28 min 2.370 sec)
      Records: 1999999901  Duplicates: 0  Warnings: 0
      > select count(*) from BigTable;
      | count(*)   |
      +------------+
      | 2000000000 |
       
      ALTER TABLE BigTable engine=s3;
      Stage: 1 of 2 'Copy to tmp table'   98.7% of stage done
      Stage: 2 of 2 'Repair by sorting'    100% of stage done
      

      The client is hanging with this 'Repair by sorting' last message.
      I run another client. And it is also hanging:

      > use test;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
      

      The appropriate 'data' directory is about 110Gb size.
      Have not found anything related in the logs.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stepan.patryshev Stepan Patryshev
              Reporter:
              stepan.patryshev Stepan Patryshev
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: