Like others we were not satisfied with the fix for a bug in MySQL which caused the query cache and partitioning to not work reliably together. The bug, in simple terms, was that if the query cache was enabled and you used partitioned tables and if a partitioned table was using a transactional engine like InnoDB or XtraDB, the query cache could, under […]READ MORE
There's innodb_large_prefix as a possible workaround, which is default in 10.2 https://t.co/URwAEaZcN7
The reason is because MariaDB imposes a maximum of 767 bytes for indexes, and 767 / 4 = 191 (rounded down).
The danger of no Primary Key when replicating in RBR (partial protection with MariaDB 10.1) https://t.co/M6mABJdkmn by @jfg956