May 21, 2019
Q: Validate an instance for MySQL InnoDB Cluster usage?
A: Use check_instance_configuration()
Like this:
Like Loading...
May 14, 2019
MySQL (really) supports CHECK CONSTRAINT since version 8.0.16.
In this article I will show you 2 things:
– An elegant way to simulate check constraint in MySQL 5.7 & 8.0.
– How easy & convenient it is to use CHECK constraints in 8.0.16.
Like this:
Like Loading...
May 7, 2019
In MySQL 8.0.16 the optimizer has improved again!
Comparisons of columns of numeric types with constant values are checked and folded or removed for invalid or out-of-rage values.
The goal is to speed up query execution.
Like this:
Like Loading...