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…
Category 8.0
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,…
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…
How to safely upgrade to MySQL 8.0 ?
As for each previous version, to upgrade to MySQL 8.0 you must first read the upgrade section in the manual. It’s important to know that you should upgrade without skipping a major version, so upgrade from 5.6 to 8.0 is…
TOP 10 MySQL 8.0 features for DBAs & OPS
Today, let’s have a look at the TOP 10 new features in MySQL 8.0 that will improve DBA’s life. To shrink the list to 10 only items wasn’t an easy task, but here is the top 10: Temporary Tables Improvements…
