Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Magento DB Tuning: import to the database becomes slower

‎01-29-2020 09:48 PM
‎01-29-2020 09:48 PM

Magento DB Tuning: import to the database becomes slower

Hi! 

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? 

 

 

 

Thank you!

0 Kudos
Reply
1 REPLY 1
‎05-13-2020 02:24 PM
‎05-13-2020 02:24 PM

Re: Magento DB Tuning: import to the database becomes slower

Same problem here with firebear... Starts of quick then gets painfully slow... Nobody knows why not even firebear. 

 

BTW I did not know mariadb 10.3 was compatible with M2? 

0 Kudos
Reply