Sample InnoDB Configuration File

• The following example shows possible configuration parameters in the my.cnf file for InnoDB.

  [mysqld]
  innodb_data_home_dir =
  #
  # Data files must be able to hold your data and indexes
  innodb_data_file_path = /ibdata/ibdata1:500M;/disk2/ibdata/ibdata2:500M:autoextend
  #
  # Set buffer pool size to 50-80% of your computer's memory,
  # but make sure on Linux x86 total memory usage is < 2GB
  innodb_buffer_pool_size=1G
  innodb_additional_mem_pool_size=20M
  innodb_log_group_home_dir = /disk3/iblogs
  #
  innodb_log_files_in_group = 2
  #
  # Set the log file size to about 25% of the buffer pool size
  innodb_log_file_size=250M
  innodb_log_buffer_size=8M
  #
  innodb_flush_log_at_trx_commit=1
  innodb_lock_wait_timeout=60
  #
  # 
  innodb_thread_concurrency=5
  

• Database performance may improve if all the data is not placed on the same physical disk.
  • Putting log files on a different disk from data is very often beneficial for performance.
  • The example above illustrates how to do this.
    • It places the two data files on different disks and places the log files on the third disk.

How do I go about using per-table tablespaces?

---

---

© 2007 John Michael Pierobon

Notes