[Cialug] mariadb and wordpress tuning

[Dave Weis]

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