Posted recently on the maria-developers mailing list, by Igor Babaev, Principal MariaDB developer at Monty Program is some interesting preliminary results for MariaDB 5.3.0 benchmarked against the DBT-3 benchmarking program. DBT-3 is a benchmark to test a decision support workload, with a suite of business-oriented queries and concurrent data modifications. Read Igor’s discoveries, which he ran […]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