Major issue with performance once the site goes live

ThemeBurn SupportForumsOpenCart ThemesKiddos OpenCart ThemeMajor issue with performance once the site goes live

This topic has been marked as not resolved.

Hi there,

we built an opencart website using the kiddos theme. The site performs as expected in a testing environment but once we put the site live it lasts about 10 minutes before it dies. It generates a 508 error. I have spoken to the hosting provider and they say that the issue is being caused by slow mysql queries.
I have turned on caching fully and this has resulted in the admin area being stuck on the save settings screen for the last 10 minutes.

Should I attempt to access the site front end I get the following error message:

Notice: Undefined property: DB::$db in /var/www/vhosts/thinkingtoyscloud.com/httpdocs/system/storage/modification/system/library/db.php on line 63
Fatal error: Call to a member function query() on null in /var/www/vhosts/thinkingtoyscloud.com/httpdocs/system/storage/modification/system/library/db.php on line 65

The admin section has now crashed and should I attempt to enter it again I see the following error
Fatal error: Call to a member function query() on null in /var/www/vhosts/thinkingtoyscloud.com/httpdocs/system/storage/modification/system/library/db.php on line 65

June 27, 2018 at 1:03 pm #64718

Here is some further server information

June 27, 2018 at 1:52 pm #64719

Is it possible to test with the default theme to see if the hosting can handle it ? Also what are the hosting parameters (shared/VPS/dedicated; CPU; RAM etc.) ?

Regards,
ThemeBurn team

July 4, 2018 at 10:38 am #64749

Hi,

I have tested this on 2 servers the configuration on the 1st one is as follows:
VPS
CPU Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz (2 core(s))
Version Plesk v12.5.30_build1205150826.19 os_RedHat el5
OS CloudLinux Server 5.11 (Vladislav Volkov)
RAM 2GB

the 2nd one is as follows
Shared Hosting
Hosting Package ECom
Server Name uk3
cPanel Version 72.0 (build 7)
Apache Version 2.4.33
PHP Version 5.6.36
MySQL Version 5.6.39
Architecture x86_64
Operating System linux
Shared IP Address 176.58.97.71
Path to Sendmail /usr/sbin/sendmail
Path to Perl /usr/bin/perl
Perl Version 5.10.1
Kernel Version 2.6.32-896.16.1.lve1.4.53.el6.x86_64
Ram 2GB
CPU 2 Cores (I have requested the model from the hosting provider)

The behaviour is identical once the site goes live on either server. The site lasts approximately 10 minutes before it dies citing a 508 resource error.

The hosting provider has also stated that the issue as far as they are concerned is very “heavy” mysql queries towards the database resulting in high CPU usage and affecting the normal operation of the mysql service.

I’ll include a sample query list here

July 4, 2018 at 12:21 pm #64754

Is it possible to change to the default opencart theme and test if it brings the server to ’508 error’ ?

July 4, 2018 at 1:41 pm #64757

Hi,

thanks for the reply.

I have tested the default theme and the site ran as expected. I left it running for 1 hour before switching back. Within 10 minutes the 508 error resurfaced.

July 5, 2018 at 12:09 pm #64783

Okay, I assume all of the cache options are turned on in the BurnEngine admin panel, are they ?

July 5, 2018 at 3:35 pm #64784

Hi,

that’s part of the issue. When I turn the cache options on this results in the admin area being stuck on the save settings screen. This eventually times out. Then should I attempt to access the site front end I get the following error message:
Notice: Undefined property: DB::$db in /var/www/vhosts/thinkingtoyscloud.com/httpdocs/system/storage/modification/system/library/db.php on line 63
Fatal error: Call to a member function query() on null in /var/www/vhosts/thinkingtoyscloud.com/httpdocs/system/storage/modification/system/library/db.php on line 65

Should I try to access the admin section I see the following error:
Fatal error: Call to a member function query() on null in /var/www/vhosts/thinkingtoyscloud.com/httpdocs/system/storage/modification/system/library/db.php on line 65

I have had to fully restore this test site from a backup the get it back up and running again.

July 11, 2018 at 12:10 pm #64825
Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.