I am working on my module. I create a store , website and other related information programatically. It is successfully created. But when i reindex data from admin panel my mysql stop working. I don't know what is problem. Let me know how can i solve this problem.

  • can you post your mysql error log?
    – MagenX
    Jan 11, 2016 at 12:29

1 Answer 1


You have to increase your MySQL performances especially if you are working on a development machine.
You can follow websites as it http://astrio.net/blog/magento-performance-optimize-mysql/ to optimize your MySQL config for Magento.
For reindexation prefer with command line : https://www.branded3.com/blog/re-indexing-magento-command-line/

  • But why this is happening.
    – Mathew
    Jan 11, 2016 at 11:04
  • Your MySQL server has probably gone away, not enough resources to execute all reindexes. If you take a look at logs in /var/log/exception.log file you probably see this error. Jan 11, 2016 at 11:05
  • My FTP also stop working.
    – Mathew
    Jan 11, 2016 at 11:06
  • Technically there is no link between Magento indexes and your FTP. In this case this must be a server issue, not a Magento one. Can you try my first answer, in any case you have to increase MySQL performances. Jan 11, 2016 at 11:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.