Skip to content

Instantly share code, notes, and snippets.

@muresan

muresan/mysql_tuning_parameters

Created November 10, 2015 13:51
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save muresan/4fccb305cea641c3d7eb to your computer and use it in GitHub Desktop.
Save muresan/4fccb305cea641c3d7eb to your computer and use it in GitHub Desktop.
Download ZIP
MySQL tunning from a persentation
Raw
mysql_tuning_parameters
All the changes that are fit to print. Droppin’ Mo’ Science 52 All Your IOPS Are Belong To Us: Ernie Souhrada, Database Engineer @ Pinterest - Percona Live MySQL Conference & Expo 2015 Full list of customizations / changes deployed:
-  Linux kernel 3.18.7
-  irqbalance 1.0.8
-  RPS enabled
-  Jemalloc instead of Glibc
-  Disk IO scheduler = noop
-  XFS + 64K RAID block size
-  Mount options: -  noatime,nobarrier,discard,inode64,logbsize=256k
-  my.cnf changes:
innodb_max_dirty_pages_pct = 75
innodb_checksum_algorithm = CRC32
innodb_io_capacity = 10000
innodb_io_capacity_max = 16000
innodb_lru_scan_depth = 2000
innodb_log_buffer_size = 32M
innodb_read_io_threads = 8
innodb_write_io_threads = 8
relay_log_info_repository = TABLE
relay_log_recovery = ON
table_open_cache_instances = 8
metadata_locks_hash_instances = 256
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment