MySQL Query Attributes
Query attributes have in a long time been used to add metadata to queries to provide additional context such as where in the application the query was generated. The traditional way to do this is to add a comment at …
Category: MySQL 8.0
MySQL Compressed Binary Logs
On a busy server, the binary logs can end up being one of the largest contributors to amount of disk space used. That means higher I/O, larger backups (you are backing up your binary logs, right?), potentially more network traffic …
Apress Blog: MySQL Performance Tuning Best Practices
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
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 …
Back Up MySQL View Definitions
If you want to back up your table and views, stored procedures, or stored function definitions, you can use mysqldump or mysqlpump to export the schema without the data. However, if you just want the views you need to look …
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 was released Monday 14 October 2019. Again the community has contributed to make MySQL better. Thank you. The contributions to MySQL 8.0.18 includes several …
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 Oracle Cloud Free Tier. As the name suggest, it allows you to run a few limited instances in Oracle Cloud for free. I will …
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 multi-valued indexes. There are also several nice contributions from the community. These are the changes that this blog is about. The contributions to MySQL …
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 several functions, for example to convert the picoseconds used by the Performance Schema into human readable strings. In MySQL 8.0.16, three of these functions …
Connector/Python Connection Attributes
MySQL Server has since version 5.6 supported connection attributes for the clients. This has allowed a client to provide information such as which program or connector the client is, the client version, the license, etc. The database administrator can use …