Bitnami Magento 2.2 Very Very Slow

sergiopera 2018-08-07 08:35:45 UTC #1

Keywords: Magento - Google Cloud Platform - Technical issue - Other
bnsupport ID: 1279acf4-a7b9-8039-6bf5-375f9d98925c
Description:
Hello, after 2/3 month of using my stack without any change i deleted cache trying to move on developer mode (from production mode) after complete deletion of var/cache folder made a reset... After this nothing worked ok again, my server needs 30 seconds to load ( 4 cpu 20gb RAM SSD) and my old dev server (3 month ago) takes 5 second (1 cpu 2.75gb ram).

When i restart server the load time for site is 5 seconds, but after 2 hours it's 30 seconds (traffic is not high 15 people) the main problem is that RAM usage starts to increase to 85% the whole day

the mysql active connections are 100-120 always with only 10/15 people online and RAM is 85 always
https://gyazo.com/cb7d1f5ffa9f4b44863d84b7725056ad (same here made reboots to speedup server)

You can check my website www.mercadomayorista.com to see how slow is loadiing

I have been tryiing to solve this, mostly checking if it's apermission issue, but it's not. working

first tried settiing htdocs to 777 and chown by bitnami:daemon
also folder var and var/cache are owned by daemon:daemon... but no luck honestly.

I also ran this commando but takes 1 hour and still working.

sudo /opt/bitnami/apps/magento/scripts/fixPermissions.sh

I checked and folder htdocs/var as i read should be daemon:daemon, but i change chown to daemon and after 2 minutes it come back to bitnami:daemon, can this be a problem?

Can anyone help me?

Thanks

sergiopera 2018-08-07 16:53:49 UTC #2

I have a wait on pingdom of 10 seconds

jota 2018-08-07 19:05:35 UTC #3

Hi @sergiopera

Did you run the support tool after or before running this script?

We will review the information of the support tool and will update this ticket with all the information we find.

Apart from that, could you please check this guide and share with us the results?

https://docs.bitnami.com/google/faq/#how-to-troubleshoot-server-performance-problems

Thanks

sergiopera 2018-08-07 19:46:12 UTC #4

after but the problem is that permissions were overwritten.

sergiopera 2018-08-07 23:56:03 UTC #5

Hello i already solved this, just in case someone else need this.

My vm was 4 cpu, 20gb, SSD

After 50% CPU constant, 85% RAM, 110 MySQL active connections and server very slow (25 to 30 seconds load site) i realized that the problem was the CACHE. I just moved to developer mode and then made a complete clean:

rm -R var/cache/* generated var/generation/* var/view_preprocessed/* var/page_cache/* pub/static/frontend/* pub/static/adminhtml/*

then i stablished again permissions:

sudo /opt/bitnami/apps/magento/scripts/fixPermissions.sh

and worked better than before

result:
8% cpu usage, 7% memory usage, 0 active mysql, 3 seconds load time (800ms response from 10s)

before:

jsalmeron 2018-08-08 10:18:19 UTC #6

Hi,

Thanks for sharing your results! The community will benefit from this In case you find more issues, do not hesitate to open a new ticket

Best regards,

Javier J. Salmerón

Was my answer helpful? Click on

jsalmeron 2018-08-08 10:18:22 UTC #7

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!