Score:0

How to increase google SQL read ops limit?

es flag

I'm currently using Google Cloud SQL for MySQL but when I do a heavy query it gets read ops above the limit and then the query gets cancelled. How to increase this read ops limit? I'm using a SSD with 50 GB of storage.

read ops limit

Thank you.

ua flag
Let's work on shrinking the data or adding a useful index or reformulating the query or ... -- in order to avoid the limit. Show us the query, its `EXPLAIN` and `SHOW CREATE TABLE`.
John Hanley avatar
cn flag
If the quota is for persistent disk IOPS then increase the size of the disk to increase the read quota. Otherwise, clarify your question with more details.
Score:0
cn flag

Based upon your graph, your disk read quota is about 1500 IOPS.

Persistent disk performance is related to provisioned size. Google Cloud SQL SSD Zonal and Regional Persistent Disks receive 30 read and 30 write IOPS per GB.

For a 50 GB SSD PS - 50 * 30 = 1500.

To increase the read and write performance, resize the disk larger. This is easily performed in the Google Cloud Console GUI by editing the instance configuration Storage capacity. Resizing does not cause downtime.

The chart shows a peak of about 3500 IOPS. Resize the 50 GB SSD to 120 GB.

Note: disks also have a quota for MB/sec. SSD has a quota of 0.48 MB/sec per GB. Increasing the disk size will also increase the speed of data transfers.

Block Storage Performance

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.