SSD or HDD for 1GB DB or CPU, RAM?

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

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.

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.

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.

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

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?

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