[Cialug] mariadb and wordpress tuning

[Dave Weis]

I'm not sure :-) The page itself takes the most time and delays the loading
of the later resources. There's a few chunky images and javascript later in
the page load also.

[image: image.png]


These are the stats on the machine. It's not under much load.

[root at grand my.cnf.d]# uptime
 08:27:37 up 20 days, 17:09,  1 user,  load average: 0.40, 0.32, 0.25
[root at grand my.cnf.d]# free
              total        used        free      shared  buff/cache
available
Mem:        8174212     1873172      969488      410276     5331552
5584800
Swap:       2113532      276736     1836796
[root at grand my.cnf.d]#



On Sat, May 30, 2020 at 8:18 AM Dave Hala <dave at 58ghz.net> wrote:

> Where's the bottleneck?   Is it the db read, building the page or apache?
> It is always slow, or just under a load?   Is your vm reading anything from
> a NFS share?
>
> :) Dave
>
>
>
>
>
>
>
> On Sat, May 30, 2020 at 7:14 AM Dave Weis <djweis at sjdjweis.com> wrote:
>
> > Hi All-
> >
> > I'm trying to improve my wife's web site speed ( www.gogoyogakids.com )
> >
> > It is a CentOS 6 VM with 2 vCPU and 8 gigs of RAM available.
> >
> > I've tuned mariadb a bit but it still takes multiple seconds to generate
> > some of the pages.
> >
> > Below is what I've got in one of the /etc/my.cnf.d/ files.
> >
> > Any ideas what to check next? I've been using the load speed graph in
> > chrome to do the testing/monitoring.
> >
> > Thanks!
> > dave
> >
> >
> > [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
> > _______________________________________________
> > Cialug mailing list
> > Cialug at cialug.org
> > https://www.cialug.org/cgi-bin/mailman/listinfo/cialug
> >
>
>
> --
> NIFCAP  -The Premier Client Intake System for Non-Profit Organizations.
> https://www.osis.us
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> https://www.cialug.org/cgi-bin/mailman/listinfo/cialug
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 47954 bytes
Desc: not available
URL: <http://www.cialug.org/pipermail/cialug/attachments/20200530/5cb249c0/attachment-0001.png>