Post by shamim6277 » Fri Jun 11, 2021 7:17 pm

Hello,
I have some problem with my website. when I will go to admin panel or upload a product then, my server take too many sql Query Like this "Sending data SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_d"
Image

this way, my website is down.
You can tell me what's solution? Please

Opencart Version 3.0.3.3,
Server: VPS, 6 core, 16 GB RAM
theme: journal 3

info me please!
samim
thanks!
Last edited by shamim6277 on Fri Jun 11, 2021 8:11 pm, edited 1 time in total.

User avatar
Newbie

Posts

Joined
Fri Jun 11, 2021 7:13 pm

Post by straightlight » Fri Jun 11, 2021 8:05 pm

A 6 core, 16G RAM where store owners could run Opencart on a less resourced server with these SQL queries is definitely questionable regarding this error message on that side prior to point out the addressed issue originating from the platform. In addition, it is to know if your VPS server is a managed or unmanaged server and how many data you're currently handling from the database.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by shamim6277 » Fri Jun 11, 2021 8:16 pm

straightlight wrote:
Fri Jun 11, 2021 8:05 pm
A 6 core, 16G RAM where store owners could run Opencart on a less resourced server with these SQL queries is definitely questionable regarding this error message on that side prior to point out the addressed issue originating from the platform. In addition, it is to know if your VPS server is a managed or unmanaged server and how many data you're currently handling from the database.
website product number : 4044 .
category number: 600

User avatar
Newbie

Posts

Joined
Fri Jun 11, 2021 7:13 pm

Post by straightlight » Fri Jun 11, 2021 8:17 pm

shamim6277 wrote:
Fri Jun 11, 2021 8:16 pm
straightlight wrote:
Fri Jun 11, 2021 8:05 pm
A 6 core, 16G RAM where store owners could run Opencart on a less resourced server with these SQL queries is definitely questionable regarding this error message on that side prior to point out the addressed issue originating from the platform. In addition, it is to know if your VPS server is a managed or unmanaged server and how many data you're currently handling from the database.
website product number : 4044 .
category number: 600
How about this query in your PHPMyAdmin console:

Code: Select all

SELECT SUM(TABLE_ROWS) 
     FROM INFORMATION_SCHEMA.TABLES 
     WHERE TABLE_SCHEMA = '{your_db}';
by also replacing:

Code: Select all

{your_db}
with your actual Opencart database name. What is the returned records count?

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by shamim6277 » Fri Jun 11, 2021 8:29 pm

straightlight wrote:
Fri Jun 11, 2021 8:17 pm
shamim6277 wrote:
Fri Jun 11, 2021 8:16 pm
straightlight wrote:
Fri Jun 11, 2021 8:05 pm
A 6 core, 16G RAM where store owners could run Opencart on a less resourced server with these SQL queries is definitely questionable regarding this error message on that side prior to point out the addressed issue originating from the platform. In addition, it is to know if your VPS server is a managed or unmanaged server and how many data you're currently handling from the database.
website product number : 4044 .
category number: 600
How about this query in your PHPMyAdmin console:

Code: Select all

SELECT SUM(TABLE_ROWS) 
     FROM INFORMATION_SCHEMA.TABLES 
     WHERE TABLE_SCHEMA = '{your_db}';
by also replacing:

Code: Select all

{your_db}
with your actual Opencart database name. What is the returned records count?
Image

User avatar
Newbie

Posts

Joined
Fri Jun 11, 2021 7:13 pm

Post by straightlight » Fri Jun 11, 2021 8:30 pm

As instructed above, you also need to remove the: { and } between the database name.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by by mona » Fri Jun 11, 2021 8:31 pm

Those are the normal product queries, one for every product you list in your product list so approx. 20 queries or so.
If your server goes down because of those queries, you have other issues.
Even without proper indexes on the related tables this should be no issue for even the oldest machine.

PS. better activate your windows license.

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by straightlight » Fri Jun 11, 2021 8:32 pm

So to add:
theme: journal 3
Is not supported on the forum.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by shamim6277 » Fri Jun 11, 2021 8:33 pm

straightlight wrote:
Fri Jun 11, 2021 8:30 pm
As instructed above, you also need to remove the: { and } between the database name.
Thanks... SUM(TABLE_ROWS) is
7681947

User avatar
Newbie

Posts

Joined
Fri Jun 11, 2021 7:13 pm

Post by straightlight » Fri Jun 11, 2021 8:34 pm

shamim6277 wrote:
Fri Jun 11, 2021 8:33 pm
straightlight wrote:
Fri Jun 11, 2021 8:30 pm
As instructed above, you also need to remove the: { and } between the database name.
Thanks... SUM(TABLE_ROWS) is
7681947
That also explains some of it. See by freeing up your activity and session tables if that will help.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by shamim6277 » Fri Jun 11, 2021 8:36 pm

straightlight wrote:
Fri Jun 11, 2021 8:34 pm
shamim6277 wrote:
Fri Jun 11, 2021 8:33 pm
straightlight wrote:
Fri Jun 11, 2021 8:30 pm
As instructed above, you also need to remove the: { and } between the database name.
Thanks... SUM(TABLE_ROWS) is
7681947
That also explains some of it. See by freeing up your activity and session tables if that will help.
How can I do that please help me! :'(

User avatar
Newbie

Posts

Joined
Fri Jun 11, 2021 7:13 pm

Post by straightlight » Fri Jun 11, 2021 8:40 pm

shamim6277 wrote:
Fri Jun 11, 2021 8:36 pm
straightlight wrote:
Fri Jun 11, 2021 8:34 pm
shamim6277 wrote:
Fri Jun 11, 2021 8:33 pm

Thanks... SUM(TABLE_ROWS) is
7681947
That also explains some of it. See by freeing up your activity and session tables if that will help.
How can I do that please help me! :'(
If you don't know how to use PHPMyAdmin, you could either look on Google, create a new service request in the Commercial Support section of the forum, or contact me directly via PM on the forum to get this done as a custom job.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by paulfeakins » Mon Jun 14, 2021 5:53 pm

shamim6277 wrote:
Fri Jun 11, 2021 8:36 pm
How can I do that please help me! :'(
If you can't do that, you could pay a developer such as ourselves or post a job in the Commercial Support Forum.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Who is online

Users browsing this forum: jagall, moreduff and 267 guests