Fr33mind Posted March 13, 2013 Share Posted March 13, 2013 Hi, I'm running a Prestashop v1.5.3.1 on a dedicated Debian Server. Every server query has a huge delay of about 10 to 15 seconds. Firebug reports only "wait" and phpmyadmin shows, that Prestashop has very long SLEEP querys on his database... Can anyone explain how could this happen or why the SLEEP is mandatory? Thanks Link to comment Share on other sites More sharing options...
vekia Posted March 13, 2013 Share Posted March 13, 2013 about which queries you are talking about and what about your store? is it huge? how many products etc? Link to comment Share on other sites More sharing options...
Fr33mind Posted March 13, 2013 Author Share Posted March 13, 2013 I've about 1100 products in my shop but the problem exists since start (About 10 products). Everytime i want to load a page, it lasts 10 to 15 seconds before a page loads... firebug says, that 95 percent of that me, it's only waiting... so i'm assume, that it is maybe a database issue and has something to do with the SLEEP and maybe locks/deadlocks on the database Link to comment Share on other sites More sharing options...
vekia Posted March 13, 2013 Share Posted March 13, 2013 and what about error log? have you got any errors? maybe some script have got long load-time, you should check apache / php error log Link to comment Share on other sites More sharing options...
Alex Simonchik BelVG Posted March 13, 2013 Share Posted March 13, 2013 (edited) Hi, Fr33mind, I think you are using slow server. Please give us your server configuration. Regards Edited March 13, 2013 by Alexander Simonchik (see edit history) Link to comment Share on other sites More sharing options...
janthemanson Posted March 13, 2013 Share Posted March 13, 2013 (edited) and what about error log? have you got any errors? maybe some script have got long load-time, you should check apache / php error log There are some entrys in the error-logs but these are only "files not found", and they are caused by failed saving processes in BO. I think you are using slow server. The same was told us in the german forum, but the server isn't slow. Firebug and other engines say that the data is delivered fast, but the time to first byte of the php file is such long. php self is generated and delivered quickly. Edited March 13, 2013 by janthemanson (see edit history) Link to comment Share on other sites More sharing options...
benjamin utterback Posted March 13, 2013 Share Posted March 13, 2013 Hi janthemanson, do you have any other details regarding your server configuration. Could you post a short part of the Server error log as well? This will help us find the source of the problem. Thank you! Link to comment Share on other sites More sharing options...
janthemanson Posted March 14, 2013 Share Posted March 14, 2013 The error logs are mostly empty. Only entrys of crawlers trying to access missing files, and some as I wrote before. Today I checked the INNODB MONITOR OUTPUT. The only thing I read out of this may be something with ps_search_index. I used to ask at http://dba.stackexchange.com/questions/36710/need-help-interpreting-innodb-monitor-output-for-prestashop-performance-problem for this kind of problem. Link to comment Share on other sites More sharing options...
Alex Simonchik BelVG Posted March 14, 2013 Share Posted March 14, 2013 janthemanson, do you use instant search or ajax search? Disable it feature will helps you, maybe... How many products in your store? Did you tru to rebuild search index? Regards Link to comment Share on other sites More sharing options...
janthemanson Posted March 15, 2013 Share Posted March 15, 2013 Yes, I rebuild search index, disabled and enabled ajax search, en-/disabled custom search module of the theme. Nothing changes. Seems to be a wrong path ... Link to comment Share on other sites More sharing options...
janthemanson Posted March 15, 2013 Share Posted March 15, 2013 Is it normal that indexed products are one missing? Rebuild indexing will not fix this issue ... Link to comment Share on other sites More sharing options...
janthemanson Posted March 18, 2013 Share Posted March 18, 2013 (edited) Is there a preferred DB transaction isolation level in prestashop? Maybe it should switched from REPEATABLE-READ to READ-COMMITTED to avoid locking tables and maybe the overhead? Edited March 18, 2013 by janthemanson (see edit history) Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts