Answer-first summary for fast verification
Answer: The GSI is throttling so you need to provision more RCU and WCU to the GSI
The GSI is throttling so you need to provision more RCU and WCU to the GSI DynamoDB supports two types of secondary indexes: Global secondary index — An index with a partition key and a sort key that can be different from those on the base table. A global secondary index is considered "global" because queries on the index can span all of the data in the base table, across all partitions. A global secondary index is stored in its own partition space away from the base table and scales separately from the base table. Local secondary index — An index that has the same partition key as the base table, but a different sort key. A local secondary index is "local" in the sense that every partition of a local secondary index is scoped to a base table partition that has the same partition key value.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your application has been successfully using a DynamoDB table for over a year without throttling issues, thanks to appropriately provisioned Read Capacity Units (RCUs) and Write Capacity Units (WCUs). Recently, you have introduced a secondary query type that necessitated the creation of a Local Secondary Index (LSI) and a Global Secondary Index (GSI) on a new table to meet this need. However, a month after implementing these indexes, the table is now experiencing throttling.
Upon examining the table's metrics, you can see that the provisioned RCU and WCU levels are still adequate. What could be causing the throttling?
A
Adding both an LSI and a GSI to a table is not recommended by AWS best practices as this is a known cause for creating throttles
B
The LSI is throttling so you need to provision more RCU and WCU to the LSI
C
The GSI is throttling so you need to provision more RCU and WCU to the GSI
D
Metrics are lagging in your CloudWatch dashboard and you should see the RCU and WCU peaking for the main table in a few minutes
No comments yet.