Some time ago we have observed that memory for some MySQL instances has been constantly eaten away. Investigation pointed us to memory/innodb/memory area and databases with tables having generated virtual columns, which in addition were used in indexes. It was affecting both 8.0.25 and 8.0.28 instances (we haven’t checked the other versions), both master and its replicas.
Tag: MySQL
NVMes write back vs. write through performance
Recently I was running some benchmarks to double-check that the performance of AMD EPYCs servers delivered by Company A, match the performance of those delivered by Company B. I was using our benchmark automation tool (about which I may write a bit more in the future). It is currently based on sysbench to hammer MySQL instances. Surprisingly, the results have shown very significant difference: B servers were on average 83% slower…
Change is the only constant... 