[Maria-discuss] Mariadb 10.4 to 10.6 performance regression
Hello, for testing the upgrade path I did an in-place slave server (with optimistic parallel replication) upgrade from 10.4.26 to 10.6.11, but the performance difference is so significant/abysmal I don't even know where to look at (see the attached QPS chart before and after upgrade - it's like 2-3x times lower!). All the previous settings/configuration are kept. I have various server parameters monitored but none seem to indicate why would everything become way slower (see for example the disk write operations also are 2-3 times lower). Maybe someone can give an idea where to look or what to check what could make such an impact? p.s. I know about https://jira.mariadb.org/browse/MDEV-29988 but I don't think that I'm hitting it since the cpu load hasn't changed (is even lower). wbr rr
upgrade from 10.4.26 to 10.6.11, but the performance difference is so significant/abysmal
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; COMMIT; Any ideas/comments? Does it make sense to test with any short-term branches? 10.10+ ? wbr rr
participants (1)
-
Reinis Rozitis