Level 61
I'm not sure you can compare performances of those two.
Apr 23, 2020
3
Level 7
Same query in Digital Ocean Managed MySQL DB more than doubly slow than on droplet.
Hey all!
May be a dumb question, but I'd rather ask.
I currently have my DB on a separate droplet in DO. The Spec is:
2 GB Memory, 2 vCPUs, 3 TB, 60 GB DISK, $15/mo
I'm in the process of migrating to a Managed DB and have opted for the cheapest spec to start:
1 GB Memory, 1 vCPU, 10 GB DISK, $15/mo
For the most part I don't see any performance hits however I have one page (Dashboard) that loads 7 charts based on logs which has gone from around 2s to load to 10s.
I have the following query running 7 times with slight differences in what it is searching for.
SELECT DATE(created_at) as d, COUNT(id) as c FROM `logs` WHERE site_id = 4 AND `action` LIKE '%DLM Item Downloaded%' GROUP BY DATE(created_at);
In sequel pro on the current live droplet DB this takes 962ms for one query, however within TablePlus on the MySQL 8 Managed DB this takes 2.076s.
I know this is a lower spec but I don't have any traffic going to this DB yet and the Insights don't look too bad from within the DO dashboard for the Managed DB to me.
Memory: Around 66%. CPU: 8% - although this goes up to around 18% when I load the Dashboard page. Disk Usage: 8.29.
Is this purely because I have a lower spec? Or is there something else I should be considering?
Thanks!
Level 1
You're not alone - I tried to switch over a Laravel app from a MySQL instance on the same server, to a managed instance, and the performance was horrendous. The average fetch operation took 20-30 seconds.
Switched back to the instance on the same server and am looking at alternatives, such as ScaleGrid.
1 like
Level 1
We had the Same Experience, Our DigitalOcean Managed Db was Way too slow compared to our DB on the same server. The response time and latency was good, but Query execution time was horrible, On our Main Server Query Execution time 0.08 Seconds on Digitalocean Mysql Managed DB 1.2 Seconds - We scaled the db to 8GB Ram. it went down to 0.6 seconds. but still way too slow compared to our main Db on the server.
Please or to participate in this conversation.