by Alexander Rubin | May 8, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll review how a hung MySQL transaction can cause the InnoDB history length to grow and negatively affect MySQL performance.Recently I was helping a customer discover why SELECT queries were running slower and slower until the server restarts... by Alexander Rubin | Apr 7, 2017 | Insight for DBAs, MySQL
In this blog, we’ll look at how queries in systems with parallel processing can return rows in a non-deterministic order (and how to fix it). Short story:Do not rely on the order of your rows if your query does not use ORDER BY. Even with ORDER BY,... by Alexander Rubin | Mar 17, 2017 | Insight for DBAs, 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 This blog shares some column store database benchmark results, and compares the query performance... by Alexander Rubin | Feb 13, 2017 | Benchmarks
For this blog post, I’ve decided to try ClickHouse: an open source column-oriented database management system developed by Yandex (it currently powers Yandex.Metrica, the world’s second-largest web analytics platform).In my previous set of... by Alexander Rubin | Oct 20, 2016 | MySQL
In this blog, we’ll discuss descending indexes in MySQL 8.0. Summary The future MySQL 8.0 will (probably) have a great new feature: support for index sort order on disk (i.e., indexes can be physically sorted in descending order). In the MySQL 8.0 Labs... by Alexander Rubin | Oct 18, 2016 | MySQL
This blog post discusses the ramifications of STRICT mode in MySQL 5.7. In short By default, MySQL 5.7 is much “stricter” than older versions of MySQL. That can make your application fail. To temporarily fix this, change the SQL_MODE to... by Alexander Rubin | Oct 12, 2016 | MySQL
This blog updates Stephane Combaudon’s blog on MySQL performance tuning and covers MySQL 5.7 performance tuning immediately after installation.A few years ago, Stephane Combaudon wrote a blog post on Ten MySQL performance tuning settings after installation... by Alexander Rubin | Oct 3, 2016 | MySQL
In this blog post, we’ll look at MySQL 8.0 general tablespaces. Introduction MySQL 8.0 (the DMR version is available now) has two great features (among others): The new data dictionary completely removed *.frm files, which is great The ability to create a... by Alexander Rubin | Sep 13, 2016 | Insight for DBAs, MySQL
by Alexander Rubin | Aug 17, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll discuss how to improve the performance of slow MySQL queries using Apache Spark.In my previous blog post, I wrote about using Apache Spark with MySQL for data analysis and showed how to transform and analyze a large volume of data (text... by Alexander Rubin | Jul 6, 2016 | MySQL
by Alexander Rubin | Jul 5, 2016 | MySQL
In this post, I’ll discuss how MySQL 5.7 handles UTF8MB4 and the load data infile.Many of my clients have told me that they do not like using the LOAD DATA INFILE statement and prefer to manually parse and load the data. The main reason they do it are issues... by Alexander Rubin | Jun 23, 2016 | MySQL
In this blog series, I will share my experiences as I migrate commercial databases (i.e., Microsoft SQL or Oracle) to open source (MySQL). More specifically, we will look at how you can migrate from MS SQL Server to MySQL.For this first blog post I’ve... by Alexander Rubin | Jun 8, 2016 | MySQL
by Alexander Rubin | Jun 1, 2016 | MongoDB, MySQL
by Alexander Rubin | May 27, 2016 | MySQL
by Alexander Rubin | May 24, 2016 | MySQL
In this blog, we’ll look at the MySQL 5.7 document store feature, and how it is implemented.Document StoreMySQL 5.7.12 is a major new release, as it contains quite a number of new features: Document store and “MongoDB” like NoSQL interface to... by Alexander Rubin | Apr 15, 2016 | MongoDB, MySQL, Percona Live
by Alexander Rubin | Apr 8, 2016 | MySQL
This blog post will discuss the issues and solutions for MySQL Data at Rest encryption. There is an update, too, by my colleague Ceri Williams – you can check it out here.Data at Rest Encryption is not only a good-to-have feature, but it is also a... by Alexander Rubin | Apr 1, 2016 | MySQL