High Availability

MySQL optimization and diagnostics tactics

We have all been there. There's that server, which has mysterious spikes in load, which come from nowhere and leave just as they came - quickly and unexplained. While sometimes these problems can be explained with slow queries, given enough time, development and optimization, you will run into scenarios that don't register in the slow query log. It is my opinion, that any kind of database load problem can be traced back to development.
Read more