2 ms·
My bets are all squarely on MariaDB. MySQL under Oracle is stymied by conflicts of interest. One concrete example is hashjoins, a fairly simple and efficient
by heavenlyhash 12y ago
My bets are all squarely on MariaDB. MySQL under Oracle is stymied by conflicts of interest.
One concrete example is hashjoins, a fairly simple and efficient strategy for many general purpose workloads: MariaDB supports hashing as a join strategy since 5.3/5.5 [1] back in 2011. MySQL, to the best of my knowledge, still lacks any implementation of this. OracleDB, of course, supports hash joins. Oracle has every incentive not to implement hash joins in MySQL because hash joins are one of the performance features that they use to drive sales of OracleDB.
[1] https://mariadb.com/kb/en/mariadb/what-is-mariadb-53/#join-optimizations https://mariadb.com/kb/en/mariadb/what-is-mariadb-53/#join-o...