kg4geq Posted May 14, 2014 Share Posted May 14, 2014 (edited) I upgraded to 1.6 and moved my old 1.5.4.1 site that was on shared hosting over to VPS (a2hosting). I have 10gb hdd (ssd faster speed), 1gb memory, 200gb bandwith, 4cpus. Since it's a VPS, I installed PECL and enabled memcached and have force compile turned off as well as the other recommended live site settings. Including browser cache in the .htaccess file. The backoffice loads quickly, however the front office (site) loads extremely slow...usually appx 30secs. I ran debug and got this output. Can anyone give me some suggestions on how to get the front page to load quicker? maybe disable modules? (the actual product pages load considerably quicker, but the debug page still assumed it was on shared hosting.) Load time: 22.702sYou'd better run your shop on a toasterconfig: 77ms constructor: 0ms init: 36ms checkAccess: 0ms setMedia: 8ms postProcess: 0ms initHeader: 0ms initContent: 22.505s initFooter: 22ms display: 53ms Hook processing: 22.538s / 21.79 Mb51 methods called in 35 modulesdisplayHome: 22.275s / 12.9 Mb displayHeader: 199ms / 7.33 Mb displayTop: 30ms / 0.87 Mb displayFooter: 22ms / 0.43 Mb displayCustomerAccount: 5ms / 0.06 Mb displayFooterSocialLinks: 3ms / 0.09 Mb displayHeaderSearchBlock: 3ms / 0.08 Mb displayHeaderMenu: 1ms / 0.03 Mb moduleRoutes: 0ms / 0 Mb displayHomeTab: 0ms / 0 Mb displayHomepageSlider: 0ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb DisplayOverrideTemplate: 0ms / 0 Mb displayHomeTabContent: 0ms / 0 Mb Memory peak usage: 34.4 Mbconfig: 6.73 Mb (6.9 Mb) constructor: 0 Mb (6.9 Mb) init: 3.46 Mb (10.2 Mb) checkAccess: 0 Mb (10.2 Mb) setMedia: 0.21 Mb (10.4 Mb) postProcess: 0 Mb (10.4 Mb) initHeader: 0.01 Mb (10.4 Mb) initContent: 21.12 Mb (32.2 Mb) initFooter: 0.44 Mb (32.6 Mb) display: 1.32 Mb (34.4 Mb) Total cache size (in Cache class): 0 Mb DB type: DbPDO SQL Queries: 717 queries Time spent querying: 21.914s Included files: 237Size of included files: 2.9 Mb Globals (> 1 Ko only): 832 Ko_MODULES ≈ 547.8 Ko _LANG ≈ 172.4 Ko context ≈ 93.4 Ko _SERVER ≈ 7.4 Ko _MODULE ≈ 5.1 Ko _COOKIE ≈ 2.2 Ko Edited May 14, 2014 by kg4geq (see edit history) Link to comment Share on other sites More sharing options...
JPresta.com Posted May 14, 2014 Share Posted May 14, 2014 A module in your displayHome hook is very slow and is probably the problem. First thing to do is to find which module is slowing down your site in this hook (disable them one after one). Link to comment Share on other sites More sharing options...
Tuinkoken Posted May 14, 2014 Share Posted May 14, 2014 Just a question in between. How do you get these load times visible? Link to comment Share on other sites More sharing options...
JPresta.com Posted May 14, 2014 Share Posted May 14, 2014 Just a question in between. How do you get these load times visible? By activating profiling Read this: http://www.inmotionhosting.com/support/edu/prestashop-15/348-enabling-debug-profiler Link to comment Share on other sites More sharing options...
Dh42 Posted May 14, 2014 Share Posted May 14, 2014 How many products do you have in your home category? I have found that having extra products that are not shown in it will slow a shop down. At the same time since you have pecl installed, I would disable memcache and install and enable apc with a 64mb shm. Also, you will need to change your php interpreter over to fcgi, but this should give you a noticeable speed boost. Link to comment Share on other sites More sharing options...
kg4geq Posted May 14, 2014 Author Share Posted May 14, 2014 Just an update...not fixed, but working on it. It was 2 modules in my theme that are a derivative of the native Featured Products that is causing the slowness. When those are both disabled, load time is acceptable (appx 4-6 secs), but the DB query time is still too slow....and there are no products showing on the home page..actually nothing shows since the product hooks are disabled. I just imported appx. 20,000 new products into the db and they need to be better categorized. When I 1-click upgraded from 1.5 to 1.6 all previous categories got rolled into my HOME category. I need to fix this as well. I ran some mysql commands (analyze, optimize, flush) to try and clean up the database. it is an innodb engine though so, optimize doesn't work. so I ran 'alter tables' which should in theory defrag it. So, I'm hoping after I go through and sort all the new products into their proper categories things will run faster. Thank you for the tips. I'll change the cache settings as you suggested too Dh42. Thanks again, -kg4geq Link to comment Share on other sites More sharing options...
trippodo Posted May 16, 2014 Share Posted May 16, 2014 hi, i have the same problem about 25 seconds to open the home page ... if i enable APC and FCGI, the time low down to 3 seconds but i am not able to generate the necessary feeds with the Google Merchant and the Amazon modules. My server is dedicated OVH server with centos 6.5 and plesk 11.5, 128GB Ram, 4Tb raid hardware hard disk and intel CPU with 8 core and 16 thread My store has over 50.000 products and 13.000 customers and is gradually updated from 1.3.0 to 1.6.0.6 thanks Alessandro Link to comment Share on other sites More sharing options...
JPresta.com Posted May 16, 2014 Share Posted May 16, 2014 hi, i have the same problem about 25 seconds to open the home page ... if i enable APC and FCGI, the time low down to 3 seconds but i am not able to generate the necessary feeds with the Google Merchant and the Amazon modules. My server is dedicated OVH server with centos 6.5 and plesk 11.5, 128GB Ram, 4Tb raid hardware hard disk and intel CPU with 8 core and 16 thread My store has over 50.000 products and 13.000 customers and is gradually updated from 1.3.0 to 1.6.0.6 thanks Alessandro Did you perform a profiling to identify bottleneck? Link to comment Share on other sites More sharing options...
Dh42 Posted May 16, 2014 Share Posted May 16, 2014 @sevenstore It sounds like your fcgi is timing out before the modules finish. There is a setting to raise the timeout, I would raise it. Link to comment Share on other sites More sharing options...
trippodo Posted May 16, 2014 Share Posted May 16, 2014 Did you perform a profiling to identify bottleneck? yes, i have enabled it just to verify (and now i have disabled it again) Link to comment Share on other sites More sharing options...
trippodo Posted May 16, 2014 Share Posted May 16, 2014 @sevenstore It sounds like your fcgi is timing out before the modules finish. There is a setting to raise the timeout, I would raise it. this is the fcgid.conf: FcgidIdleTimeout 40000 FcgidProcessLifeTime 72000 FcgidMaxProcesses 20000 FcgidMaxProcessesPerClass 80 FcgidMinProcessesPerClass 0 FcgidConnectTimeout 60000 FcgidIOTimeout 6000 FcgidInitialEnv RAILS_ENV production FcgidIdleScanInterval 10 with this configuration, the timeout is within 10 mins but the Amazon module takes 25 minutes each feed/ each marketplace Link to comment Share on other sites More sharing options...
Dh42 Posted May 16, 2014 Share Posted May 16, 2014 The amazon module is slow, I have used it before and had the same issues. I had to break it up into exporting only a few categories at a time. The only real way I found to get around it was to run it from local host so that the server is not bogged down during the whole time. There is a lot to be desired in how that module works in my opinion. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts