30 Jan
2023
30 Jan
'23
7:36 p.m.
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