There is a significant difference in query performance with MariaDB 10.6 running on CentOS (2 seconds) compared to on Rocky (48 seconds). When setting split_materialized=off, the query executes a bit faster (7 seconds) for this particular query, but it is still slower than on CentOS.
Query used to reproduce:
set session optimizer_switch='split_materialized=on';
|
|
use b_test;
|
|
select this_.`RMD_CURRENT_STATUS_VALUE` as y0_, count(*) as y1_
|
from `TEST_MAU_REQUEST_RECORD_VIEW` this_
|
where (lower(this_.`UAR_ALL_EMAILS`) like '%AbeFrazer8@example.com%' escape '!'
|
or lower(this_.`UAR_APPROVER_STLS`) like '%AbeFrazer8@example.com%' escape '!'
|
or lower(this_.`REQUEST_BY`) like '%AbeFrazer8@example.com%' escape '!')
|
group by this_.`RMD_CURRENT_STATUS_VALUE`
|
order by y0_ asc
|
limit 50;
|
Critical 