Skip to content

Instantly share code, notes, and snippets.

@alexsv

alexsv/gist:7115020

Created October 23, 2013 08:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexsv/7115020 to your computer and use it in GitHub Desktop.
Save alexsv/7115020 to your computer and use it in GitHub Desktop.
Download ZIP
inno-db tuning
Raw
gistfile1.txt
[mysqld]
innodb_file_per_table
innodb_buffer_pool_size = 5G
innodb_file_io_threads = 4
innodb_lock_wait_timeout = 50
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 17
innodb_flush_method = O_DIRECT
transaction-isolation = READ-COMMITTED
query_cache_type = 0
query_cache_size = 0
innodb_fast_shutdown = 0
innodb_log_file_size = 1536M
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment