Off Canvas Menu

Home
Recent Activity
My Books
MySQL Books
- My Books
- Books by Oracle Employees
Who Am I?
Privacy Policy

Month: April 2020

Apress Blog: MySQL Performance Tuning Best Practices

By Jesper Krogh Posted on 29 April, 2020 Posted in Book, MySQL 8.0, Performance

To celebrate the publishing of my new book MySQL 8 Query Performance Tuning, the Apress team invited me (thanks Jonathan and Liz) to write a post for the Apress blog. I decided to write about my top six best practices: …

Apress Blog: MySQL Performance Tuning Best Practices Read more »

MySQL 8.0.20: Index-Level Optimizer Hints

By Jesper Krogh Posted on 28 April, 2020 Posted in MySQL 8.0, Optimizer, Performance

MySQL introduced optimizer hints in version 5.7 and greatly extended the feature in MySQL 8. One thing that has been missing though is the ability to specify index hints using the syntax of optimizer hints. This has been improved of …

MySQL 8.0.20: Index-Level Optimizer Hints Read more »