Tag - MySQL 8.0

Webinar Tues 8/21: MariaDB 10.3 vs. MySQL 8.0

MariaDB 10.3 vs MySQL 8.0

Please join Percona’s Chief Evangelist, Colin Charles on Tuesday, August 21st, 2018, as he presents MariaDB 10.3 vs. MySQL 8.0 at 7:00 AM PDT (UTC-7) / 10:00 PM EDT (UTC-4).
Register Now
Are they syntactically similar? Where do these two languages differ? Why would I use one over the other?
MariaDB 10.3 is on the path of […]

Read more

MySQL 8.0 Hot Rows with NOWAIT and SKIP LOCKED

MySQL 8.0 hot rows

In MySQL 8.0 there are two new features designed to support lock handling: NOWAIT and SKIP LOCKED. In this post, we’ll look at how MySQL 8.0 handles hot rows. Up until now, how have you handled locks that are part of an active transaction or are hot rows? It’s likely that you have the application […]

Read more

MySQL 8.0 GA: Quality or Not?

MySQL 8.0 GA

What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA?
When it comes to being a software critic, a lot.
In many ways, the work of a software critic is easy. We risk very little and thrive on negative criticism, which is fun to […]

Read more

MySQL 8.0 RESOURCE_GROUP Overview

MySQL 8.0 innodb_dedicated_server

In this blog post, we’ll provide an overview of the new MySQL 8.0 RESOURCE_GROUP feature.
One great new feature introduced in MySQL 8.0 that – from my point of view – requires attention is RESOURCE_GROUP.
Short disclaimer: I want to point out that MySQL 8.0 is not GA yet, so it is possible for the MySQL 8.0 RESOURCE_GROUP […]

Read more

Webinar Wednesday, January 10, 2018: Why We’re Excited About MySQL 8.0

MySQL 8.0 innodb_dedicated_server

Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents Why We’re Excited About MySQL 8.0 on Wednesday, January 10, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8).
Experience: Basic
Tags: Developer, DBAs, Operations, Executive, MySQL
There are many great new features in MySQL 8.0, but how exactly can they help your applications? This session […]

Read more

MySQL 8.0 Window Functions: A Quick Taste

Window Functions

In this post, we’ll briefly look at window functions in MySQL 8.0.
One of the major features coming to MySQL 8.0 is the support of Window functions. The detailed documentation is already available here Window functions. I wanted to take a quick look at the cases where window functions help.
Probably one the most frequent limitations in MySQL […]

Read more

Sudoku Recursive Common Table Expression Solver

Recursive Common Table Expressions

In this blog post, we’ll look at a solving Sudoku using MySQL 8.0 recursive common table expression.
Vadim was recently having a little Saturday morning fun solving Sudoku using MySQL 8. The whole idea comes from SQLite, where Richard Hipp has come up with some outlandish recursive query examples — WITH clause.
The SQLite query:

Shell

WITH RECURSIVE
 input(sud) […]

Read more

One Million Tables in MySQL 8.0

MySQL 8.0

In my previous blog post, I talked about new general tablespaces in MySQL 8.0. Recently MySQL 8.0.3-rc was released, which includes a new data dictionary. My goal is to create one million tables in MySQL and test the performance.
Background questions
Q: Why million tables in MySQL? Is it even realistic? How does this happen?
Usually, millions of tables […]

Read more

Percona Live 2017 – MySQL 8.0: Major New Features

MySQL 8.0

Breakout sessions are in full swing at the Percona Live Open Source Database Conference 2017. Check out what’s new in MySQL 8.0.
We’ve finished with this morning’s sessions, and this morning saw a lot of amazing open source talks. One of the most well-attended was MySQL 8.0: Major New Features given by Geir Høydalsvik, Senior Software Development Director […]

Read more

Percona Live Featured Session with Luís Soares: The New MySQL Replication Features in MySQL 8

Percona Live

Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona […]

Read more