by Denis Subbota | Sep 28, 2023 | Insight for DBAs, MySQL
Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features –... by Denis Subbota | Mar 24, 2023 | Insight for DBAs, Insight for Developers, MySQL
You might want to use binlog compression with MySQL/Percona Server for MySQL, but it can come with drawbacks. This article discusses the need for using binlog compression and the potential issues it may cause.Binlog compression is a technique used to reduce the size... by Denis Subbota | Jan 9, 2023 | Benchmarks, Insight for DBAs, MySQL, Storage Engine
Looking at how people are using COUNT(*) and COUNT(col), it looks like most of them think they are synonyms and just use what they happen to like, while there is a substantial difference in performance and even query results. Also, we find a difference in execution on...