[Cialug] mariadb and wordpress tuning

[Dave Hala]

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