We are less than 48h before the more and more popular pre-FOSDEM MySQL Day ! Unfortunately one of our speaker won’t be able to deliver his talk. Indeed, Giuseppe had ton cancel is talk on containers (Automating MySQL operations with containers) but he will be present during the day and during the Community Dinner, so if you have questions, I’m … Read More
In the first part of this howto, I illustrated how to setup two MySQL InnoDB Cluster linked by an asynchronous replication. In that solution, I didn’t use any replication filters to ignore the replication of the InnoDB Cluster’s metadata (mysql_innodb_cluster_metadata), but I used the same metadata tables with two different clusters in it. The benefit is that this allows to … Read More
Today I read the nice post of Bhuvanesh on the memory leak issue they experienced with MySQL. In fact when you read the post, you realize that MySQL was just following the parameters that were setup (the default of max_prepare_stmt_count is 16382 even on 5.6). I’m still convinced that the problem should be resolved in the application even if the … Read More
Has you may already know, in MySQL it is possible to set an expiration period for passwords. It’s not always obvious to see when the password will expire. And most of the time if you don’t pay much attention you will get something like this: ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this … Read More
Many of you already know how to retrieve the size of your dataset, schemas and tables in MySQL. To summarize, below are the different queries you can run: Dataset Size I the past I was using something like this : But now with sys schema being installed by default, I encourage you to use some of the formatting functions provided … Read More
comments