Revamped by Oracle to compete against speedy NoSQL competitors, MySQL 8 is a significant step up in speed and performance, both ingress and egress. Here’s a recent testing done in January with MySQL 8 vs MySQL 5.7 from Several Nines, a DB infrastructure service company. (MySQL 5.7 is basically the standard cloud MySQL version, Google’s Cloud SQL product runs a flavor of MySQL 5.7)
There are tons of improvements that are present in MySQL 8.0. The benchmark results reveals that there has been an impressive improvement, not only on managing read workloads, but also on a high read/write workload comparing to MySQL 5.7.
But be aware the single instance installs of MySQL will need tweaking before it can beat 5.7, and MySQL 8 really starts to perform better when using multiple instances. For instance this Packt Pub test shows MySQL 8 pulls away at the 3 instance environment.
MySQL 8 has the power to be a real time back office operations engine, and has a lot of new features including security and access management tools.