This topic has 2 voices, contains 10 replies, and was last updated by  TB Support 2094 days ago.

Major issue with performance once the site goes live

ThemeBurn Support › Forums › OpenCart Themes › Kiddos OpenCart Theme › Major 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
 splashdesigns
June 27, 2018 at 1:03 pm #64718

Here is some further server information
 splashdesigns
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
 TB Support
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
 splashdesigns
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’ ?
 TB Support
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.
 splashdesigns
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 ?
 TB Support
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.
 splashdesigns
July 11, 2018 at 12:10 pm #64825

Hi,

Are there any other suggestions or ideas on this?

I have restored the site to a testing server and have turned on the caching options that allowed the site to function.
under page load performance the following are off as they break the site if turned on.

Image lazy loading
Bg lazy loading
Optimize JS
Defer JS

The config caching is turned off also.

The test site has now turned to returning a 504 gateway timeout. I have honestly never experienced any issues like this before.

Also, many of the product images appear to have disappeared after I turned the caching on.
 splashdesigns
July 25, 2018 at 4:36 pm #64972

Ok, the test site is now broken after the caching is turned on. None of the links work properly, the menu is broken, the slider on the homepage is broken. I could go on.
 splashdesigns
July 26, 2018 at 12:59 pm #64978

Your issue is really hard for us, as we didn’t have such one till now (several years). There are many people here, who use our themes on relatively cheap shared hosting with far fewer resources than yours, so we can’t just see what’s wrong in our code as the issue probably depends on your personal server setup somehow.

Can we receive access (FTP) to your test environment so we can see the issue in action and eventually come out with a fix ? Also can we have access to your server logs (apache/mysql/php) in order to check what is going on?

Regards,
ThemeBurn team
 TB Support
July 27, 2018 at 3:07 pm #64994
Viewing 11 posts - 1 through 11 (of 11 total)
  • You must be logged in to reply to this topic.