Skip to content

My notepad

Chris' IT notes…

  • Home
  • Here are my notes…

MySQL – Increase I/O performance on InnoDB

1) Increased innodb_write_io_thread from 4 to 16
2) Increased innodb_read_io_thread from 4 to 16
3) Altered innodb_flush_method=O_DIRECT

Sources:
http://dev.mysql.com/doc/innodb/1.1/en/innodb-performance-multiple_io_threads.htmlhttp://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-diskio.html

This entry was posted in Linux and tagged innodb, mysql, optimisation on February 17, 2017 by thtieig.

Post navigation

← InnoDB log file size Set X-Forward in Nginx logs →

My notes… organised a bit

  • Cloud (34)
  • Containers (3)
  • Linux (188)
  • Mac (22)
  • Networking (17)
  • Scripting (54)
  • Virtualisation (11)
  • Windows (7)

Tags

  • apache
  • api
  • automation
  • backup
  • bash
  • basic
  • centos
  • centos7
  • command line
  • convert
  • debian
  • innodb
  • lighttpd
  • linux
  • lvm
  • mac
  • manual
  • monitoring
  • mount
  • mysql
  • notes
  • php
  • php-fpm
  • rackspace
  • raspberry pi
  • redhat
  • redirect
  • rsync
  • script
  • server
  • shortcut
  • ssh
  • ssl
  • test
  • troubleshooting
  • tunnel
  • ubuntu
  • ubuntu 16.04
  • varnish
  • vim
  • vm
  • VMware
  • windows
  • wordpress
  • wsl
Proudly powered by WordPress