Magento

I’m at my wits end. I have constant server timeouts when I do the following things:
- Save and apply a ‘catalog pricing rule’
- Reindex
- Run any PHP script which touches the product catalog (purpose built scripts)

I can run the reindex via SSH without problems. I don’t know how to run the pricing rules via SSH so cannot test that.

Also the frontend became slow (takes 5-10 seconds to show a product).

This happened from the time I uploaded a catalog of 17000 products. Before I had 150 products and no issues.

What did I try:
- Change settings of php.ini / my.cnf / httpd-mpm.conf / httpd.conf to allow larger timeouts
- Increase ‘timeout’ setting to 100 in /lib/Zend/Http/Client.php
- Repair and optimize mysql database tables

Any tips?

My installation:
- I have a dedicated Centos 5.7 LAMP server with PHP5, 8GB memory and quadcore.
- Magento 1.7.2 CE.
- 4 websites with one store each

hi
what you have in your error log?
timeouts means you have to set higher values.

slow page load usually because of database or faulty extension.

make sure you have correct settings
run few tuners and mysqlreport to check your actual workload.

cheers

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

Mirasvit - 12 March 2013 03:48 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

This shouldn’t be the root cause, as I have reindexing at ‘manual’, to avoid this problem.

MagenX - 04 January 2013 02:20 AM

hi
what you have in your error log?
timeouts means you have to set higher values.

slow page load usually because of database or faulty extension.

make sure you have correct settings
run few tuners and mysqlreport to check your actual workload.

cheers

Thanks for your suggestion.

I tried extreme timeout values, and still the timeout error persists.

Which error log should I look in? Kindly be specific with path and filename, so that I can check the right log.

hi
this actually needs some knowledge,
if you asking about file names and paths not sure what you actually configured there ..

send us a message, we can take a look at your config.

thank you