Another speed topic

[El_Matella]

Hi everyone,

 

I am desesperatly working on a PS 1.5 installation and I am having a lot of speed problems. My first time byte is more than 4 seconds. 

 

I tried a lot of things in the others posts. Here what I have already done:

 

• Install memcache and adding server configuration : No change
• Install xcache and see in the admin panel if xcache works well: xcache works well but PS not quicker
• Configure MySql query cache, set query_cache to 512 M: No effect
• Loging long MySql queries:  no queries taking more than 1sec to execute

If anyone has an idea where to look after all of this, I would be a happy man

 

Have a nice day,

 

PS: I am working on a dedicated server from OVH (not even a VPS)

 

PS2: Actually I have some long queries here what the log says:

 

# Time: 151007 12:04:38

# User@Host: root[root] @ localhost []

# Query_time: 2.000628  Lock_time: 0.000023 Rows_sent: 0  Rows_examined: 551299

SET timestamp=1444212278;

UPDATE `ps_customer_ip` SET `ip` = '56.313.229.250' WHERE `id_customer` = 0;

Edited October 7, 2015 by El_Matella (see edit history)

[musicmaster]

"ps_customer_ip" is not a regular Prestashop database table. So that should be caused by a plugin you are using. Also, it making changes for id_customer is zero doesn't make sense.

 

Another suggestion: try switching off all your statistics stuff and have a look at the size of your statistics tables (sorting in phpmyAdmin on size will tell you which are the biggest).