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 (1.54 MiB) Viewed 2970 times
screencapture-djecjeku-stats.png (1.3 MiB) Viewed 2970 times
SYSTEM PHP-FPM SETTINGS .png (109.93 KiB) Viewed 2970 times
Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature
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` );
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` );
Attachments
screencapture-OC3036.png (884.97 KiB) Viewed 2912 times
ideep13 wrote: ↑Sun Feb 07, 2021 10:47 pmthese 3 doesn't exist in my DB:and this is what I got - see screenshotCode: 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` );
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` );
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
I am doing the same. Same version and theme... 2.0.3.2 and journal 2.
Now I only know Windows and iis... so moving it to win first. Tried Linux vps 4 core 4gb. And it’s slower than my reseller hosting.
Wazure host takes half the time to download home page according to postman request.... but all my images are broke,,, wish me look.
- Don't use Journal
- Don't use CloudFlare
- Don't use namecheap
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Yup, it's getting to that stage.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
We figured out that 500 error was caused because of VQMOD - This topic - viewtopic.php?f=202&t=222464
But there is still something that is causing memory leak..
My site does not work on mobile but rund on desktop.. I turned to hosting and they said this:
So I tried to increase the max_children on 10 (on djecje-kucice PHP-FPM settings), but nothing happened..Having checked the possible cause, we located:
[14-Nov-2021 11:05:29] WARNING: [pool djecje-kucice_com] server reached max_children setting (5), consider raising it
You can try increasing the max_children limit and tune the PHP-FPM performance as shown in the following guide https://support.cpanel.net/hc/en-us/art ... ing-Basics
Or switch the handler from PHP-FPM to lsapi. This handler does not require additional control of the PHP-FPM pool and takes fewer resources.
Here's a guide if you wish to switch it https://support.cpanel.net/hc/en-us/art ... PI-handler
so I went to the second option to switch to Isapi, but now I get Service Unavailable on mobile for djecje-kucice
How can I found out what is causing this leak and uninstall the shit code (extension or what ever is acusing this) so my site could work proper.
Any help is much apprecaited.
Attachments
screencapture-djecje-kucice-.png (156.03 KiB) Viewed 2484 times
Or use a proper standard-compliant web theme.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
They have cheked into it and find out this:
Having checked the possible cause, we located:
[14-Nov-2021 11:05:29] WARNING: [pool djecje-kucice_com] server reached max_children setting (5), consider raising it
You can try increasing the max_children limit and tune the PHP-FPM performance as shown in the following guide https://support.cpanel.net/hc/en-us/art ... ing-Basics
Or switch the handler from PHP-FPM to lsapi. This handler does not require additional control of the PHP-FPM pool and takes fewer resources.
Here's a guide if you wish to switch it https://support.cpanel.net/hc/en-us/art ... PI-handler
I think some bad PHP code is causing memory leak. Because I have zero knowledge about how to find what is causing this leak, I read some sites about this.. but I dont know if I can do this.Thank you for your cooperation.
Having checked the logs, we noticed:
[Mon Nov 15 07:24:33.103215 2021] [lsapi:error] [pid 2250:tid 47297042425600] [client 172.70.142.161:26140] [host djecje-kucice.com] Error receiving response header (lsphp is killed?): ReceiveResponseHeader: Wrong header number 122
[Mon Nov 15 07:24:52.217367 2021] [lsapi:error] [pid 2252:tid 47297140397824] [client 172.70.134.123:47322] [host djecje-kucice.com] Error receiving response header (lsphp is killed?): ReceiveResponseHeader: Wrong header number 399
[07:26] [server.xx.com ~] # date
Mon Nov 15 07:26:06 UTC 2021
Most likely it triggers during the upload of files to the site.
You can try fixing it by executing:
nano /usr/local/apache/conf/conf.d/lsapi.conf
then add: lsapi_backend_max_process_time 1800
and save the changes
after that - /etc/init.d/httpd restart
Let us know whether it works for you and if you still experience the 520 error message.
For the starters I thought I could just disable extensions one by one, but I can see all the extensions on modifications are disabled.
How can I find out what is causing this?
These are error logs
So if anyone will have similiar issue like I did.. now you know. Site now works, and he saved my business.
I have moved storage folder inside system folder under a random name for security reasons and after refreshing Opencart modifications your issue seems solved now. Most likely this was a problem related to Opencart Modifications System.
Are you using vQmod at all? It could of been this issue with vQmod. https://github.com/vqmod/vqmod/pull/152ideep13 wrote: ↑Thu Nov 18, 2021 4:11 pmI contacted Journal support and this happened:
So if anyone will have similiar issue like I did.. now you know. Site now works, and he saved my business.
I have moved storage folder inside system folder under a random name for security reasons and after refreshing Opencart modifications your issue seems solved now. Most likely this was a problem related to Opencart Modifications System.
I can not remember if I done anything with storage folder.
I hope this is now fixed, site does work everyhere, which is a relief. I did switched to Isapi now from PHP-FPM while we tried to figure out the issue.. I hope that is ok too, or should I stayed on PHP-WHM?
Users browsing this forum: No registered users and 322 guests