I recently set up a free CockroachDB Serverless cluster on CockroachCloud. It's been really great so far, but sometimes there are random spikes in Request Units even though the amount of SQL statements doesn't increase at all. Here's a screenshot of the two graphs in the cluster management page, it illustrates pretty well what I mean. I would really appreciate some help on how I could eliminate these spikes because CockroachCloud has some limits on free usage. That being said, I'm still fairly new to CockroachDB, so I might be missing something obvious.
Random spikes in usage (CockroachCloud Serverless)
347 Views Asked by Gadget At
1
There are 1 best solutions below
Related Questions in COCKROACHDB
- cockroach DB issue to start : Fail to initialize the node: unable to load named timezone
- Spring-boot vs Postgres vs Cockroach -> The fastpath function lo_creat is unknown
- Searching a large string in Database
- Nestjs: Loading jsonb from CockroachDB with TypeOrm turns date into string
- Compare two arrays using QueryDSL
- How does one update the version of Hibernate that SCDF uses?
- CockroachDB read transactions
- CockroachDB is generating big ids when records are inserted via spring
- How to ignore getaddrinfo ENOTFOUND in NestJS (using TypeORM)
- How to change my region on CockroachDB Cloud?
- Using cockroachdb / postgresql in an iOS swift app
- Why is the slice not passed to the pg array?
- Symfony database connection to CockroachDB
- How does HLC hybrid logical clock solve Linearizability and Serializability in distributed transaction?
- Insert dataframes to cockroachdb table
Related Questions in COCKROACHCLOUD
- How to change my region on CockroachDB Cloud?
- Using cockroachdb / postgresql in an iOS swift app
- Why is my CockroachDB disk usage not decreasing?
- encapsulating a Drop and Add constraint in a transaction
- Can't connect to CockroachCloud Free (beta) Cluster from a Spring Data R2DBC driver
- can not connect to cockroachdb invalid cluster name
- Accessing cockroachcloud db from python app running in Heroku
- Alter the definition of the Stored Computed Column in CockroachCloud
- Alternative For Stored Procedures In cockroachDB
- Is it possible to perform evelope encryption in CockroachDB?
- using sql regrex_replace to replace every word that starts with a # symbol with mask(word)
- Cannot decommission cockroachdb node
- Cockroachdb: Retrieving cluster info: failed Error: 401 Unauthorized
- Random spikes in usage (CockroachCloud Serverless)
- How do I connect DBeaver to CockroachDB Serverless?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You are likely performing enough mutations on your data to trigger automatic statistics collection as a background process. By default when 20% or more rows are modified in a table, CockroachDB will trigger a statistics refresh. The statistics are used by the optimizer to create more efficient query plans.
Your SQL Statements graph indicates that almost all your operations are inserts. That many inserts is almost certainly triggering stats collection. While you can turn off stats collection, the optimizer will then be using stale data to calculate query plans, potentially causing performance problems.
The occasional spikes in your Request Unit graph are above the 100 RUs per second baseline, but the rest of the time you are well below 100 RUs per second. That means you are accumulating RUs most of the time, and that (plus the initial 10 million RU allocation) should cover the bursts.
I added a FAQ entry to the Serverless docs covering this.