Want more timely Centmin Mod News Updates?
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:25 AM
    @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.
     
  2. eva2000

    eva2000 Administrator Staff Member

    54,860
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    7:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  3. jeffwidman

    jeffwidman Active Member

    152
    27
    28
    Dec 3, 2014
    Ratings:
    +51
    Local Time:
    2:25 AM
    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

    54,860
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    7:25 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+