New answers tagged

2 votes

innodb_buffer_pool_size complications

You don't need to calculate the pool size. Set innodb_buffer_pool_size to the total RAM you want to allocate to the buffer pool. Let MySQL calculate the pool instances and chunk size. MySQL does this ...
Bill Karwin's user avatar
  • 13.9k
1 vote
Accepted

how percona hot backup works / innodb crash recovery works?

The LSN (Log Sequence Number) is analogous to binary log position, but the redo log is a different log. It applies only to InnoDB pages, and it contains physical diffs of the pages affected. During ...
Bill Karwin's user avatar
  • 13.9k

Top 50 recent answers are included