Koozali.org: home of the SME Server

Webserver Tuning etc

Offline jameswilson

  • ****
  • 739
  • +0/-0
    • Security Warehouse, trade security equipment
Webserver Tuning etc
« on: March 10, 2021, 09:44:09 PM »
I have a wordpress website (im moving to woocommerce from zencart) and all is good. Running on SME

However i have certain pages in the admin side that are extremely slow. The host is more than powerful enough so its not a hardware issue.
Ive optimised mysql5.7 as much as I can and made some huge improvements.
But the ticket support system (awesome support) has me beat.
I have installed query manager on the wordpress site to see times etc.
ANd the tickets themselves show these times etc

Quote
Page Generation Time
9.3046
1.6% of 600s limit

Peak Memory Usage
88,040 kB
8.4% of 1,048,576 kB limit

Database Query Time
2.1292

Database Queries
SELECT: 654
SHOW: 9
UPDATE: 2
DELETE: 2
REPLACE: 1
Total: 668

Object Cache
98.5% hit rate (34,937 hits, 529 misses)

External object cache in use

Opcode

I cant get the database query time any lower but i dont know where to start on the page gen time.
Its an issue as every ticket takes approx 10s to open and the office moan its too slow.

Any suggestions on what to do to improve it?

Thanks

James

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Webserver Tuning etc
« Reply #1 on: March 10, 2021, 11:34:25 PM »
Hmmmm. Maybe not what you want to hear but...

Personally I can't understand moving from a tool designed for the job to one that isn't.

Wordpress is a blog platform.

Woocommerce is a big plugin to force it to do something it wasn't really designed to do. And probably needs plugins for the plugins....

Plenty of pages out there on topics like

"woocommerce slow admin ticket"

Various suggestion on disabling loading unnecessary scripts etc. That's probably your direction of travel to start with, all other things being equal. Check with Chromium/e dev tools to see what takes time.

Yes, possibly have a look later at mysql/php optimisations (PLEASE share things you find to the wiki or a bug) but my guess is you need to look at the core code.

Having used Zencart for years I don't dispute it is long in the tooth and I have sites running other packages too now.

Personally I'd look for a proper ecommerce/ticket platform designed for the job. It should offer much better performance. Might cost you a bit more short term but save you chasing ghosts...

IMHO of course...... :-)
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline jameswilson

  • ****
  • 739
  • +0/-0
    • Security Warehouse, trade security equipment
Re: Webserver Tuning etc
« Reply #2 on: March 11, 2021, 12:13:33 AM »
I went with woocom due to the plugin nature etc. Allowing sage to link. I spent a lot of money customising zencart but that became a mess.
I have added redis which helped and i have a chnaged various cache settings for mysql57 to make it pretty quick. The only thing that is slow (imo) is the ticket system so i will look as you say.

Thanks

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Webserver Tuning etc
« Reply #3 on: March 11, 2021, 09:36:50 AM »
Please add your Mysql optimisations to bugzilla.

I know JP had done a bit but more are welcome.

If you are throwing lots of cash at this I'd really go and look at something designed for the job.

Personally I look for something that does say 90% out of the box and maybe 10% by plugins.....

Might be cheaper and more effective in the long run.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline jameswilson

  • ****
  • 739
  • +0/-0
    • Security Warehouse, trade security equipment
Re: Webserver Tuning etc
« Reply #4 on: March 18, 2021, 07:55:32 PM »
mysql57  additional settings


# innodb_buffer_pool_size=1024M
# jpw 21/10/2020
thread_cache_size=64M
tmp_table_size=2048M
max_heap_table_size=1024M
table_open_cache=2000
innodb_open_files=16K
innodb_buffer_pool_size=1512M
innodb_flush_log_at_trx_commit=0
innodb_log_file_size=1024M
sort_buffer_size=512M
#
read_rnd_buffer_size=512M
table_definition_cache=1024
key_buffer_size=1024M
innodb_buffer_pool_instances=2
# open_files_limit=500


Posting here as what I have done may be garbage. It certainly helps on the tests I did but a mysql expert might fall of his/her chair looking at the above

This is using the mysql57 contrib.
16 gig of ram, ssd drives on a virtual server. Proxmox on a dedicated server in a data centre
« Last Edit: March 18, 2021, 07:58:09 PM by jameswilson »

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Webserver Tuning etc
« Reply #5 on: March 18, 2021, 08:28:28 PM »
Sure JP will look at those settings thanks.

Have you checked the page loading with say Chrome tools and see what is bunging up your browser?

I get the feeling as above that it is less to do with your server and more to do with the code.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline jameswilson

  • ****
  • 739
  • +0/-0
    • Security Warehouse, trade security equipment
Re: Webserver Tuning etc
« Reply #6 on: March 19, 2021, 01:40:26 PM »
It is / was
It was only certain pages and i found that there was a huge query.
I wonder if im loosing performance as its a proxmox guest. Ive been reading about file sizes and zfs.
Ill keep updating as I find more etc.

James

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Webserver Tuning etc
« Reply #7 on: March 19, 2021, 02:07:17 PM »
No you are losing performance running badly written code.....

Most of us run Prox & VMs. It isn't an issue per se. What resources have you allocated the VM? What other VMs are running on there? Have you overprovisioned any?

You can throw more grunt at the VM, or at the Prox server to throw at the VM.

You could throw more at the clients too.

But that's probably just papering over the cracks of the underlying issue which is the code.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline jameswilson

  • ****
  • 739
  • +0/-0
    • Security Warehouse, trade security equipment
Re: Webserver Tuning etc
« Reply #8 on: March 19, 2021, 06:20:50 PM »
Agreed on the code front I'm not in anyway blaming sme for it

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Webserver Tuning etc
« Reply #9 on: March 19, 2021, 06:23:24 PM »
Agreed on the code front I'm not in anyway blaming sme for it

Yeah I know :-)

Give us some more details so we can have a think.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline jameswilson

  • ****
  • 739
  • +0/-0
    • Security Warehouse, trade security equipment
Re: Webserver Tuning etc
« Reply #10 on: March 20, 2021, 12:26:58 AM »
Against all advice I'm going down this road. I've even sold into amp. I'll see how that goes. I'm fortunate that I have a live site running old so I can compare.

Offline jameswilson

  • ****
  • 739
  • +0/-0
    • Security Warehouse, trade security equipment
Re: Webserver Tuning etc
« Reply #11 on: March 20, 2021, 12:29:29 AM »
Don't waste time on this, I want to ask more when I move it over to sme10.

Question some are UK based?

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Webserver Tuning etc
« Reply #12 on: March 20, 2021, 12:40:24 AM »
Don't waste time on this, I want to ask more when I move it over to sme10.

Thanks to a few hard workers RC is due to land shortly!

Quote
Question some are UK based?

Some what? Devs? Servers?

Yes and yes.....

I'm British but live in Spain. My wife & I run a small company in the UK from here.

I have servers here & there.

Brian - another unsung hero who has migrated the majority of the contribs so far - is in the UK.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation