Hi Folks,
We setup MySQL 8.0 on one slave and we see that it has higher latency than 5.7 slave. Per linux perf tool, MVCC::get_oldest_view() function shows up as 11% in 8.0 while that function was showing up as only 1.72% in 5.7.
Any clue on what could be causing lot of time being spent in MVCC::get_oldest_view() in 8.0? It seems to be called from trx_purge().
Thanks,
Vamsi