MySQL Query Attributes
Query attributes have in a long time been used to add metadata to queries to provide …
MySQL 8.0
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 →
Performance Schema Functions
The sys schema was created to make it easier to use the Performance Schema. This included …
Connector/Python Connection Attributes
MySQL Server has since version 5.6 supported connection attributes for the clients. This has allowed a …