Performance Schema Functions
The sys schema was created to make it easier to use the Performance Schema. This included …
MySQL
Connector/Python Connection Attributes
MySQL Server has since version 5.6 supported connection attributes for the clients. This has allowed a …
MySQL Server 8.0.16: Thanks for the Contributions
MySQL 8.0.16 was released last week and includes many great features including support for CHECK constraints …
MySQL Server 8.0.16: Thanks for the Contributions Read more →
MySQL Shell 8.0.16: User Defined Reports
In my blog yesterday, I wrote about the new reporting framework in MySQL Shell. It is …
MySQL Shell 8.0.16: Built-in Reports
Readers of my blog know that I like how MySQL Shell allows you to customize it …
Install MySQL 8 on Linux with lower_case_table_names = 1
MySQL stores several files on disk. Even in MySQL 8 where the data dictionary is stored …
Install MySQL 8 on Linux with lower_case_table_names = 1 Read more →
MySQL Backup Best Practices
Today is World Backup Day, so I thought I would use the opportunity to discuss some …
Easy Execution of Dynamic Queries with the sys Schema
When you write stored procedures in MySQL, you sometimes need to generate queries on the fly, …
Easy Execution of Dynamic Queries with the sys Schema Read more →
Using SQLAlchemy with MySQL 8
I few months ago, I wrote about using the Django framework with MySQL 8. There are …
The Format for Timestamps in MySQL Logs
MySQL changed the timestamp format in the log files in MySQL 5.7. Since then, I have …