Louis W
Louis W

Reputation: 3272

Magento MySQL tuning

I have been noticing quite a bit of latancy with my Magento store, we are running a Dedicated Virtual server with 4GB of RAM. When I asked my host about these problems I was told the below statement. Could you offer assistance on what specifically needs to be tweaked in MySQL for optimal performance?

However, it appears that using Magento is causing a problem. Magento requires significant MySQL tuning to keep running properly. I suggest you work with a sysadmin to tune the server to suit Magentos very large resource requirements.

Upvotes: 2

Views: 1225

Answers (1)

Alana Storm
Alana Storm

Reputation: 166166

Magento has a few white papers that cover the basics.

There's an old thread on the Magento forums that, while containing out of date information, will point you towards the MySQL configuration fields that you'd need to tweak.

Seriously consider using a hosting partner that specializes in Magento hosting. If you read between the lines your host is telling you they don't want your business.

Upvotes: 3

Related Questions