How to stop the current Index creation Operation in DynamoDB?

Question

I am try to add an index in DynamoDB table having size around 200MB.

its took almost 15 hours and is still running. I have checked that i have given the low read/write IOPS for index. Now i want to increase IOPS and restart the index creation activity.

Any idea - If its possible to cancel the current operation ?

Thanks

F_SO_K · Accepted Answer · 2018-05-03T07:48:52.587

4

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GSI.OnlineOps.html

You cannot cancel an in-flight global secondary index creation.

But on the plus side you are incorrect that you need to cancel the operation to change the throughput capacity.

If the provisioned write throughput setting on the index is too low, the index build will take longer to complete. To shorten the time it takes to build a new global secondary index, you can increase its provisioned write capacity temporarily.

EDIT:

After the index has been created, you should set its provisioned write capacity to reflect the normal usage of your application.

edited May 03 '18 at 07:48

answered May 03 '18 at 07:39

F_SO_K

13,640
5
54
83

is the temporarily increased capacity works at runtime ? – Aman Aggarwal May 03 '18 at 07:42
See edit. You increase index capacity during creation, the index build runs faster, afterward you change the capacity again to match your operational use. – F_SO_K May 03 '18 at 07:49

score 1 · Answer 2 · answered Apr 01 '19 at 22:10

You can adjust the read capacity units and write capacity units values of a currently running index creation using the AWS CLI:

Create a file named gsi-update-MyIndex.json with the following content:

[
  {
    "Update": {
      "IndexName": "BluekaiID-index",
      "ProvisionedThroughput": {
        "ReadCapacityUnits": 1,
        "WriteCapacityUnits": 100
      }
    }
  }
]

Then, execute the following command:

aws dynamodb update-table --table-name mytablename --global-secondary-index-updates file://gsi-update-MyIndex.json

You'll probably want to bump up the values on the main table for a minute, too with the following command:

aws dynamodb update-table --table-name mytablename --provisioned-throughput ReadCapacityUnits=100,WriteCapacityUnits=1

Once your index creation is done and loaded, rerun the commands above with smaller values to fit your normal traffic.

You can do this in the console too. – Francis Upton IV Jul 04 '20 at 11:03 — Francis Upton IV, Jul 04 '20 at 11:03

How to stop the current Index creation Operation in DynamoDB?

2 Answers2