[Cialug] mariadb and wordpress tuning

[Dave Hala]

Is the database on the vm same as the wp install?

Take a look at the max number of open files.  If you hit the limit, the
page loads will intermittently slow. Here's a quick example:

https://serverfault.com/questions/637212/increasing-ulimit-on-centos

:) Dave



On Sat, May 30, 2020 at 8:32 AM Dave Weis <djweis at sjdjweis.com> wrote:

> 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
> >
> _______________________________________________
> 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