Post by magzen » Tue Sep 01, 2015 12:51 am

Hello,

Iam having some slowdown problems and "Databse Away" errors with my Opencart store.

Right now iam using hosting with 1vCore and 2GB Ram, so i guess thats causing the problem, and i got an email from my host

"Abusing requset :

SELECT p.product_id, (SELECT AVG(rating) AS total FROM
oc_review r1 WHERE r1.product_id = p.product_[...]

You take ovec 40.90% of CPU by yourself on the mysql
server."


So what would you with some experience recommend? More memory, more CPU or SSD?

/magzen

Active Member

Posts

Joined
Tue Jun 05, 2012 7:04 pm

Post by straightlight » Tue Sep 01, 2015 1:50 am

There are lots of hosting service that provides at least 6 times the requirements as their minimum requirements compared to the specs you mentioned above, these days. I would definitely look into a higher standard compliancy in order to match queries with today's compatibility elements.

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 sculptex » Tue Sep 01, 2015 6:27 pm

I agree with straightlght. its a false economy these days if your site is slow as customers will go elsewhere.

To answer your question though, I would say a single CPU is a definite no-no so CPU first, then memory, then HDD. more memory will result in more cache hits and there is cache built in to HDD anyway or if cloud shared hosting its pretty clever with its caching.
Also there are several mods to cache your website for super-fast load times, I would presume the average rating query above would also be cached by some of these mods.

ImageImage


User avatar
Active Member

Posts

Joined
Tue Sep 13, 2011 3:07 am
Location - UK

Post by straightlight » Tue Sep 01, 2015 6:42 pm

While query speed load may be a good opprtunity by modules, other restriction factors may be involved depending on server packaging deals offered. My personal view on this is there are many people wanting great service based on the fraction of time a page might take to load. Although, the rest for them would be secondary while opencart might require these features as primary.

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 magzen » Wed Sep 02, 2015 10:43 pm

straightlight wrote:There are lots of hosting service that provides at least 6 times the requirements as their minimum requirements compared to the specs you mentioned above, these days. I would definitely look into a higher standard compliancy in order to match queries with today's compatibility elements.
sculptex wrote:I agree with straightlght. its a false economy these days if your site is slow as customers will go elsewhere.

To answer your question though, I would say a single CPU is a definite no-no so CPU first, then memory, then HDD. more memory will result in more cache hits and there is cache built in to HDD anyway or if cloud shared hosting its pretty clever with its caching.
Also there are several mods to cache your website for super-fast load times, I would presume the average rating query above would also be cached by some of these mods.
Thanks for the replies, i got a dedicated server with following specs

KS-5 Xeon 2 x E5504 4997 8c / 8t 2 GHz+ 16 GB ECC 2 TB 100 Mbps

i think that should be enough for my website with 70,000 products x 3 languages 1GB DB?

/magzen

Active Member

Posts

Joined
Tue Jun 05, 2012 7:04 pm

Post by sculptex » Thu Sep 03, 2015 12:36 am

magzen wrote:
Thanks for the replies, i got a dedicated server with following specs

KS-5 Xeon 2 x E5504 4997 8c / 8t 2 GHz+ 16 GB ECC 2 TB 100 Mbps

i think that should be enough for my website with 70,000 products x 3 languages 1GB DB?

/magzen
Sounds like a great spec especially if its a true dedicated server not a VPS, but you have to judge it in a real world environment, so much depends on the datacentre setup and their network connections for example. I have two similar specced VPS and the slightly less specced one is soo much faster than the other??

is that SQL from a mod you have added? It can't find anything similar on my cart?

ImageImage


User avatar
Active Member

Posts

Joined
Tue Sep 13, 2011 3:07 am
Location - UK

Post by magzen » Wed Sep 23, 2015 5:25 am

sculptex wrote:
magzen wrote:
Thanks for the replies, i got a dedicated server with following specs

KS-5 Xeon 2 x E5504 4997 8c / 8t 2 GHz+ 16 GB ECC 2 TB 100 Mbps

i think that should be enough for my website with 70,000 products x 3 languages 1GB DB?

/magzen
Sounds like a great spec especially if its a true dedicated server not a VPS, but you have to judge it in a real world environment, so much depends on the datacentre setup and their network connections for example. I have two similar specced VPS and the slightly less specced one is soo much faster than the other??

is that SQL from a mod you have added? It can't find anything similar on my cart?
Sorry for late reply, it is true dedicated server located by a big company located in France, dont think iam allowed to mention it here, but they have very cheap prices on their dedicated servers and it only costs 30€ month compared to other popular webhosting where servers with less specs can cost 150-200€, it is selfmanaged which i find ok and easy to handle, the website is running much more smoothly compared to before and compared to my previous VPS where i paid 70$/month.

/magzen

Active Member

Posts

Joined
Tue Jun 05, 2012 7:04 pm
Who is online

Users browsing this forum: No registered users and 17 guests