Ultimate access to all questions.
The database administration team has asked you to help them improve the performance of their new database server running on Google Compute Engine. The database is used for importing and normalizing their performance statistics and is built with MySQL running on Debian Linux. Currently, they use an n1-standard-8 virtual machine that comes with 8 vCPUs and 30 GB of memory, along with an 80 GB SSD persistent disk. Considering both hardware and software optimizations, what should they change to get better performance from this system?