大网数据广告活动
服务器运维问答

How to increase google SQL read ops limit?

· 52CE 我爱测

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. Thank you.

问题原文

原帖链接 · user957781 · CC BY-SA 4.0

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.

Thank you.

已采纳解答

原帖链接 · John Hanley · CC BY-SA 4.0

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

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2022-03-08)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。