The X DevAPI allows you to work with JSON documents and SQL tables at the same time. Furthermore, the CRUD style API is more intuitive than SQL statements for some programmers. Either way, the X DevAPI allows you to mix …
MySQL Connector/Python 8.0.14+: Changed Expression Handling in mysqlx Read more »
When things go horrible wrong and a process crashes, one of the most powerful things to investigate the cause of the crash is a core dump. As the amount of memory allocated to processes such as MySQL has increased – …
Reduce MySQL Core Dump Size by Excluding the InnoDB Buffer Pool Read more »
MySQL Server has a feature where you can insert data into a table from a file with the data delimited by commas, tabs, or another delimiter. This is particularly useful when you need to bulk import data, for example when …
MySQL Connector/Python 8.0.15: allow_local_infile Disabled by Default Read more »
The slow query log is the trusted old method of recording slow query, so the database administrator can determine which queries are in the most need for optimization. Since MySQL 5.6, it has to some extend been overshadowed by the …
More Statistics for Slow Queries: log_slow_extra Read more »
One of the new features in MySQL 8.0.14 is support for encrypting the binary logs. While encryption makes the data more secure (provided the key is secret of course), it can make life a bit more difficult in terms of …
Automatic Decryption of MySQL Binary Logs Using Python Read more »
MySQL 8.0.14 was released earlier in the week, and again we (Oracle) received several contributions that either made it into the release or at least inspired a feature or bug fix. This blog will go through the the changelog notes …
MySQL Server 8.0.14: Thanks for the Contributions Read more »
The MySQL X DevAPI is the new API that provides a uniform API across the supported programming languages. It has from the beginning supported that you can specify a default schema, when you connect. Originally it was not used for …
MySQL Connector/Python 8.0.14 X DevAPI: Default Schema Read more »
Maybe the biggest new feature in MySQL 8 is the new transaction data dictionary that improves the consistency of schema objects among other things. To further protect the data in the data dictionary, the data dictionary tables are hidden and …
MySQL 8: Drop Several Stored Events, Procedures, or Functions Read more »
If you have an application that need to use multiple connections to the MySQL database for short periods of times, it can be a good to use a connection pool to avoid creating a new connection and going through the …
MySQL X DevAPI Connection Pool with Connector/Python Read more »
The other day, I was reading a blog by Magnus Hagander about tracking foreign keys throughout a schema in PostgreSQL. I thought it was a good idea, so I decided to look at how you can track foreign key in …
