Problem long waiting time after upgrade

[mizuplus]

After upgrade from ps 1.5.4.0. with db mysql 5.1 to ps 1.5.6.0. with db mariaDB 5.5 is waiting time on site www.slovakiawine.eu more than 10 seconds. I have a multistore with pultiple languages.

 

I alredy done:

 

      in prestashop

      Smarty:

           Template chache: Never recompile template files

            Cache: 

            Debug console: Do not open console

      Optional features:

            Combinations:

            Features:

      CCC:

            Smart cache for CSS: Use CCC for CSS 

            Smart cache for JavaScript: Use CCC for JavaScript 

            Minify HTML: Minify HTML afer smarty compile execution 

            Compress inline JavaScript in HTML: Compress inline JavaScript in HTML after Smarty.... 

            Apache optimization 

      Ciphering

            Algorithm: Use Rijndael with mcrypt lib

      Caching:

            Use cache: 

            Caching system: Memcached

 

 

My hosting company provide 

       HTTP Acceleration

               PHP cache 

               Varnish

 

This is actual information about configuration

 

Server information

Server information: Linux #1 SMP Debian 3.2.41-2+deb7u2~bpo60+1 x86_64

Server software version: Apache

PHP version: 5.3.13

Memory limit: 128M

Max execution time: 30

Database information

MySQL version: 5.5.28a-MariaDB-log

MySQL engine: InnoDB

Tables prefix: ps_

Store information

PrestaShop version: 1.5.6.0

Shop URL: http://mizuplus.eu/

Current theme in use: mizuplustheme

Mail configuration

Mail method: You are using the PHP mail function.

Your information

Your web browser: Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.57 Safari/537.36

 

I am realy frustrated about this can anyone help pls

[patrmich]

Hi,

 

I am meeting the same kind of problem (long waiting time or long Time To First Byte) after migration from 1.4.7.0 to 1.5.6.0.

 

mizuplus, did you solve your problem since you posted your message in November ?

 

Thank you in advance.

 

Patrick

[csschopper.com]

The response time for 1.4.7.0 was correct? If not then problem with server response time.

[patrmich]

My TTFB under Prestashop 1.4.7.0 was between 500 and 1000 ms, rather good.

 

Under 1.5.6, on the same server, the TTFB had grown to 20 seconds

In phpMyAdmin, I verified all the tables. The TTFB decreased to 3 to 5 seconds, still too high.

 

I increased the RAM on the server, with nealy no effect.

 

I deleted all unnecessary modules, with no effect.

[palohrabak]

I'm facing the same problem on clean installation of PS 1.5.6.2 on MySQL 5.1 with custom theme and 3000+ products. Load time is more than 10 sec. I see 2 errors for each request in web server log.

 

[proxy_http:error] [pid 22919:tid 140654390695680] (20014)Internal error: [client 147.xxx.xxx.xxx:52600] AH01102: error reading status line from remote server 127.0.0.1:81, referer http://xxxxxxxxxx.sk/

 

[proxy:error] [pid 22919:tid 140654390695680] [client 147.xxx.xxx.xxx:52600] AH00898: Error reading from remote server returned by /index.php, referer http://xxxxxxxxxxxxxx.sk/

 

but I don't know if they are related to slow response time.

 

EDIT - Solution

--------------------------------------------

Errors ware caused by problem on the webhosting provider side.

Long load time was caused by allowed Memcached in Advanced parameter -> Performance. After I disabled Memcached and allowed HTTP cache and Xcache on webhosting provired side, load time decreased to 1-2 seconds.

Edited July 15, 2014 by palohrabak (see edit history)

[patrmich]

Hi,

 

I solved the problem of long waiting time after upgrade, specifically for the product list page, by deleting the attribute selection in the SQL query.

 

I found the suggestion here :

http://www.prestashop.com/forums/topic/253715-fight-with-speed-now-sql-problem/

 

Hope it can help.

 

Patrick