[Cialug] Wordpress Tuning

[Dave Weis]

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
>