← Back to team overview

maria-discuss team mailing list archive

Re: Mariadb 10.4 to 10.6 performance regression


> upgrade from 10.4.26 to 10.6.11, but the performance difference is so

After some time to see if maybe the Innodb buffer pool warming up might help
(it didn't) downgraded to 10.5.18 and the performance seems to be
immediately on same level as with 10.4.

With 10.6 the slave produced/logged quite more slow queries of which
majority were just COMMITS (never seen on 10.4 or 10.5):

# User@Host: [SQL_SLAVE] @  []
# Thread_id: 2044  Schema: db  QC_hit: No
# Query_time: 1.913520  Lock_time: 0.000006  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 0
SET timestamp=1674989432;

Any ideas/comments? 

Does it make sense to test with any short-term branches? 10.10+ ?


Attachment: downgrade_to_10.5.png
Description: PNG image