(Bernt Marius Johnsen) In my blog MySQL 8.0 Collations: Migrating from older collations I showed a query that could identify the values that might break a unique constraint when migrate your data. That query was not very efficient due to the self join of the converted values.
Tag: Open Source
Migrating a MySQL database usually requires only few simple steps, but can take quite some time, depending on the amount of data you would like to migrate.
(Jean-François Gagné) In a previous post, I talked about the existence of a CREATE TABLE that is crashing MySQL up to versions 5.5.58, 5.6.38 and 5.7.20, and MariaDB up to version 5.5.57, 10.0.32, 10.1.26 and 10.2.7.
(Jesper Krogh) Sometimes it can be useful to take a step back and look at the world from a bit larger distance than usual. So in this blog, I will take a look at the high level architecture of MySQL Server.
(Rob Gravelle) Have you heard the expression “there’s an app for that”? Well, it’s true. Every day on the bus you can observe riders immersed in their phones.
(Shinguz) The Docker version of the distributions are often quite old. On Ubuntu 16.04 for example:
(Ø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.
(Shahriyar Rzayev) Recently I have encountered a weird simple issue with starting Slave server.
(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.
(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.