Databaselast 24 hours
Shinguz: MySQL Enterprise Backup Support Matrix
MySQL Enterprise Backup (MEB) is a bit limited related to support of older MySQL versions. So you should consider the following release matrix: MEB/MySQL Supported 5.5 5.6 5.7 8.0 3.11.x NO x x 3.12.x YES x x 4.0.x NO x 4.1.x YES x 8.0.x YES 8.0.x* * MySQL Enterprise Backup 8.0.15 only supports MySQL 8.0.15. For earlier versions of MySQL 8.0, use the MySQL Enterprise Backup version with the same version number ..
Dealing with MySQL relay logs when disk space is limited, but the replica is far behind the source
I just encountered the problem described in the title, on a server I don’t have enough free space for create a backup as long the replica is catching up, because the relay logs eats all the available free space as the IO thread works faster than the SQL thread in the replication. What to do? […]
How Network Bandwidth Affects MySQL Performance
Network is a major part of a database infrastructure. However, often performance benchmarks are done on a local machine, where a client and a server are collocated – I am guilty myself. This is done to simplify the setup and to exclude one more variable (the networking part), but with this we also miss looking at how network affects performance. The network is even more important for clustering products like Percona XtraDB Cluster and MySQL Group..
MySQL Connector/Python 8.0.14+: Changed Expression Handling in mysqlx
Tweet 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 JSON documents, SQL tables, CRUD methods, and SQL statements to give you the best of all worlds. In MySQL Connector/Python, the X DevAPI is implemented in the mysqlx module. This blog will look at how MySQL Connector/Pyt..
DatabaseNews
Database Journal:
IBM Db2 Query Optimization Using AIIBM Db2 Query Optimization Using AI
Oracle's Interesting Treatment ofOracle's Interesting Treatment of IN-LISTS
New Truncation Error Message in SQLNew Truncation Error Message in SQL Server 2019
Getting Approximate Count in MicrosoftGetting Approximate Count in Microsoft SQL Server
Top 10 Databases for 2019Top 10 Databases for 2019
Is UNION The Best Choice When JoiningIs UNION The Best Choice When Joining Result Sets?
Understanding Metadata ManagementUnderstanding Metadata Management
Generate Dynamic MySQL Multi-rowGenerate Dynamic MySQL Multi-row INSERT Statements
Handling Disaster Recovery When UsingHandling Disaster Recovery When Using Oracle Managed Files
HTAP - Hybrid Transaction and AnalyticalHTAP - Hybrid Transaction and Analytical Processing
Planet MySQL:
Shinguz: MySQL Enterprise Backup24hShinguz: MySQL Enterprise Backup Support Matrix
Dealing with MySQL relay logs when24hDealing with MySQL relay logs when disk space is limited, but the replica is far behind the source
How Network Bandwidth Affects MySQL24hHow Network Bandwidth Affects MySQL Performance
MySQL Connector/Python 8.0.14+: Changed24hMySQL Connector/Python 8.0.14+: Changed Expression Handling in mysqlx
Percona Server for MySQL 5.7.25-28Percona Server for MySQL 5.7.25-28 Is Now Available
How to Migrate from Oracle to MySQLHow to Migrate from Oracle to MySQL / Percona Server
Deprecation of TLSv1.0 2019-02-28Deprecation of TLSv1.0 2019-02-28
7 JavaScript Playgrounds to Use in 20197 JavaScript Playgrounds to Use in 2019
Using FORCE INDEX: When Your QueryUsing FORCE INDEX: When Your Query Optimizer Gets It Wrong
Fun with Bugs #79 - On MySQL BugFun with Bugs #79 - On MySQL Bug Reports I am Subscribed to, Part XV