by Przemysław Malkowski | Oct 10, 2018 | Insight for DBAs, MySQL
Probably not well known but quite an important optimization was introduced in MySQL 5.6 – reduced overhead for “read only transactions”. While usually by a “transaction” we mean a query or a group of queries that change data, with... by Przemysław Malkowski | Sep 20, 2018 | MariaDB, Percona Software, Storage Engine
RocksDB engine—and it’s MySQL implementation MyRocks—is a very good alternative engine for MySQL. It has proven to be very efficient and stable for many workloads, including those of large scale. However, it is still a relative newborn in the MySQL... by Przemysław Malkowski | Apr 12, 2018 | Insight for DBAs, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative. Learn More In this blog post, I’ll look at point-in-time recovery (PITR) options for MySQL, MariaDB and... by Przemysław Malkowski | Apr 6, 2018 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll look at how to approach pt-table-checksum errors.pt-table-checksum is one of the most popular tools in Percona Toolkit, and it is widely used to identify data differences between masters and slaves. Therefore, as Percona Support... by Przemysław Malkowski | Feb 24, 2017 | Insight for DBAs, Insight for Developers, MySQL
UPDATE: Some of the language in the original post was considered overly-critical of Oracle by some community members. This was not my intent, and I’ve modified the language to be less so. I’ve also changed the term “synchronous” (which the use... by Przemysław Malkowski | Feb 1, 2017 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
In this blog, we’ll discuss how to use concurrency to help with WAN latency when using synchronous clusters. WAN Latency Problem Our customers often ask us for help or advice with WAN clustering problems. Historically, the usual solution for MySQL WAN... by Przemysław Malkowski | Dec 27, 2016 | Insight for DBAs, Insight for Developers, MongoDB, MySQL
This blog discusses how to prepare your database for the new leap second coming in the new year.At the end of this year, on December 31, 2016, a new leap second gets added. Many of us remember the huge problems this caused back in 2012. Some of our... by Przemysław Malkowski | May 24, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER... by Przemysław Malkowski | Dec 21, 2015 | Insight for DBAs, MySQL, Percona Software
High Availability Have you ever wondered if your application should be able to work in read-only mode? How important is that question?MySQL seems to be the most popular database solution for web-based products. Most typical Internet application workloads consist of... by Przemysław Malkowski | Jan 5, 2015 | Insight for DBAs, MariaDB, MySQL, Percona Software
Sometimes it is desired to use particular software versions in production, and not necessary the latest ones. There may be several reasons for that, where I think the most common is when a new version should spend some time in testing or a staging environment before... by Przemysław Malkowski | Sep 25, 2014 | Insight for DBAs, Insight for Developers, MySQL
Recently I encountered a specific situation in which a customer was forced to stay with the MyISAM engine due to a legacy application using tables with over 1000 columns. Unfortunately InnoDB has a limit at this point. I did not expect to hear this argument for... by Przemysław Malkowski | Sep 1, 2014 | Insight for DBAs, MySQL, Percona Software
Galera replication for MySQL brings not only the new, great features to our ecosystem, but also introduces completely new maintenance techniques. Are you concerned about adding such new complexity to your MySQL environment? Perhaps that concern is unnecessarily.I am... by Przemysław Malkowski | Feb 24, 2014 | Benchmarks, Insight for DBAs, MySQL
In my previous post I pointed out that the existing ARCHIVE storage engine in MySQL may not be the one that will satisfy your needs when it comes to effectively storing large and/or old data. But are there any good alternatives? As the primary purpose of this... by Przemysław Malkowski | Jan 6, 2014 | Insight for DBAs, MySQL, Percona Services
Sometimes there is a need for keeping large amounts of old, rarely used data without investing too much on expensive storage. Very often such data doesn’t need to be updated anymore, or the intent is to leave it untouched. I sometimes wonder what I should really... by Przemysław Malkowski | Oct 14, 2013 | Insight for DBAs, MySQL, Percona Services
GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed to provide historical views into what happens to our database over time rather then real-time insight into current MySQL server status. Excellent free... by Przemysław Malkowski | Jul 5, 2013 | Insight for DBAs, MySQL
Among many of the improvements you can enjoy in MySQL 5.6, there is one that addresses a huge operational problem that most DBAs and System Administrators encounter in their life: schema changes.While it is usually not a problem for small tables or those in early...