Improve site performance (woocommerce with 3500 produts)

  • Resolved immunity20

    (@immunity20)


    6 years, 10 months ago

    Hello, I have a website in woocommerce with 3500 products ( simple products with 5-7 attributes each one, extra 2 custom prices). also with woof product filter.

    server is 8 cores of 4200bogomips each core 32GB RAM 40GBSSD . there are 3-5 people in admin (products list also fetch 3 extra columns ( 2 custom prices + last modified date)

    configuration on server ( php, nginx, mysql are the default – almost execpt fastcgi timeout variable set to 180)

    with only these 5 users on backend (visitors in front-end haven’t start to come) the server seems “stressed” htop in server shows sometimes 100% to most of the cores but RAM its always near 1GB (31GB free :/)
    most of the processes are mysql and php childrens.

    is there some configuration i need to make? or its just cpu bottleneck. althought with 8 cores 32GB ram i thought the machine would be super fast.

    htop photo

    • This topic was modified 6 years, 10 months ago by immunity20.
Viewing 10 replies - 1 through 10 (of 10 total)

  • You should optimize mysql configuration for use more RAM for caches and buffers.

    Thread Starter immunity20

    (@immunity20)

    Thank you grola, maybe by any chance you have any reputable guide for mysql config ? (I have started to google it ?? )

    Again thanks

    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Have you taken a look at our guide for troubleshooting slow sites?
    https://docs.woocommerce.com/document/troubleshooting-a-slow-site/

    Thread Starter immunity20

    (@immunity20)

    Hey Hannah,
    yes i did ( i am mostly troubled on why ram is not used so much and cpu gets to top which probably be sql ?)

    I have enabled cache ( W3 Total Cache), PHP OPCache. but the bottleneck is created when the admins ( backend) try to search the products etc which is a situation where cache is not used)

    • This reply was modified 6 years, 10 months ago by immunity20.
    • This reply was modified 6 years, 10 months ago by immunity20.

    hi immunity 3500 products you need to compress your image and javascript in the front homepage and css and optimized your database my customer website have 6000 products but the website run very fast and well optimized this website speed is very slow but the performance is best.the memory of this website just only 6GB RAM.

    Thread Starter immunity20

    (@immunity20)

    Hey ritzonline, well i the server uses only 1GB from 32GB xD so I haven’t configure it. i’ll try to find out on net any tutorials. Do you have any walkthough how to optimize the database?

    • This reply was modified 6 years, 10 months ago by immunity20.
    dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    Hey @immunity20

    Your best bet is probably to talk to one of the Experts listed on our Customizations page (https://woocommerce.com/customizations/), many of these companies have experience in these situations.

    but the bottleneck is created when the admins ( backend) try to search the products etc which is a situation where cache is not used)

    I know this is possible but I’m unsure of how to do it so it can be improved.

    Hope you find a good solution.

    Thanks,

    Thread Starter immunity20

    (@immunity20)

    Hey dougaitken.
    Dont know what I have done.
    in new fresh ubuntu install the site worked fine
    (less than 500msec for non-logged users
    around 900-1.300 msecs for admins/registered)

    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there,

    As Doug said, this is more than we can help with – your best option would be to reach out to one of the Woo Experts for more hands-on support:
    https://woocommerce.com/customizations/

    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Improve site performance (woocommerce with 3500 produts)’ is closed to new replies.