We store data with the intention to use it: search, retrieve, group, sort... To perform these actions effectively MySQL storage engines index data and communicate statistics with the Optimizer when it compiles a query execution plan. This approach works perfectly well unless your data distribution is uneven.

Last year I worked on several tickets where data followed the same pattern: millions of popular products fit into a couple...

Please watch Percona's Bug Analyst, Lalit Choudhary as he presents his talk "MySQL 8.0 Architecture and Enhancement".

The release of MySQL 8.0 offers much more to users compared to previous releases. There are major changes in architecture as well as adding differentiating features, and improvements to manage the database more efficiently.
In our talk we will go through, MySQL 8.0 architecture
* On Disk
* In-...

Please watch Percona’s Principal Support Engineer, Sveta Smirnova, as she presents “MySQL Performance Schema in 1 hour”.

Born in 2010 as "a feature for monitoring server execution at a low level," grown over the years with performance fixes and DBA-faced features, in MySQL 8.0 Performance Schema is a mature tool, used by humans and monitoring products. In this webinar I will give an overview of Performance Schema, focusing on its...

Watch Percona Support Engineer, Vinicius Grippa as he presents his talk “Enhancing MySQL Security".

Security is always a challenge when it comes to data. What’s more, regulations like GDPR add a whole new layer on top of it, with rules more and more restrictive to access and manipulate data. Join us in this presentation to check security best practices, as well as traditional and new features available for MySQL including...