Jump to content

Slow Load Time & HTTP 500 Internal Server Error


gavz

Recommended Posts

Hi there,

 

I'm experiencing Slow Load Time & HTTP 500 Internal Server Error issue on my website.  This is experienced from the front end with most webpages.  I'm not trying to do anything exhaustive, just browse the site's pages.

 

I've followed this advice http://www.prestashop.com/blog/en/the-500-internal-server-error-explained-solved/:

- turned on Error Reporting in PrestaShop: with no improvement

- adjusted Permissions: with no improvement

- regenerate .htaccess file: with no improvement

 

I have cPanel error logs if you would like to view them?

 

Thank you

 

 

Link to comment
Share on other sites

Did you try to enable profiling?

 

I have now.  Here is the result:

 

Load time53.431s

You'd better run your shop on a toaster
  • config: 35.629s
  • constructor: 0ms
  • init: 2.355s
  • checkAccess: 0ms
  • setMedia: 23ms
  • postProcess: 0ms
  • initHeader: 0ms
  • initContent: 8.773s
  • initFooter: 6.008s
  • display: 644ms
Hook processing15.201s / 13.05 Mb

67 methods called in 42 modules

  • displayFooter: 6.008s / 0.98 Mb
  • displayTop: 4.615s / 2.38 Mb
  • displayHomeTab: 1.229s / 0.09 Mb
  • displayHome: 1.063s / 0.22 Mb
  • displayHomeTabContent: 737ms / 0.43 Mb
  • displayHeader: 602ms / 8.84 Mb
  • displayLeftColumn: 525ms / 0.05 Mb
  • displayTopColumn: 421ms / 0.05 Mb
  • moduleRoutes: 0ms / 0 Mb
  • actionObjectAddAfter: 0ms / 0 Mb
  • actionFrontControllerSetMedia: 0ms / 0 Mb
  • displayBanner: 0ms / 0 Mb
  • actionObjectAddBefore: 0ms / 0 Mb
  • DisplayOverrideTemplate: 0ms / 0 Mb
  • actionObjectConnectionAddAfter: 0ms / 0 Mb
  • actionObjectConnectionAddBefore: 0ms / 0 Mb
  • actionDispatcher: 0ms / 0 Mb
  • displayNav: 0ms / 0 Mb
Memory peak usage23.8 Mb
  • config: 6.47 Mb (6.5 Mb)
  • constructor: 0 Mb (6.5 Mb)
  • init: 3.22 Mb (9.7 Mb)
  • checkAccess: 0 Mb (9.7 Mb)
  • setMedia: 0.2 Mb (9.9 Mb)
  • postProcess: 0 Mb (9.9 Mb)
  • initHeader: 0 Mb (9.9 Mb)
  • initContent: 12.03 Mb (22.1 Mb)
  • initFooter: 0.99 Mb (23 Mb)
  • display: 0.38 Mb (23.8 Mb)

 

Total cache size (in Cache class)0.27 Mb

DB type: DbPDO 

SQL Queries77 queries 

Time spent querying52.066s

Included files: 216

Size of included files2.92 Mb

Globals (> 1 Ko only): 190 Ko
  • _MODULES ≈ 112.5 Ko
  • _LANG ≈ 60 Ko
  • _SERVER ≈ 8.2 Ko
  • _REQUEST ≈ 1.7 Ko
  • _COOKIE ≈ 1.7 Ko
Link to comment
Share on other sites

Whaow, are you really running on a toaster? :-)

Ask your hosting provider, config should not be that long (35s)

I think the problem comes from your MySQL server which taks almost all the time.

 

How do I adjust the config?  Godaddy have advised that the MySQL server has no known issues.  They are not able to optimise the database for me.

Link to comment
Share on other sites

here is something you can try...

 

set these to yes

 

12.07.2014-08.59.png

http://screencast.com/t/8gvvL7hn

 

see if improvement....what we want to find out is some module has created this issue.

 

Before doing the above, Mail alerts by PrestaShop was throwing the below error.  I tried updating the module but the problem still existed.  I disabled the module & now the site seems to be working fine.

 

Does this sound familiar?

 

 

[PrestaShopDatabaseException]

Unknown column 'id_shop' in 'where clause'

 

            SELECT *

            FROM `ps_mailalert_customer_oos`

            WHERE (id_customer=20 OR customer_email='[email protected]')

            AND `id_product` = 557

            AND `id_product_attribute` = 0

            AND `id_shop` = 1

at line 635 in file classes/db/Db.php

 

629.             WebserviceRequest::getInstance()->setError(500, '
 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

630.         }

631.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

632.         {

633.             if ($sql)

634.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

635.             throw new PrestaShopDatabaseException($this->getMsgError());

636.         }

637.     }

638.

639.     /**

Link to comment
Share on other sites

I suppose the question is what is your PrestaShop version and mail alerts module version.  I did not search on the error to see if similar issue reported, did you?

 

Disabling Mail alerts v3.4.4 was only a temporary fix.  The speed has deteriorated again & I'm occasionally receiving "HTTP 500 Internal Server Error".  I'm using PS 1.6.0.6.

 

Disabling non PrestaShop modules & disabling all overrides has helped improve performance.  What would you suggest I do next?

Link to comment
Share on other sites

if disabling overrides and modules help performance, this tells us that there is 3rd party module(s) area likely creating issue.

 

Reverse changes over/mod disable.

 

Disable one by one modules you may have installed (note some modules with overrides may not be coded for 'disable', uninstall will ensure override not executed.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...