Post by ideep13 » Sun Feb 07, 2021 5:23 pm

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..)?

Attachments

screencapture-staskka-january-stats.png

screencapture-staskka-january-stats.png (1.54 MiB) Viewed 221 times

screencapture-djecjeku-stats.png

screencapture-djecjeku-stats.png (1.3 MiB) Viewed 221 times

SYSTEM PHP-FPM SETTINGS .png

SYSTEM PHP-FPM SETTINGS .png (109.93 KiB) Viewed 221 times


User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am

Post by khnaz35 » 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.

Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature ;) :) :-*


User avatar
Active Member

Posts

Joined
Mon Aug 27, 2018 11:30 pm
Location - Malaysia

Post by ideep13 » Sun Feb 07, 2021 10:47 pm

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

Attachments

screencapture-OC3036.png

screencapture-OC3036.png (884.97 KiB) Viewed 163 times


User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am

Post by xxvirusxx » Sun Feb 07, 2021 11:07 pm

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` );

My converted modules | Buy me a beer | Opencart upgrade service


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by ideep13 » Sun Feb 07, 2021 11:16 pm

Thank you I have changed that. MySQL returned empty result.
What else can I do?

User avatar
Active Member

Posts

Joined
Mon Jun 18, 2012 2:47 am
Who is online

Users browsing this forum: No registered users and 28 guests