The issue with a large amount of “insert into” queries running simultaneously

Hello.

I am facing the issue with a large amount of “insert into YARPP_TABLES_RELATED_TABLE” queries that are using the FULLTEXT engine and running at the same time. This leads to significant memory consumption even until complete memory depletion and oom invoking to kill the MariaDB process as the biggest memory consumer. Also, CPU load expectedly increased when SWAP started to be used hard and the web server trying to handle incoming connections.

There is a screenshot of a DB process list during one of that cases – https://i.imgur.com/PIljUXP.png

I am using WP- 6.2.2, YARPP – 5.30.3 I have seen through the plugin settings but see no related to this issue settings.

Looks like it is related to the query that is forming in the classes/YARPP_Cache_Tables.php file at the 252 line.

Is it possible to make those queries work one by one so the next query will wait while the previous one will end its processing to avoid flooding the DB engine, memory depletion, and all other issues that appear after the DB process is killed?

Thanks