Usually most of the ram is caches or innodb buffer pool size, I doubt you need 14G to serve 40G. I recommend picking a reasonable sized instance, and running some load tests on it. (start higher, then choose a smaller size) with cloud sql you can resize your instance to a smaller tier easily (it just restarts with the new size, and is quite fast at that).
Rob
Once you find a size that meets your performance criteria, you are done and have chosen the optimal size instance for your workload. When your workload increases as your database needs grow, it's trivial to upgrade to a larger tier (again, it is just a restart with the new size)
Rob
On Thu, Jul 18, 2013 at 1:07 PM, Marcelo I. <marcelo@monkeycontact.com> wrote:
Hello,I have a MySql database whose tables weigh in at 40GB, and when I run the command "top -c" it shows that mysql is using 14GB of RAM.In order to migrate this database to cloud SQL, do I have to maintain the same amount of ram? Or does the way that cloud SQL manage indexes and memory mean that I can choose a server is less RAM? Are there tools that will allow me to know if performance is suffering due to lack of RAM?Thanks for your feedbackRegards,Marcelo--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BbE6i3nntA68ou_Sxsm_XM1F3GmA9fzXgFgWkqfz3pSFPfGbw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment