Solved: mysql

comgen_technolo · 03-28-2022 08:51 AM

Hi, i am going to use mysql for my app, i would like to know what is the best recommended CPU's for mysql in GCP?

Joseph_Seddik

I’d say the defining factor is memory rather than CPU and this in turn depends on various factors. How large is your db dump file? How much of your db should be in memory (InnoDB buffer size)? How many queries you will be launching per minute? Do you have object caching mechanisms? What would be an acceptable response time?

If you are not sure about the answers of these questions or if you just want the best response times and cost is a secondary factor then go for a higher memory (which comes with a higher CPU). Otherwise, you might want to start at a lower configuration, benchmark, and increase when needed.

View solution in original post

Joseph_Seddik

I’d say the defining factor is memory rather than CPU and this in turn depends on various factors. How large is your db dump file? How much of your db should be in memory (InnoDB buffer size)? How many queries you will be launching per minute? Do you have object caching mechanisms? What would be an acceptable response time?

If you are not sure about the answers of these questions or if you just want the best response times and cost is a secondary factor then go for a higher memory (which comes with a higher CPU). Otherwise, you might want to start at a lower configuration, benchmark, and increase when needed.