(Shinguz) The Docker version of the distributions are often quite old. On Ubuntu 16.04 for example:
Tag: Open Source
Going Beyond Tabular EXPLAIN
(Øystein Grøvlen) A while ago, Lukas Eder posted a very interesting article on query optimizations that do not depend on the cost model. We often call such optimizations query transformations since they can be applied by rewriting the query.
MySQL blank users preventing slave I/O connection?
(Shahriyar Rzayev) Recently I have encountered a weird simple issue with starting Slave server.
Deploying & Managing MySQL NDB Cluster with ClusterControl
(Krzysztof Ksiazek) In ClusterControl 1.5 we added a support for the MySQL NDB Cluster 7.5. In this blog post, we’ll look at some of the features that make ClusterControl a great tool to manage MySQL NDB Cluster.
From MySQL 5.6 partitioning to 5.7 and beyond
(Frederic Descamps) As you may already know, since MySQL 5.7.17, the generic partitioning handler in the MySQL server is deprecated, and is completely removed in MySQL 8.0.
Further improvements on INFORMATION_SCHEMA in MySQL 8.0.3
(Ståle Deraas) With the transactional data dictionary in MySQL 8.0, see MySQL 8.0: Data Dictionary Architecture and Design , INFORMATION_SCHEMA is reimplemented as views over data dictionary tables.
Docker Compose and App Deployment with MySQL
(Robert Neumayer) In this post we show how to use the mysql-server Docker image for local development. We first introduce a simple example app that starts up and tries to connect to a given db until successful.
InnoDB Page Compression: the Good, the Bad and the Ugly
(Vadim Tkachenko) In this blog post, we’ll look at some of the facets of InnoDB page compression.
A new optimization in gcc 5.x and MySQL
(Mark Callaghan) We were testing the impact of changing from gcc 4.9 to 5.x and from older to newer jemalloc. For one of the in-memory sysbench tests the QPS at high-concurrency dropped by 10%.
MySQL 8.0 Data Dictionary Tables… and why they should stay protected
(Frederic Descamps) With MySQL 8.0, one key feature is the new Data Dictionary.
