/ Register

Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB MariaDB 10.6 recommendations

Discussion in 'MariaDB & General MySQL news & discussions' started by pamamolf, Apr 23, 2025.

Previous Thread Next Thread
Loading...
  1. Apr 23, 2025 #1
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    2:22 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Hi,

    As far as i know the query_cache_type for MariaDB still exists but deprecated and it seems that is not helping so i would like to recommend to get it on new installations as disabled by using:

    Code:
    query_cache_type = 0
query_cache_size = 0
    The MariaDB 11+ i think doesn't use it at all.

    I would like also to recommend the usage of:


    Code:
    innodb_buffer_pool_dump_at_shutdown
innodb_buffer_pool_load_at_startup
innodb_use_native_aio=ON
     
    Last edited: Apr 23, 2025
  2. May 13, 2025 #2
    eva2000

    eva2000 Administrator Staff Member

    58,895
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    9:22 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    already the default https://mariadb.com/kb/en/innodb-system-variables/#innodb_use_native_aio

    already default https://mariadb.com/kb/en/innodb-system-variables/#innodb_buffer_pool_dump_at_shutdown

    already the default https://mariadb.com/kb/en/innodb-system-variables/#innodb_buffer_pool_load_at_startup

    yeah will change https://mariadb.com/kb/en/server-system-variables/#query_cache_type
     
Previous Thread Next Thread
Loading...

.