mySQL Optimization Suggestions
- by Brian Schroeter
I'm trying to optimize our mySQL configuration for our large Magento website. The reason I believe that mySQL needs to be configured further is because New Relic has shown that our SELECT queries are taking a long time (20,000+ ms) in some categories.
I ran MySQLTuner 1.3.0 and got the following results... (Disclaimer: I restarted mySQL earlier…