I'm facing a very slow MySQL database right now. As far as hardware is concerned, everything looks fine, but we still have many queries that are very slow.
We're using proprietary software, so we can't optimize the queries and all performance optimization has to be done on the database end. I'm looking for a few tips from you guys, where to look at, where to keep an eye on and which basic procedures should be followed.
Thanks in advance for any help!
ps.: Blog posts, articles and other links with QUALITY content are also welcome. Please, don't troll the question telling me to Google, because if i wanted, i would Google. I'm looking for quality advice from experienced people, quality links, not just random crap found by search engines.