mysql

MySQL 8.0: New mysql-test-run option to minimize skipped tests in regression test runs Anybody who has run the MySQL MTR test suite must have seen a statement like “x tests were skipped, y by the test itself. ” at the end of test runs. Why are some tests being skipped? Are the skipped tests affecting test coverage?… Source: MySQL 8.0: New mysql-test-run option to minimize skipped tests in regression test runs

Hybrid Data Encryption by Example using MySQL Enterprise Edition Sharing keys, passphrases with applications is problematic, especially with regard to encrypting data. Too often applications are developed where “the keys are left in the door” or at best “under the mat” – hard coded, in a clear text property file… exposed and vulnerable. … Source: Hybrid Data Encryption by Example using MySQL Enterprise Edition

MySQL 8.0: Retiring Support for the Query Cache As Rene wrote on the ProxySQL blog yesterday: Although MySQL Query Cache was meant to improve performance, it has serious scalability issues and it can easily become a severe bottleneck. This is indeed something we have observed in the MySQL team for a while.… Source: MySQL 8.0: Retiring Support for the Query Cache

MySQL 8.0 MTR: ‘require’, is now an invalid mysqltest command Some of the users may have noticed that .require files do not exist anymore in the MySQL test suite. A .require is file is used along with ‘require’ mysqltest command. In test cases, the command ‘require’ is used to ensure MTR performs certain sanity checks.… Source: MySQL 8.0 MTR: ‘require’, is now an invalid mysqltest command

MySQL 8.0.1: [Recursive] Common Table Expressions in MySQL (CTEs), Part Four – depth-first or breadth-first traversal, transitive closure, cycle avoidance CTEs and Recursive CTEs appeared in MySQL 8.0; first in a Labs release and now in the official release 8.0.1. Several blogs have been published: here, here and here ; my colleague Øystein also wrote about how using a CTE made one DBT3 query run twice faster.… Source: MySQL 8.0.1: [Recursive] Common Table Expressions in MySQL (CTEs), Part Four – depth-first or breadth-first traversal, transitive closure, cycle avoidance