IOPS for GCE Persistent Disk volumes (which back Cloud SQL) scale with volume size: https://cloud.google.com/compute/docs/disks/performance#type...

(For "Local SSD" the IOPS are a function of the number of devices you attach)