Learn about Centmin Mod LEMP Stack today
Become a Member

MariaDB New innodb_buffer_pool_dump_pct setting for my.cnf

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by jeffwidman, Dec 19, 2015.

  1. jeffwidman

    jeffwidman Active Member

    152
    27
    28
    Dec 3, 2014
    Ratings:
    +51
    Local Time:
    2:54 PM
    @eva2000 the latest version of MariaDB went live today, and added innodb_buffer_pool_dump_pct
    For details, see note in changelog which includes links to the original Github PR.

    There's no docs on the MariaDB website, but MySQL has a few. Anyway, might be worth including in your custom my.cnf files.

    I suspect for most centminmod users who are hosting forums/blogs keeping the pct at 50% or great is probably most convenient--the buffer pools generally aren't larger than 1-2 gb. I know @Xon has mentioned he's running a 1GB buffer pool and he's managing one of the largest forums around.
     
    • Like Like x 2
    • Informative Informative x 1
  2. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    7:54 AM
    Nginx 1.13.x
    MariaDB 5.5
  3. jeffwidman

    jeffwidman Active Member

    152
    27
    28
    Dec 3, 2014
    Ratings:
    +51
    Local Time:
    2:54 PM
    I'd stay with 100% myself, and probably make it explicit as MySQL changed their default to 25% in 5.7.7 when they switched to enabling dump/load on shutdown by default.

    I looked, but couldn't find anything in the MariaDB docs about what the default setting for this is.

    If you're okay with it, let me know and I'll submit a PR on github centminmod repo explicitly setting this to 100%
     
  4. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    7:54 AM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 1