My newly launch droplet performance is worst

Posted on June 3, 2020

Greetings,

After using DO droplet for two years, I planed to launch new servers of same specs. I launched it but the performance is not the same as old one. Every spec is same but when I perform MySQL query on old server it took .6 second to response while in new server it took 49 seconds.

Is DO showing specs same but behind the scene there is less specs server given to us?

I opened the ticket few days ago but never respond.

Best Regards

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby

June 4, 2020

Hi there @andrewRudnick,

I have a lot of Droplets with DigitalOcean and I can assure you that you are getting as much resources as you pay for.

Regarding the time it takes for your queries to complete, this could be due to a few things:

Check your MySQL version and see if it matches on the two servers
Check your MySQL configuration in terms of the buffer size, query cache and etc .and make sure that you’ve carried over your custom changes to your new server as well. You can do that by checking your MySQL configuration file on your old server
If you are still seeing the problem, I would recommend checking this answer here on how to tweak your MySQL configuration for increased performance:

https://www.digitalocean.com/community/questions/how-to-tweak-mysql-mariadb-configuration-for-increased-performance-and-stability

Another thing which could be causing the issue is if you have indexes on your old database but not on the new one. Adding indexes would improve the speed of operations for your tables.

Let me know how it goes.

Regards, Bobby