InnoDB System Variables

• System variables that are true or false can be enabled at server startup by naming them, or disabled by using a skip- prefix.

• Here is a list of InnoDB system variables.
  • innodb_additional_mem_pool_size
  • innodb_autoextend_increment
  • innodb_buffer_pool_awe_mem_mb
  • innodb_buffer_pool_size
  • innodb_checksums
  • innodb_commit_concurrency
  • innodb_concurrency_tickets
  • innodb_data_file_path
  • innodb_data_home_dir
  • innodb_doublewrite
  • innodb_fast_shutdown
  • innodb_file_io_threads
  • innodb_file_per_table
  • innodb_flush_log_at_trx_commit
  • innodb_flush_method
  • innodb_force_recovery
  • innodb_lock_wait_timeout
  • innodb_locks_unsafe_for_binlog
  • innodb_log_archive
  • innodb_log_buffer_size
  • innodb_log_file_size
  • innodb_log_files_in_group
  • innodb_log_group_home_dir
  • innodb_max_dirty_pages_pct
  • innodb_max_purge_lag
  • innodb_mirrored_log_groups
  • innodb_open_files
  • innodb_rollback_on_timeout
  • innodb_safe_binlog
  • innodb_support_xa
  • innodb_sync_spin_loops
  • innodb_table_locks
  • innodb_thread_concurrency
  • innodb_thread_sleep_delay
  • sync_binlog

Are there any problems creating the InnoDB table space?

---

---

© 2007 John Michael Pierobon

Notes