MySQL 8.0 is out. Is this a great piece of news? No.
But MySQL 8.0 is wonderful, and this IS a great piece of news!
It has lots of interesting features, really. Oracle advertised some of them very well with talks at conferences, blog posts, etc. However I am very pleased by a features that they did not advertised at all: resource groups.
The documentation describes them in detail, but here is a small recap.
As we all know, MySQL has system (background) threads, and user (foreground) threads. Until now, nothing could be done to change their priority. All we could do was to tune InnoDB concurrency tickets to make sure that long running queries don’t prevent other queries from using CPU …[Read more]