Monday, May 18, 2009

Magento: slow product updates

Ever since I upgraded to 1.3.1 simply saving a product takes a very long time (2-3 minutes). This was driving me (and others updating products) crazy.

I finally resolved the issue. I was reviewing the MySQL processlist while magento was updating a product and noticed a very long running thread:

invalidating query cache entries (key)   DELETE FROM `catalogindex_aggregation` WHERE (aggregation_id IN (SELECT `catalogindex_aggregation_to
I had enabled query caching per this post on the magento groups. When I disabled query caching in MySQL the slow product updates issue disappeared. Now saving a product only takes 2-3 seconds.
Posted by at

28 comments:

  1. tridominatorAugust 24, 2009 at 1:42 PM

    We had a similar issue, but we found that the issue was because we were running the server as a virtual machine. When we ran the import on hardware, the save times per product went from 15-50 seconds to .5 seconds. Hope that helps someone...we sure banged our heads against the wall!

    ReplyDelete
  2. davidjones035February 1, 2010 at 4:02 AM

    I have a site created with Magento Custom Development. I also had the same problem. I tried lots of thing but cant get the solution. After reading your post, I get the solution of my problem.

    ReplyDelete
  3. AnonymousSeptember 2, 2010 at 2:10 PM

    Could you clarify, what exactly did you do to turn off caching? I've tried adding 'query_cache_type = 0' as well as 'query_cache_size =0', but it didn't work for me. Still saving a product takes 1-2 minutes on a dedicate 2 x P4 CPU machine with 2GB RAM and catalog of 1800 products.

    ReplyDelete
  4. UnknownOctober 26, 2010 at 11:31 PM

    I came on your blog for the first and I have seen your work. I must say you have maintained your Blog really well. Good on you.
    magento ecommerce developer

    ReplyDelete
  5. sophia mooreSeptember 13, 2011 at 3:55 AM

    tridominator this was really nice answer you provided but can some one please help me as i'm yet confused :(

    ReplyDelete
  6. BiztechconsultancyOctober 13, 2011 at 5:09 AM

    This comment has been removed by the author.

    ReplyDelete
  7. AnonymousOctober 22, 2011 at 5:54 PM

    The link of the procedure to avoid it is no longer visible.
    How did u fix the problem and what are the my.cnf values to be turned off?
    In my store it takes 60 sec to save a product with magento 1.6.0

    ReplyDelete
  8. Jacob HassidimJanuary 10, 2012 at 2:21 PM

    hi there - i might need your help in tuning our magento store. if you can drop me an email to guy@zirconmania.com i would appreciate it

    ReplyDelete
  9. Touch Website SolutionsJune 6, 2012 at 2:01 AM

    Great post. I really appreciate your blog as it is impressive and informative. Thanks for sharing such an useful info.
    Website design

    ReplyDelete
  10. Magento ModulesAugust 3, 2012 at 11:43 AM

    so was it the cache causing problem!

    ReplyDelete
  11. Alexander DrokDecember 12, 2012 at 7:32 AM

    Indeed when a large number of goods or attributes need to be saved, backend works very slow, as each time you save data the system re-indexes the goods through the entire catalog.

    Asynchronous Re-indexing is a solution of this problem. When a product or category is saved it is not immediately re-indexed, but put into a queue. The queue is re-indexed in the background. This greatly speeds up the backend. This mechanism is implemented by using an extension of http://mirasvit.com/magento-extensions/magento-asynchronous-reindex.html.

    Even in case you place online shop even on a good hosting, sometimes the products, categories and attributes are saved slowly. This is due to the need to clear the cache and run re-indexing of stored items.

    ReplyDelete
  12. UnknownOctober 5, 2015 at 5:17 AM

    Magento Enterprise Edition 1.14.2 now comes with Google Tag Manager so merchants can more easily add tracking tags to a Magento site for audience measurement, personalization, retargeting, search engine marketing, and more without modifying code.

    regards-
    Magento and Ecommerce solution

    ReplyDelete
  13. Bela DoveNovember 14, 2015 at 4:03 AM

    I am happy that I found your post while searching for informative post about magento developer. It is really informative and quality of the content is extraordinary.

    ReplyDelete
  14. AndieDecember 14, 2015 at 12:41 AM

    Great read! I will come back for more :)

    Florida Magento Developer

    ReplyDelete
  15. UnknownApril 5, 2016 at 3:32 AM

    Nice post . i will come back for more .
    Joomla web design

    ReplyDelete
  16. UnknownJanuary 9, 2017 at 11:07 PM

    Ecommerce websites attract thousands of buyers by offering great deals and better prices.Lots of ecommerce websites are being developed in order to fulfill market demands
    eCommerce Development Services Company in Bangalore | Magento developers in Bangalore

    ReplyDelete
  17. UnknownJanuary 29, 2017 at 9:51 PM

    This is a great post. I like this topic.This site has lots of advantage. It helps me in many ways.Thanks for posting this again.
    magento development company in bangalore 

    ReplyDelete
  18. Aneeza SehrishMarch 2, 2017 at 10:31 PM

    i want to say thank you for these Latest News updates
    This is the best post. Thank you for posting this.

    ReplyDelete
  19. Ancy merinaMarch 2, 2018 at 3:43 AM

    This comment has been removed by the author.

    ReplyDelete
  20. UnknownApril 6, 2018 at 1:06 AM

    Thanks for this information.......That's wonderful stuff you've written up here. Been searching for it all around. Great blog
    Ecommerce Website Design and Development Company In Bangalore|Magento Ecommerce website Development company

    ReplyDelete
  21. Zinavo-Web Design | Web Development | SEO | Mobile Apps | ERP/CRMApril 10, 2018 at 1:04 AM

    That's wonderful stuff you've written up here. Been searching for it all around. Great blog.. Website Development Bangalore | Web Designing Company Bangalore

    ReplyDelete
  22. SARA MARKApril 20, 2018 at 11:47 PM

    Thank You for sharing and its interesting to know new things, Great.
    Language Translation Services ,
    Subtitling Companies in Bangalore

    ReplyDelete
  23. devidnayanaJune 1, 2018 at 4:40 AM




    I am very happy when read this blog post because blog post written in good manner and write on
    good topic. Thanks for sharing valuable information.

    School Information Management System,
    Online Fee Payment Integration
    College Management System

    Message

    ReplyDelete
  24. lukejamie07September 1, 2018 at 11:49 AM

    Thank you for sharing your experiences,It will definitely helpful for others.

    Medical app development

    ReplyDelete
  25. Web Solution WinnersApril 23, 2019 at 2:52 AM

    I have read your article and would like to thank you for all the information. Web Solution Winner

    ReplyDelete
  26. Freelance To IndiaMay 23, 2019 at 12:06 AM

    Thank you for sharing Social Book marketing website list. Freelance To India also providing https://www.freelancetoindia.com/social-media-marketing/ services

    ReplyDelete
  27. Emma KingDecember 1, 2021 at 7:02 AM



    Thanks for Sharing Great post

    Buy Plants Online in India
    Hoya Kerrii, Heart Leaf Plant
    Buy Handicrafts Online
    Moon Cactus

    Book Resin Planter

    Buy Planter Pot & Flower Stands
    Buy
    Succulents & Cactus
    Buy Planter Pot & Flower Stands

    ReplyDelete
  28. MaryjainOctober 3, 2024 at 5:50 AM

    Thanks for sharing valuable Information.

    Adobe Commerce Agency
    Magento Partner Company

    ReplyDelete

Subscribe to: Post Comments (Atom)