Droplet hosted MySQL has worse performance than lower powered Managed MySQL instance.

I currently have an application that runs a daily process with heavy read-write loads onto the database.

The application was developed with a DigitalOcean Managed MySQL instance (2 vCPUs and 4GB RAM). Over time, the cost of resizing the managed MySQL instance became prohibitive, so I picked up a droplet with 8 vCPUs and 16GB RAM to host my own instance of MySQL. Even with over 2x the CPU and RAM, my droplet MySQL instance shows much slower performance.

This is evidenced by the old managed MySQL being able to ingest records at 1400 records per minute, while the current MySQL only takes in 800 items per minute. For reference, these are python scrapy items that I insert into the database, using SQLAlchemy as an ORM.

I followed recommendations from MySQL_tuner_perl and online sources and have set the following values in my mysqld.cnf

# Updated Configs
innodb_buffer_pool_size = 10G
innodb_buffer_pool_chunk_size = 256
innodb_buffer_pool_instances = 10

innodb_log_file_size = 1G
innodb_log_buffer_size = 512M

innodb_flush_method = O_DIRECT

innodb_io_capacity = 1000
innodb_io_capacity_max = 2000

innodb_thread_concurrency = 0
innodb_read_io_threads = 32
innodb_write_io_threads = 32


max_connections = 100
table_open_cache = 1000
thread_cache_size = 12

skip_name_resolve = ON
binlog_cache_size = 16M

Are there any recommended troubleshooting tips to find the bottleneck? With my new DB having superior hardware specs, I believe it’s only normal to expect better performance. As far as MySQL configs go, I don’t see any big red flags, but I could be wrong. Open to any help or suggestions on how to speed up my DB operations!

Thanks in advance :)