Magento DB Tuning: import to the database becomes slower
I see very strange database behavior. When I import or update 60 thousand products (with utilities like Firebear, Amasty, etc), I see how the productivity of imports falls after 30-40r processed items. Moreover, if the first thousand products were imported in seconds, then after 30-40k 100 products can be imported for 10-15 minutes.
We use CentOS on VPS with 32Gb of RAM, Ubuntu, MariaDB 10.3.20, default Redis installation and we have around a 80k products. Our store is sooooo slow, redis is small helped but our typical single product page can generated around 15 sec. Can you help me with tuning MySQL, and which configs I must show?