/ Register

Want more timely Centmin Mod News Updates?
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,101
    428
    83
    May 31, 2014
    Ratings:
    +838
    Local Time:
    1:14 AM
    Nginx-1.26.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 at 1:14 PM #2
    eva2000

    eva2000 Administrator Staff Member

    55,380
    12,255
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,835
    Local Time:
    8:14 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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...

.