Want to subscribe to topics you're interested in?
Become a Member

MariaDB Curious why InnoDB Buffer Pool load on startup isn't enabled?

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

  1. jeffwidman

    jeffwidman Active Member

    152
    27
    28
    Dec 3, 2014
    Ratings:
    +51
    Local Time:
    6:17 PM
    Per Understanding MySQL’s InnoDB buffer pool | Michael Bouvy
    Seems like this would be a nice thing to enable on Centminmod's default MariaDB 10 my.cnf templates??

    Here's the official docs: XtraDB/InnoDB Server System Variables - MariaDB Knowledge Base

    Also, if this is enabled, probably want to set
    Code:
     innodb_blocking_buffer_pool_restore = 1
    Only caveat is I'm not sure how this is affected by changed in the buffer pool size. I know most of the time when I'm restarting mysql, it's because I adjusted the size of the buffer pool.
     
    Last edited: Feb 26, 2015
    • Like Like x 1
    • Informative Informative x 1
  2. eva2000

    eva2000 Administrator Staff Member

    29,051
    6,592
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,788
    Local Time:
    11:17 AM
    Nginx 1.13.x
    MariaDB 5.5
    doh thought I already had those in MariaDB 10 default my.cnf templates had the wrong ones commented out

    Code:
    #innodb_buffer_pool_load_now=1
    #innodb_buffer_pool_dump_now=1
    should be
    Code:
    innodb_buffer_pool_dump_at_shutdown=1
    innodb_buffer_pool_load_at_startup=1
    
    will update .08 beta with it enabled :)
     
  3. eva2000

    eva2000 Administrator Staff Member

    29,051
    6,592
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,788
    Local Time:
    11:17 AM
    Nginx 1.13.x
    MariaDB 5.5
    Done updated .08 beta 's MariaDB 10 my.cnf default template with correct innodb buffer pool dump and load settings update default MariaDB 10 my.cnf template settings for .08 beta · 1eaecdb · centminmod/centminmod · GitHub :)

    Ah now I remember why it wasn't added to default template as very early MariaDB 10 versions in alpha and beta releases were default using Oracle InnoDB plugin by default and not Percona's XtraDB Innodb plugin and didn't support those variables. Only later did MariaDB 10 releases switched to XtraDB InnoDB plugin and supported those values IIRC
     
    • Like Like x 1