mariadb 11.0부터 Query Optimizer를 크게 개선

[742soft]

mariadb가 nasdaq 상장후 계속 적자를 내면서도, 개발을 꾸준히 하면서, 11부터 Query와 innodb를 크게 개선

https://monty-says.blogspot.com/2022/12/i-want-to-wish-you-happy-new-year-with.html

Your queries are

using more than two tables
using indexes that have lot of identical values.
using ranges that cover more than 10% of a table.
   WHERE key between 1 and 1000  -- Table has values 1-2000
using complex queries where not all used columns are or can be indexed.
In which case you may need to depend on selectivity to get the right plan.
mixing different storage engines.
Like using tables from both InnoDB and Memory in the same query.
using FORCE INDEX to force an index
getting worse (or not good enough) when using ANALYZE TABLE.
depending on --optimizer-use-condition-selectivity > 1 (using selectivity to find out how many accepted rows there are in a table).
using lots of derived tables (subselects).
using ORDER BY / GROUP BY that could be resolved via indexes
using table scans when it should use keys and vice versa.

[ibin79]

11.3 까지는 아직 1년 단기 지원 버전들이군요. 조만간 LTS 가 나올 것 같네요.

[ibin79]

MariaDB 11.4 (LTS)

• 2029년 5월까지 지원

https://mariadb.com/kb/en/changes-improvements-in-mariadb-11-4/

• 테스트 도입후, 위키에 업그레이드 가이드 추가
• 운영 도입후 지켜본후, 기본 설치 버전을 현재 10.11 에서 11.4 로 변경할지 검토.