lefred's blog

There Are 10 Types of People in the World....

MySQL 8.0 : more about new authentication plugin and replication

MySQL 8.0’s new default authentication plugin means more secure connections for users connections but also for replication… but you need to be aware of it ! Yesterday Giuseppe – the datacharmer – Maxia, submitted a bug related to a strange behavior of MySQL’s replication. He observed that after creating a new user for replication (using the new authentication method, caching_sha2_password), … Read More

MySQL 8.0 : Data Locking Visibility

With MySQL 8.0, engineers improved the visibility of data locking. Usually it was not that easy to deal with the output of SHOW ENGINE INNODB STATUS and mixing Information_Schema tables like INNODB_LOCKS and INNODB_LOCK_WAITS. So in MySQL 8.0 we instrument data locks in Performance_Schema and we changed the SYS Schema view related to the InnoDB Locks Wait too. This means … Read More

MySQL 8.0: Listing Roles

As you may already know, MySQL 8.0 is coming with SQL Roles . I’ve already quoted them before in some posts (here and here). Giuseppe Maxia is doing a great job testing and promoting them (thank you for that!). Of course he also made some remarks on things he would have done differently. The main point is about making the … Read More

MySQL 8.0 Histograms

Prior to MySQL 8.0, MySQL was missing a very well know feature in other RDBMS: optimizer histograms. The Optimizer Team implemented this feature as more and more MySQL DBAs were requesting it. Definition But what are histograms ? For wikipedia, a histogram is an accurate representation of the distribution of numerical data. For RDBMS, a histogram is an approximation of … Read More

Oracle Open World Call for Papers is open !

Today the call for participation for Oracle Open World 2018 has started. The 2018’s edition will take place in San Francisco as usual, from October 22nd to 25th. As every year, MySQL will be present and if you want to participate, we encourage you to submit a session. We encourage the submission on the following topics: case studies / user … Read More


Last Tweets Last Tweets

    Locations of visitors to this page