haunter Posted January 20, 2014 Share Posted January 20, 2014 Hi, we have aprox. 800 products, with a lot of special prices (total around 30 000), when we run http://eshop.xxx.xxx/modules/blocklayered/blocklayered-price-indexer.php?token=xxx&full=1 in mysql admin processes we can see this script opened around 5 times still opened and it wont close... I tried to add mysql_close, exit, flush... Maybe make mysql_close thru Db class? Link to comment Share on other sites More sharing options...
haunter Posted January 20, 2014 Author Share Posted January 20, 2014 For now seems to be solved with: mysql_close, but we will wait until tomorrow on next cron call... Link to comment Share on other sites More sharing options...
haunter Posted March 26, 2014 Author Share Posted March 26, 2014 Great, now in php processes we can see opened blocklayered-price-indexer.php around 100 times!!! (count is changing). I tried to insert to table log row every time the file is called (with time count) and after indexing there are around 200 rows, time is aprox. 200 seconds Link to comment Share on other sites More sharing options...
haunter Posted March 27, 2014 Author Share Posted March 27, 2014 Great, solved!!! In blocklayered.php, function indexPrices is function for calling again price indexation if last 100 of products timed out BUT (!!!) the $max_executiontime is forced setted to 5s, which is too small (in our script, indexation runs max aprox. 50s). so the script called all day again and again indexation.... I changed $max_executiontime to our server value which is 80s and now the processes and DB is clean Link to comment Share on other sites More sharing options...
Recommended Posts