Skip to content
  • Yasufumi Kinoshita's avatar
    0111e9c7
    WL#6117 InnoDB: Resize the InnoDB Buffer Pool Online · 0111e9c7
    Yasufumi Kinoshita authored
    - 'innodb_buffer_pool_size' is changed to 'Dynamic Variable' (The Default value is still 128M. not changed.)
    
    - able to monitor progress of resizing buffer pool (by global status 'innodb_buffer_pool_resize_status' or server error log)
    
    - 'innodb_buffer_pool_chunk_size' is a new global read-only variable, default value is 128M.
    
    The 'innodb_buffer_pool_chunk_size' unit is 1M. And the actual buffer pool size is always aligned to 'innodb_buffer_pool_chunk_size' * 'innodb_buffer_pool_instances' granularity.
    
    (rb#4225 : Approved by Vasil and Sunny)
    
    
    This push also contains following bug fixes:
    
    Bug#19001299 : SEGV WHILE INITIALIZING BUFFER POOL
    Bug#19069698 : ASSERT BTR_SEARCH_ENABLED IN PURGE AFTER SET GLOBAL INNODB_ADAPTIVE_HASH_INDEX=0
    0111e9c7
    WL#6117 InnoDB: Resize the InnoDB Buffer Pool Online
    Yasufumi Kinoshita authored
    - 'innodb_buffer_pool_size' is changed to 'Dynamic Variable' (The Default value is still 128M. not changed.)
    
    - able to monitor progress of resizing buffer pool (by global status 'innodb_buffer_pool_resize_status' or server error log)
    
    - 'innodb_buffer_pool_chunk_size' is a new global read-only variable, default value is 128M.
    
    The 'innodb_buffer_pool_chunk_size' unit is 1M. And the actual buffer pool size is always aligned to 'innodb_buffer_pool_chunk_size' * 'innodb_buffer_pool_instances' granularity.
    
    (rb#4225 : Approved by Vasil and Sunny)
    
    
    This push also contains following bug fixes:
    
    Bug#19001299 : SEGV WHILE INITIALIZING BUFFER POOL
    Bug#19069698 : ASSERT BTR_SEARCH_ENABLED IN PURGE AFTER SET GLOBAL INNODB_ADAPTIVE_HASH_INDEX=0
Loading