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"
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!
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
website product number : 4044 .straightlight wrote: ↑Fri Jun 11, 2021 8:05 pmA 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.
category number: 600
How about this query in your PHPMyAdmin console:shamim6277 wrote: ↑Fri Jun 11, 2021 8:16 pmwebsite product number : 4044 .straightlight wrote: ↑Fri Jun 11, 2021 8:05 pmA 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.
category number: 600
Code: Select all
SELECT SUM(TABLE_ROWS)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '{your_db}';
Code: Select all
{your_db}
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
straightlight wrote: ↑Fri Jun 11, 2021 8:17 pmHow about this query in your PHPMyAdmin console:shamim6277 wrote: ↑Fri Jun 11, 2021 8:16 pmwebsite product number : 4044 .straightlight wrote: ↑Fri Jun 11, 2021 8:05 pmA 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.
category number: 600
by also replacing:Code: Select all
SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '{your_db}';
with your actual Opencart database name. What is the returned records count?Code: Select all
{your_db}
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
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
Is not supported on the forum.theme: journal 3
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Thanks... SUM(TABLE_ROWS) isstraightlight wrote: ↑Fri Jun 11, 2021 8:30 pmAs instructed above, you also need to remove the: { and } between the database name.
7681947
That also explains some of it. See by freeing up your activity and session tables if that will help.shamim6277 wrote: ↑Fri Jun 11, 2021 8:33 pmThanks... SUM(TABLE_ROWS) isstraightlight wrote: ↑Fri Jun 11, 2021 8:30 pmAs instructed above, you also need to remove the: { and } between the database name.
7681947
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
How can I do that please help me!straightlight wrote: ↑Fri Jun 11, 2021 8:34 pmThat also explains some of it. See by freeing up your activity and session tables if that will help.shamim6277 wrote: ↑Fri Jun 11, 2021 8:33 pmThanks... SUM(TABLE_ROWS) isstraightlight wrote: ↑Fri Jun 11, 2021 8:30 pmAs instructed above, you also need to remove the: { and } between the database name.
7681947
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.shamim6277 wrote: ↑Fri Jun 11, 2021 8:36 pmHow can I do that please help me!straightlight wrote: ↑Fri Jun 11, 2021 8:34 pmThat 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
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
Users browsing this forum: No registered users and 481 guests