Skip to content
  • Inaam Rana's avatar
    4479af1a
    Bug #59214 :increase rate limit for insert buffer prefetch reads · 4479af1a
    Inaam Rana authored
    rb://593
    approved by: Marko
    
    1) Make ibuf size configurable. Current behavior is to have a maximum
    on-disk size equal to half the buffer pool size. This patch introduces
    a new parameter:
    
    innodb_change_buffer_max_size = default 25, min 0, max 50. Value means
    %age of buffer pool size. Dynamic.
    
    2) Make ibuf merge more aggressive:
    * upto ibuf::size < ibuf::max_size / 2, merge at PCT_IO(5) same as
      current. And should be good for most of the workloads.
    * when ibuf::size > ibuf::max_size / 2, merge at PCT_IO(5) +
      PCT_IO(excess difference in % of max_size)
    4479af1a
    Bug #59214 :increase rate limit for insert buffer prefetch reads
    Inaam Rana authored
    rb://593
    approved by: Marko
    
    1) Make ibuf size configurable. Current behavior is to have a maximum
    on-disk size equal to half the buffer pool size. This patch introduces
    a new parameter:
    
    innodb_change_buffer_max_size = default 25, min 0, max 50. Value means
    %age of buffer pool size. Dynamic.
    
    2) Make ibuf merge more aggressive:
    * upto ibuf::size < ibuf::max_size / 2, merge at PCT_IO(5) same as
      current. And should be good for most of the workloads.
    * when ibuf::size > ibuf::max_size / 2, merge at PCT_IO(5) +
      PCT_IO(excess difference in % of max_size)
Loading