Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables
Locking is an important concept in databases. They help regulate access to the data, so your …
Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables Read more →
MySQL
MySQL Query Attributes
Query attributes have in a long time been used to add metadata to queries to provide …
Happy Birthday MySQL
Today 23 May 2020, it is 25 years since the first release of MySQL. So, I …
MySQL Compressed Binary Logs
On a busy server, the binary logs can end up being one of the largest contributors …
Apress Blog: MySQL Performance Tuning Best Practices
To celebrate the publishing of my new book MySQL 8 Query Performance Tuning, the Apress team …
Apress Blog: MySQL Performance Tuning Best Practices Read more →
MySQL 8.0.20: Index-Level Optimizer Hints
MySQL introduced optimizer hints in version 5.7 and greatly extended the feature in MySQL 8. One …
Back Up MySQL View Definitions
If you want to back up your table and views, stored procedures, or stored function definitions, …
MySQL Server 8.0.18: Thanks for the Contributions
In my blog series about external contributions to MySQL 8 we have reached version 8.0.18 which …
MySQL Server 8.0.18: Thanks for the Contributions Read more →
Create MySQL Test Instance with Oracle Cloud Free Tier
Oracle announced this week at Oracle OpenWorld that it has introduced a new cloud offer called …
Create MySQL Test Instance with Oracle Cloud Free Tier Read more →
MySQL Server 8.0.17: Thanks for the Contributions
MySQL 8.0.17 was released Monday and it includes great features such as the Clone feature and …
MySQL Server 8.0.17: Thanks for the Contributions Read more →