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

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.

×
1 answer

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

Submit an Answer