From my experiences, you (the developer) will need to do the last tweaking of the InnoDB config parameters. I’m including the parameters that I constantly apply to my clients and make big difference when it comes to DB performance for Magento.
Why Optimizing InnoDB is Key for Magento Performance
Read More