Skip to content

Latest commit

 

History

History
24 lines (14 loc) · 698 Bytes

useful-mysql-performance-tuning-tips.md

File metadata and controls

24 lines (14 loc) · 698 Bytes

Useful MySQL performance tuning tips

Detail.

Separate Undo Tablespace

Store undo tablespace in separate set of files

  • innodb_undo_directory
  • innodb_undo_tablespaces
  • innodb_undo_logs

Page Checksum

Page checksum is checked when page is read to buffer pool, and updated when page is flushed to disk. It can be significant overhead when using very fast storage. It can be disabled by:

innodb_checksums=0

Or we can use faster checksums for fast storage:

innodb_checksum_algorithm=crc32

The remains are still being arranged..