Have you ever spent a lot of time thinking about how to install and configure a Linux server for MySQL database? I will try to highlight all the critical steps and some of the decisions you may need to make.
Read MoreI must admint I was greatly impressed by the Oracle activity on MySQL yesterday. I cannot say I didn't see it was coming, but most certainly the magnitude of what happened, the flood of announcements, was a bit overwhelming. Looking at the list of improvements, I started wondering what can it actually mean to the MySQL ecosystem.
Read MoreHow to check if any MySQL memory has been swapped out? This post explains it.
Read MoreIn one of my previous posts, "How to resize InnoDB logs?", I gave the advice on how to safely change the size of transaction logs. This time, I will explain why doing it may become necessary.
Read MoreMySQL performance is largely defined by keys and how efficiently queries can use them. As you scale, at certain point it isn't enough anymore to just have any indexes and still get a good performance in return. You have to really figure them out and allow your queries to do less work, as little work as possible. The approach presented in this article can sometimes help designing such good, efficient indexes. As a consultant, I have to rely on it myself from time to time, having to optimize a query that works in a database I know nothing about.
Read More