[Cialug] Wordpress Tuning

[Jim Cole]

I run some whmcs (php based) systems that were not performing well. I moved
them off ssd to nvme and it's a night/day difference.

On Sat, Nov 13, 2021, 01:33 Dave Weis <djweis at sjdjweis.com> wrote:

> It functions but is laggier than I would expect. Running on centos 7 with a
> couple cores and 16 gigs of ram. It's my hardware so not oversold.
>
> [djweis at grand ~]$ rpm -qa | grep php
> php-cli-7.3.4-1.el7.remi.x86_64
> php-7.3.4-1.el7.remi.x86_64
> php-intl-7.3.4-1.el7.remi.x86_64
> php-mbstring-7.3.4-1.el7.remi.x86_64
> php-common-7.3.4-1.el7.remi.x86_64
> php-gd-7.3.4-1.el7.remi.x86_64
> php-xml-7.3.4-1.el7.remi.x86_64
> php-gmp-7.3.4-1.el7.remi.x86_64
> php-json-7.3.4-1.el7.remi.x86_64
> php-mysqlnd-7.3.4-1.el7.remi.x86_64
> php-ldap-7.3.4-1.el7.remi.x86_64
> php-process-7.3.4-1.el7.remi.x86_64
> php-snmp-7.3.4-1.el7.remi.x86_64
> php-pdo-7.3.4-1.el7.remi.x86_64
> php-imap-7.3.4-1.el7.remi.x86_64
> [djweis at grand ~]$ rpm -qa | grep maria
> mariadb-libs-5.5.68-1.el7.x86_64
> mariadb-5.5.68-1.el7.x86_64
> mariadb-server-5.5.68-1.el7.x86_64
> [djweis at grand ~]$ cat /etc/redhat-release
> CentOS Linux release 7.9.2009 (Core)
>
> I've gone through the basic troubleshooting docs but most are pretty
> remedial.
>
> This is what I've got in the /etc/my.cnf.d/grand.cnf
>
> [server]
> max_allowed_packet=16777216
> max_heap_table_size=125M
> key_buffer=128M
>
> # added 20200508
> query_cache_limit=8M
> query_cache_size=256M
> query_cache_type=1
>
> [mysqld]
> innodb_file_per_table=ON
> innodb_file_format=Barracuda
> innodb_large_prefix=ON
> innodb_buffer_pool_size=1024M
> innodb_doublewrite=OFF
> innodb_additional_mem_pool_size=16M
> innodb_flush_log_at_trx_commit=2
> innodb_log_file_size=256M
>
> # was in server.cnf
> key_buffer=128M
>
> # added 20200508
> query_cache_limit=8M
> query_cache_size=256M
> query_cache_type=1
>
> [mysqld]
> character-set-server=utf8mb4
> collation-server=utf8mb4_unicode_ci
>
> Thanks for the reply
>
> dave
>
>
>
>
>
>
> On Fri, Nov 12, 2021 at 5:10 PM <chris at bynw.com> wrote:
>
> > How is it not performing?
> > What version of WP?
> > What version of PHP?
> >
> > On 2021-11-12 14:30, Dave Weis wrote:
> > > I'm hosting my wife's wordpress site on my hardware. It isn't
> > > performing as
> > > well as it should and I wanted to see if anyone would like a paid job
> > > to
> > > work on it and improve performance.
> > >
> > > Is there anyone that has WP and mysql/mariadb experience and can help?
> > >
> > > dave
> > > _______________________________________________
> > > Cialug mailing list
> > > Cialug at cialug.org
> > > https://www.cialug.org/cgi-bin/mailman/listinfo/cialug
> > _______________________________________________
> > Cialug mailing list
> > Cialug at cialug.org
> > https://www.cialug.org/cgi-bin/mailman/listinfo/cialug
> >
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> https://www.cialug.org/cgi-bin/mailman/listinfo/cialug
>