Linux perf tool showing much more time spent in MVCC::get_oldest_view() in 8.0 than in 5.7

MySQL & MariaDB Percona Server for MySQL 8.0
#1

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

1 Like