13 Apr

Choosing a MySQL package

As with any open source software, anyone can download MySQL sources, build binaries for some platforms and distribute their own packages. So we have the official ones from Oracle, MariaDB, and Percona - the makers of MySQL and its forks respectively. There are also those distributed with operating systems or that are available for install from their standard repositories. Some people or groups also create packages out of the most recent versions of various software and make them available to the world. Finally, some mash up a vanilla MySQL with various patches creating even more options. What to choose?

Read More
12 Apr

How to install and configure a Linux server for MySQL?

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 More
11 Apr

The dawn of MySQL-fork database vendors?

I 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 More
10 Apr

How to check if MySQL has been swapped out?

How to check if any MySQL memory has been swapped out? This post explains it.

Read More
10 Apr

What is the proper size of InnoDB logs?

In 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 More