As we know in the hosting industry there are many people who rely on MySQL but know, and don’t wish to know, next to nothing about MySQL. Yet slow queries are indiscriminate about who they afflict. I think what bothers non-technical users the most about slow queries causing problems in MySQL is a feeling of helplessness. Unlike a car which pretty much anyone can do the regular maintenance, MySQL maintenance isn’t so clear, even less so when the issue is query optimization. This document is meant to be a facilitator between the non-technical MySQL user with slow query problems, and a MySQL expert who can help them. The information here is to help the non-technical user at least get a handle on the situation, and not feel so helpless. From there, a MySQL expert can more easily take over and fix the issue.
(more…)