The best configuration for wordpress

[SaeedTJ]

hello
once I was playing with custombuild options and testing mariadb versions with php versions and also mysql configuration
I can not remember which versions of php and mariadb used together but I am deadly sure also I was changing my.cnf
after any change I run ./build all until I saw the speed of websites is on the highest level and it was perfect for a week
unfortunately I changed the config (which I dont know) and everything got slow
I even reinstalled a clear centos7 and directadmin and litespeed and used mysql_tuner but that such a speed never came back to me
I am really sad about it.
is there any one to help me about which versions of mariadb and php I should use or giving a better my.cnf?
all my websites powered by WordPress

 

[wattie]

Use the latest versions. No doubt on that.

As for the configuration - the tuning really depends on your hardware specs.

 

[SaeedTJ]

Use the latest versions. No doubt on that.

As for the configuration - the tuning really depends on your hardware specs.

My hardware is included:
32GB Ram
24 Core
4TB for directadmin and centos
and now using latest versions:
MaridaDB 1.3
PHP 7.2
but it is not as fast as before

 

[wattie]

A good old MySQL/MariaDB formula is the following (execute as user da_admin):

SELECT ( @@key_buffer_size + @@query_cache_size +
@@tmp_table_size + @@innodb_buffer_pool_size +
@@innodb_log_buffer_size +
@@max_connections * (
@@read_buffer_size + @@read_rnd_buffer_size +
@@sort_buffer_size + @@join_buffer_size +
@@binlog_cache_size + @@thread_stack
)
) / 1073741824 AS MAX_MEMORY_GB

It gives you roughly how many gigabytes of RAM the current MariaDB setup utilizes at total maximum (under heavy load). You can then read about each setting and tune it up via my.cnf.

But first check out your installation - are the tables MyISAM or converted to InnoDB, etc. Then tune the respectful vairables.

Increasing the max_connections is usually the best starting point.