MariaDB

  • Resolved MEMT-NETWORK

    (@memt-network)


    1 year, 11 months ago

    In your db tips https://wpbenchmark.io/improve-wordpress-speed/

    You have added these lines for I assume to put in the my.cnf file.
    Can i also add them if i’m using MariaDB or is exclusive for MYSQL 8.0+ I’m using MariaDB 10.6

    # added on 29.Oct.2022
    # especially for MySQL 8.0
    innodb_redo_log_capacity=512M # only if you have MySQL 8.0.30+
    innodb_log_buffer_size=512M
    innodb_log_write_ahead_size=128K
    disable_log_bin

    thank you in advance.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Anton Aleksandrov

    (@antonaleksandrov)

    I think those will also work in MariaDB, but they won’t be so critical there, mostly due to better default values in MariaDB. ??

    Thread Starter MEMT-NETWORK

    (@memt-network)

    Yeah i added without them, and i went from 0.69 to 9
    I don’t understand anything what it all does, but it seems to help regarding your test.

    First time i’m digging into DB “tuning”.

    Plugin Author Anton Aleksandrov

    (@antonaleksandrov)

    During benchmark scripts will run massive, enormous amount of SQL queries – especially what relates to inserting data. During normal WP operation – you’ll never see it (unless you run some import). But that’s the only way to benchmark database server. Those setting disable few things, fine tune a bit for better performance.. well, if I have to be super honest – better performance with slightly more resource usage and sliiightly degraded redundancy (which with modern hardware hardly ever happen) – everything in this world has its price..

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MariaDB’ is closed to new replies.