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 8.0
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 →
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 …
MySQL Connector/Python 8.0.14+: Changed Expression Handling in mysqlx
The X DevAPI allows you to work with JSON documents and SQL tables at the same …
MySQL Connector/Python 8.0.14+: Changed Expression Handling in mysqlx Read more →
Reduce MySQL Core Dump Size by Excluding the InnoDB Buffer Pool
When things go horrible wrong and a process crashes, one of the most powerful things to …
Reduce MySQL Core Dump Size by Excluding the InnoDB Buffer Pool Read more →
MySQL Connector/Python 8.0.15: allow_local_infile Disabled by Default
MySQL Server has a feature where you can insert data into a table from a file …
MySQL Connector/Python 8.0.15: allow_local_infile Disabled by Default Read more →
More Statistics for Slow Queries: log_slow_extra
The slow query log is the trusted old method of recording slow query, so the database …
More Statistics for Slow Queries: log_slow_extra Read more →
Automatic Decryption of MySQL Binary Logs Using Python
One of the new features in MySQL 8.0.14 is support for encrypting the binary logs. While …
Automatic Decryption of MySQL Binary Logs Using Python Read more →