QuestionQ23

VerifiedAnalyzing and optimizing technical and business processes

The database administration team has asked for your help improving the performance of its new database server running on Google Compute Engine. The database imports and normalizes its performance statistics and is built with MySQL running on Debian Linux. They have an n1-standard-8 virtual machine with 80 GB of SSD persistent disk.

What should they change to obtain better performance from this system?

Explanation

SSD Persistent Disk performance scales with disk size, up to the performance limits of the attached VM. Resizing the 80 GB SSD Persistent Disk to 500 GB increases the disk’s available IOPS and throughput, improving the database’s storage-intensive import and normalization operations.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!