Seems the MySQL performance forums don't get huge amounts of traffic. Can anyone recommend a good forum where I can start asking MySQL tuning questions and actually have a chance of getting them answered?
If you're curious, my current dilemma involves a 50 second response time on a simple join. I've run both OPTIMIZE and ANALYZE over the tables in the query and after about an hour and a quarter, the index I list in that post was finally created. However, it had no affect on query performance and the only difference in the EXPLAIN is that it listed the index as another possible key but didn't use it.
In short, I'm stuck. I don't know what to do next and I have no idea how that index can be applied to our production database without bringing the box to its knees (I have no admin skills). One person said "just don't use joins" and I might have to for this simple query, but not being able to use joins in SQL means I might as well fall back to a flat file database -- something I honestly feel I could optimize easier than our current MySQL setup