XtraBackup is a great piece of software from Percona, which allows creating (nearly) lock-less MySQL/InnoDB backups. The tool has been around for quite some time and recently even received a major version bump. I have relied on it many times over the years. As it turns out, using it in some configurations may lead to heavy swapping or prevent MySQL from running queries.
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 MoreHow important a primary key design can be for MySQL performance? The answer is: Extremely! If tables use InnoDB storage engine, that is.
Read MoreIf for any reason you need to change the size of InnoDB log files (also known as transaction logs), but not sure how to do it, this post will guide you through the steps.
Read MoreCOUNT() function returns a number of rows returned by a query. In a popular opinion COUNT(*) should not be used on InnoDB tables, but this is only half true.
Read More