My notepad

Chris' IT notes…

Skip to content
  • 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 (33)
  • Containers (3)
  • Linux (178)
  • Mac (22)
  • Networking (16)
  • Scripting (51)
  • Virtualisation (8)
  • Windows (3)

Tags

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