Page 1 of 1

VPS server settings - optimization for high speed

Posted: Sun Feb 07, 2021 5:23 pm
by ideep13
I have now moved to Namescheap VPS Quasar - https://www.namecheap.com/hosting/vps/.
I had to order 2 Tier - cpanel options because I have 2 OC stores, 3 WP stores and 2 blog sites (WP)
4 CPU Cores
6 GB RAM
120 GB SSD RAID 10
3000 GB Bandwidth
As I can see my sites now run even slower as before on Reseller hosting, so I would like to speed up server and sites if this is possible.
Speed Index for 3.0.3.6. store is 5,6 s and for other one who is running on 2.3.0.2. is 5s
Both sites are running through cloudflare (free account)
What is the best PHP-FPM settings for me. Please see screenshot for the system.. and I can change the settings on each individual domain.
I have changed the settings to one of my opencart store https://djecje-kucice.com that is on php 7.4., OC 3.0.3.6. , having unfortunately Journal theme 3 (I have everything on the the theme template regarding performance) The other opencart store is https://staskka.com php 7.3., OC 2.3.0.2 the same theme but 2, not 3
When I tried to change the PHP-FPM settings I received a server monitor error message.
Status Out of Memory ⚠
Memory Information
Used 3.77 GB
Available 2.06 GB
Installed 5.83 GB
“oom_dmesg.txt” I can not add document it doesn't allow me

I set max request 200
Max children 150
Processes 100
for the site 3.0.3.6 but I got memory error so I moved back to default

Can I optimize those sites at all to run it faster? And what is my first step how to optimize a server ?
I have removed exec() for one of the opencart stores, so it suppose to be enabled now.

Where can I see which libraries I have installed (brotli, ect..)?

Re: VPS server settings - optimization for high speed

Posted: Sun Feb 07, 2021 8:02 pm
by khnaz35
First optimise your Database and see if anything change for you. The rest is next step make one change at the time and then see what is impact.

Re: VPS server settings - optimization for high speed

Posted: Sun Feb 07, 2021 10:47 pm
by ideep13
khnaz35 wrote:
Sun Feb 07, 2021 8:02 pm
First optimise your Database and see if anything change for you. The rest is next step make one change at the time and then see what is impact.
Yes I would like to learn this as well - can you advise me how to optimize DB?
IS there a good plugin for this? I found this: https://www.opencart.com/index.php?rout ... ityScripts

Or a good read from the internet by step by step instructions and by providing the link?
This module doesn't work and breaks my site. https://webocreation.com/blog/10-ways-t ... imization/
The size of my DB is 24 MB.
I should have installed this turbo.pho script, but there no documentation so I don't know where to install it, so I rather ran commands in SQL.

Code: Select all

ALTER TABLE `oc_category` ADD INDEX ( `parent_id` ) ;
ALTER TABLE `oc_category` ADD INDEX ( `top` ) ;
ALTER TABLE `oc_category` ADD INDEX ( `sort_order` ) ;
ALTER TABLE `oc_category` ADD INDEX ( `status` ) ;
ALTER TABLE `oc_category_description` ADD INDEX ( `language_id` );
ALTER TABLE `oc_category_to_store` ADD INDEX ( `store_id` );
ALTER TABLE `oc_category_path` ADD INDEX ( `path_id` );
ALTER TABLE `oc_product` ADD INDEX ( `model` ) ;
ALTER TABLE `oc_product` ADD INDEX ( `sku` ) ;
ALTER TABLE `oc_product` ADD INDEX ( `upc` ) ;
ALTER TABLE `oc_product` ADD INDEX ( `manufacturer_id` ) ;
ALTER TABLE `oc_product` ADD INDEX ( `sort_order` ) ;
ALTER TABLE `oc_product` ADD INDEX ( `status` ) ;
ALTER TABLE `oc_product_option` ADD INDEX ( `option_id` ) ;
ALTER TABLE `oc_product_option_value` ADD INDEX ( `product_option_id` ) ;
ALTER TABLE `oc_product_option_value` ADD INDEX ( `product_id` ) ;
ALTER TABLE `oc_product_option_value` ADD INDEX ( `option_id` ) ;
ALTER TABLE `oc_product_option_value` ADD INDEX ( `option_value_id` ) ;
ALTER TABLE `oc_product_to_category` ADD INDEX ( `category_id` );
ALTER TABLE `oc_product_attribute` ADD INDEX ( `attribute_id` );
ALTER TABLE `oc_product_attribute` ADD INDEX ( `language_id` );
ALTER TABLE `oc_product_description` ADD INDEX ( `language_id` );
ALTER TABLE `oc_product_to_store` ADD INDEX ( `store_id` );
ALTER TABLE `oc_option` ADD INDEX ( `sort_order` ) ;
ALTER TABLE `oc_option_description` ADD INDEX ( `name` ) ;
ALTER TABLE `oc_option_value` ADD INDEX ( `option_id` ) ;
ALTER TABLE `oc_option_value_description` ADD INDEX ( `option_id` ) ;
ALTER TABLE `oc_url_alias` ADD INDEX ( `query` ) ;
ALTER TABLE `oc_url_alias` ADD INDEX ( `keyword` ) ;
ALTER TABLE `oc_url_alias` ADD INDEX ( `url_alias_id` );
these 3 doesn't exist in my DB:

Code: Select all

ALTER TABLE `oc_url_alias` ADD INDEX ( `query` ) ;
ALTER TABLE `oc_url_alias` ADD INDEX ( `keyword` ) ;
ALTER TABLE `oc_url_alias` ADD INDEX ( `url_alias_id` );
and this is what I got - see screenshot

Re: VPS server settings - optimization for high speed

Posted: Sun Feb 07, 2021 11:07 pm
by xxvirusxx
ideep13 wrote:
Sun Feb 07, 2021 10:47 pm
these 3 doesn't exist in my DB:

Code: Select all

ALTER TABLE `oc_url_alias` ADD INDEX ( `query` ) ;
ALTER TABLE `oc_url_alias` ADD INDEX ( `keyword` ) ;
ALTER TABLE `oc_url_alias` ADD INDEX ( `url_alias_id` );
and this is what I got - see screenshot

Code: Select all

ALTER TABLE `oc_seo_url` ADD INDEX ( `query` ) ;
ALTER TABLE `oc_seo_url` ADD INDEX ( `keyword` ) ;
ALTER TABLE `oc_seo_url` ADD INDEX ( `seo_url_id` );

Re: VPS server settings - optimization for high speed

Posted: Sun Feb 07, 2021 11:16 pm
by ideep13
Thank you I have changed that. MySQL returned empty result.
What else can I do?