1

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 '16 at 12:29
2

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/

| improve this answer | |
  • But why this is happening. – Mathew Jan 11 '16 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. – Matthéo Geoffray Jan 11 '16 at 11:05
  • My FTP also stop working. – Mathew Jan 11 '16 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. – Matthéo Geoffray Jan 11 '16 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.