I’m weighing the pros and cons of migrating from AWS RDS MySQL to their Aurora system. I set up an Aurora replica of the current MySQL database so I can test queries out on both and compare their execution times. Although most online sources, including some analyses posted on this website, say that Aurora outperforms MySQL, in my tests I’ve seen 50% longer runtimes of the same queries on Aurora.
Are there any parameters I can tune (from the default AWS Aurora Parameter Group) to make Aurora faster than MySQL? Looking to reveal what it seems like the rest of the Internet is seeing.