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.
asked Jan 11, 2016 at 10:57
Mathew
7832 gold badges16 silver badges40 bronze badges
-
can you post your mysql error log?MagenX– MagenX2016年01月11日 12:29:47 +00:00Commented 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/
answered Jan 11, 2016 at 11:01
Matthéo Geoffray
2,7042 gold badges21 silver badges45 bronze badges
-
But why this is happening.Mathew– Mathew2016年01月11日 11:04:00 +00:00Commented 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.logfile you probably see this error.Matthéo Geoffray– Matthéo Geoffray2016年01月11日 11:05:22 +00:00Commented Jan 11, 2016 at 11:05 -
My FTP also stop working.Mathew– Mathew2016年01月11日 11:06:32 +00:00Commented 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.Matthéo Geoffray– Matthéo Geoffray2016年01月11日 11:09:15 +00:00Commented Jan 11, 2016 at 11:09
Explore related questions
See similar questions with these tags.
default