My shared-host tells me that they're throttling my website because of MySQL, what can I do?
I'm not familiar enough with performance tuning of MySQL, generally MySQL just works for me. What questions do I need to ask to figure out how to fix this? Is this memory? Is this processor? Is this configuration of MySQL? Assuming I get access to the slow query log, what will it take for me to make sense of it?
I'm asking this as a generic, but I have run into this many times and generally it's a substandard host. Changing to a better host and implementing caching usually does the trick. But what are the most important settings to consider in order of priority?
UPDATE: I'm hoping to get this to be a checklist of "how can I tell if MySQL is set up okay on my shared hosting account?" type issues.