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,…
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…
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…
I received many request about MySQL High Availability Architecture. There are a lot of tools, but how can we use them to achieve MySQL HA without over engineering everything. To answer such demand, there is no generic architecture, of…
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…