Results 1 to 4 of 4

Thread: The best configuration for wordpress

  1. #1
    Join Date
    Aug 2017
    Posts
    8

    Question The best configuration for wordpress

    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

  2. #2
    Join Date
    May 2008
    Posts
    757
    Use the latest versions. No doubt on that.

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

  3. #3
    Join Date
    Aug 2017
    Posts
    8
    Quote Originally Posted by wattie View Post
    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

  4. #4
    Join Date
    May 2008
    Posts
    757
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •