FAQ about Managed Service for YDB
This page shows answers to the questions about Managed Service for YDB. For frequently asked questions about YDB, see the documentation
Managed Service for YDB databases in serverless mode
How do secondary and vector indexes impact the cost of a request?
Operations with indexes are estimated according to the same rules as operations with tables. They are reflected in the request statistics and included in the total indicators used to calculate the cost in request units (RUs). For more information, see the pricing policy for YDB API serverless mode.
When reading data from a table using an index, the request statistics will show the number of records read from the index and their size.
Secondary indexes
Adding a new row to a table creates a record in each existing secondary index. This action updates the statistics to reflect the increase in both the number of added records and the size of written data.
When you update a table row, the statistics will reflect the operations of deleting the old record and adding the new one for each secondary index that includes the updated fields.
When you delete a table row, the statistics will include the deletion of records from all secondary indexes of this table.
Vector indexes
For a single-vector request to an index of the vector_kmeans_tree
-
Navigating the index tree.
At each of thelevelstree levels,KMeansTreeSearchTopSize clusters (each containingclusterssubclusters) are selected from the existing clusters.
As a result, the total number of required readings at this stage is around . -
Processing final candidates.
At the lowest index tree level, all rows from the selected clusters get processed.
The number of readings at this stage is around (in a balanced tree, whereNis the total number of rows).
If you do not use a covering index , a row will be additionally read from the main table for each candidate record found via the index.
What does the RESOURCE_EXHAUSTED error mean?
This error means a limit has been reached.
Check the throughput in the YDB cluster settings and increase it, if required. If the issue persists after you increase the throughput limit or the quota is exceeded, contact support
What does the ThrottlingException error mean?
The error is related to the exceeding of the quota for RU (Request Unit) consumption per second.
You can change quotas for an individual database in its settings (see Updating serverless database parameters). If you find your cloud quota insufficient, contact support
To prevent users from unscheduled RU consumption, we recommend setting a limit on maximum consumption.