| List: | Commits | « Previous MessageNext Message » | |
| From: | plavin | Date: | May 15 2007 10:51pm |
| Subject: | svn commit - mysqldoc@docsrva: r6474 - trunk/dynamic-docs/command-optvars | ||
| View as plain text | |||
Author: plavin Date: 2007-05-15 22:51:11 +0200 (Tue, 15 May 2007) New Revision: 6474 Log: Add plugin innodb vars Modified: trunk/dynamic-docs/command-optvars/mysqld.xml Modified: trunk/dynamic-docs/command-optvars/mysqld.xml =================================================================== --- trunk/dynamic-docs/command-optvars/mysqld.xml 2007-05-15 19:02:05 UTC (rev 6473) +++ trunk/dynamic-docs/command-optvars/mysqld.xml 2007-05-15 20:51:11 UTC (rev 6474) Changed blocks: 37, Lines Added: 648, Lines Deleted: 73; 43923 bytes @@ -2785,7 +2785,7 @@ <option command="mysqld" section="server" id="autocommit"> <name>autocommit</name> <shortdescription lang="en">Sets the autocommit mode</shortdescription> - <seealso xref="innodb_table_locks"/> + <seealso xref="plugin-innodb_table_locks"/> <!--disabledby xref="no-autocommit"/--> <types> <optype class="cmdline" format="--autocommit"/> @@ -3185,7 +3185,7 @@ <name>binlog_format</name> <shortdescription lang="en">Specifies the format of the binary log</shortdescription> <seealso xref="log-bin-trust-function-creators"/> - <seealso xref="innodb_locks_unsafe_for_binlog"/> + <seealso xref="plugin_innodb_locks_unsafe_for_binlog"/> <types> <optype class="mycnf" format="binlog-format" setvar="binlog_format"/> <vartype class="server" isdynamic="no" scope="both" inversion="5.1.8"/> @@ -3588,8 +3588,7 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="crash_binlog_innodb"> - + <option command="mysqld" section="innodb" id="crash_binlog_innodb"> <!-- <xrefto id="optvar_crash_binlog_innodb"/> --> <name>crash_binlog_innodb</name> <shortdescription lang="en">Used only for testing, to crash when writing Nth @@ -4471,13 +4470,13 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb"> - + <option command="mysqld" section="innodb" id="innodb"> <xrefto id="optvar_innodb"/> <name>innodb</name> <shortdescription lang="en">Enable InnoDB (if this version of MySQL supports it)</shortdescription> - <disabledby xref="skip-innodb"/> + <disabledby xref="skip-plugin-innodb"/> + <deprecated version="5.1.18"/> <types> <optype class="cmdline" format="--innodb"/> <optype class="mycnf"/> @@ -4488,11 +4487,27 @@ <manual version="5.1"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin-innodb"> + <xrefto id="optvar_plugin-innodb"/> + <name>plugin-innodb</name> + <shortdescription lang="en">Enable InnoDB (if this version of MySQL supports + it)</shortdescription> + <disabledby xref="skip-plugin-innodb"/> + <types> + <optype class="cmdline" format="--plugin-innodb"/> + <optype class="mycnf"/> + </types> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb_additional_mem_pool_size"> <xrefto id="optvar_innodb_additional_mem_pool_size"/> <name>innodb_additional_mem_pool_size</name> <shortdescription lang="en">Size of a memory pool InnoDB uses to store data - dictionary information and other internal data structures</shortdescription> + dictionary information and other internal data structures</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_additional_mem_pool_size=#" setvar="innodb_additional_mem_pool_size"/> @@ -4506,10 +4521,28 @@ <manual version="5.1"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin_innodb_additional_mem_pool_size"> + <xrefto id="optvar_plugin_innodb_additional_mem_pool_size"/> + <name>plugin_innodb_additional_mem_pool_size</name> + <shortdescription lang="en">Size of a memory pool InnoDB uses to store data + dictionary information and other internal data structures</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_additional_mem_pool_size=#" + setvar="plugin_innodb_additional_mem_pool_size"/> + <optype class="mycnf"/> + <vartype class="server" scope="both" isdynamic="no"/> + </types> + <values vartype="numeric" platform="all"> </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb_autoextend_increment"> <xrefto id="optvar_innodb_autoextend_increment"/> <name>innodb_autoextend_increment</name> <shortdescription lang="en">Data file autoextend increment in megabytes</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_autoextend_increment=#" setvar="innodb_autoextend_increment"/> @@ -4526,6 +4559,24 @@ <manual version="5.1"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin_innodb_autoextend_increment"> + <xrefto id="optvar_plugin_innodb_autoextend_increment"/> + <name>plugin_innodb_autoextend_increment</name> + <shortdescription lang="en">Data file autoextend increment in megabytes</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_autoextend_increment=#" + setvar="plugin_innodb_autoextend_increment"/> + <optype class="mycnf"/> + <vartype class="server" isdynamic="yes" scope="both"/> + </types> + <values vartype="numeric" platform="all"> + <value default="8"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb_buffer_pool_awe_mem_mb"> <xrefto id="optvar_innodb_buffer_pool_awe_mem_mb"/> <name>innodb_buffer_pool_awe_mem_mb</name> @@ -4548,12 +4599,33 @@ <manual version="5.1"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin_innodb_buffer_pool_awe_mem_mb"> + <xrefto id="optvar_innodb_buffer_pool_awe_mem_mb"/> + <name>plugin_innodb_buffer_pool_awe_mem_mb</name> + <shortdescription lang="en">If Windows AWE is used, the size in Megabytes of + InnoDB buffer pool allocated from the AWE memory</shortdescription> + <platforms applies="windows"/> + <types> + <optype class="cmdline" format="--plugin_innodb_buffer_pool_awe_mem_mb=#" + setvar="innodb_buffer_pool_awe_mem_mb"/> + <optype class="mycnf"/> + <vartype class="server" scope="both" isdynamic="no"/> + </types> + <values vartype="numeric" platform="windows"> + <value default="0"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb_buffer_pool_size"> <xrefto id="optvar_innodb_buffer_pool_size"/> <name>innodb_buffer_pool_size</name> <shortdescription lang="en">The size of the memory buffer InnoDB uses to - cache data and indexes of its tables</shortdescription> + cache data and indexes of its tables</shortdescription> <platforms applies="windows"/> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_buffer_pool_size=#" setvar="innodb_buffer_pool_size"/> @@ -4569,11 +4641,32 @@ <manual version="5.1"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin_innodb_buffer_pool_size"> + <xrefto id="optvar_plugin_innodb_buffer_pool_size"/> + <name>plugin_innodb_buffer_pool_size</name> + <shortdescription lang="en">The size of the memory buffer InnoDB uses to + cache data and indexes of its tables</shortdescription> + <platforms applies="windows"/> + <types> + <optype class="cmdline" format="--plugin_innodb_buffer_pool_size=#" + setvar="plugin_innodb_buffer_pool_size"/> + <optype class="mycnf"/> + <vartype class="server" scope="both" isdynamic="no"/> + </types> + <values vartype="numeric" platform="windows"> + <value default="8388608"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb_checksums"> <xrefto id="optvar_innodb_checksums"/> <name>innodb_checksums</name> <shortdescription lang="en">Enable InnoDB checksums validation</shortdescription> - <disabledby xref="skip-innodb-checksums"/> + <disabledby xref="skip-plugin-innodb-checksums"/> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_checksums" setvar="innodb_checksums"/> @@ -4589,6 +4682,25 @@ <manual version="5.1"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin_innodb_checksums"> + <xrefto id="optvar_plugin_innodb_checksums"/> + <name>plugin_innodb_checksums</name> + <shortdescription lang="en">Enable InnoDB checksums validation</shortdescription> + <disabledby xref="skip-plugin-innodb-checksums"/> + <types> + <optype class="cmdline" format="--plugin_innodb_checksums" + setvar="plugin_innodb_checksums"/> + <optype class="mycnf"/> + <vartype isdynamic="yes" scope="both" class="server"/> + </types> + <values vartype="boolean" platform="all" inversion="5.0.3"> + <value default="ON"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb-safe-binlog"> <xrefto id="optvar_innodb-safe-binlog"/> <name>innodb-safe-binlog</name> @@ -4611,7 +4723,8 @@ <xrefto id="optvar_innodb_commit_concurrency"/> <name>innodb_commit_concurrency</name> <shortdescription lang="en">Helps in performance tuning in heavily - concurrent environments</shortdescription> + concurrent environments</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_commit_concurrency=#" setvar="innodb_commit_concurrency"/> @@ -4624,11 +4737,30 @@ <manual version="5.1"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin_innodb_commit_concurrency"> + <xrefto id="optvar_plugin_innodb_commit_concurrency"/> + <name>plugin_innodb_commit_concurrency</name> + <shortdescription lang="en">Helps in performance tuning in heavily + concurrent environments</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_commit_concurrency=#" + setvar="plugin_innodb_commit_concurrency"/> + <optype class="mycnf"/> + <vartype class="server" scope="both" isdynamic="yes"/> + </types> + <values vartype="numeric" platform="all" inversion="5.0.12"/> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb_concurrency_tickets"> <xrefto id="optvar_innodb_concurrency_tickets"/> <name>innodb_concurrency_tickets</name> <shortdescription lang="en">Number of times a thread is allowed to enter - InnoDB within the same SQL query after it has once got the ticket</shortdescription> + InnoDB within the same SQL query after it has once got the ticket + </shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_concurrency_tickets=#" setvar="innodb_concurrency_tickets"/> @@ -4644,12 +4776,31 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_data_file_path"> - + <option command="mysqld" section="innodb" id="plugin_innodb_concurrency_tickets"> + <xrefto id="optvar_plugin_innodb_concurrency_tickets"/> + <name>plugin_innodb_concurrency_tickets</name> + <shortdescription lang="en">Number of times a thread is allowed to enter + InnoDB within the same SQL query after it has once got the ticket</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_concurrency_tickets=#" + setvar="plugin_innodb_concurrency_tickets"/> + <optype class="mycnf"/> + <vartype class="server" scope="both" isdynamic="yes"/> + </types> + <values vartype="numeric" platform="all" inversion="5.0.3"> + <value default="500"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_data_file_path"> <xrefto id="optvar_innodb_data_file_path"/> <name>innodb_data_file_path</name> <shortdescription lang="en">Path to individual files and their sizes</shortdescription> <seealso xref="innodb_data_home_dir"/> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_data_file_path=name"/> <optype class="mycnf"/> @@ -4662,12 +4813,28 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_data_home_dir"> - + <option command="mysqld" section="innodb" id="plugin_innodb_data_file_path"> + <xrefto id="optvar_plugin_innodb_data_file_path"/> + <name>plugin_innodb_data_file_path</name> + <shortdescription lang="en">Path to individual files and their sizes</shortdescription> + <seealso xref="plugin_innodb_data_home_dir"/> + <types> + <optype class="cmdline" format="--plugin_innodb_data_file_path=name"/> + <optype class="mycnf"/> + <vartype class="server" scope="both" isdynamic="no"/> + </types> + <values vartype="filename" platform="all"/> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_data_home_dir"> <xrefto id="optvar_innodb_data_home_dir"/> <name>innodb_data_home_dir</name> <shortdescription lang="en">The common part for InnoDB table spaces</shortdescription> <seealso xref="innodb_data_file_path"/> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_data_home_dir=name" setvar="innodb_data_home_dir"/> @@ -4681,11 +4848,28 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb-doublewrite"> - + <option command="mysqld" section="innodb" id="plugin_innodb_data_home_dir"> + <xrefto id="optvar_plugin_innodb_data_home_dir"/> + <name>plugin_innodb_data_home_dir</name> + <shortdescription lang="en">The common part for InnoDB table spaces</shortdescription> + <seealso xref="plugin_innodb_data_file_path"/> + <types> + <optype class="cmdline" format="--plugin_innodb_data_home_dir=name" + setvar="plugin_innodb_data_home_dir"/> + <optype class="mycnf"/> + <vartype class="server" scope="both" isdynamic="no"/> + </types> + <values vartype="filename" platform="all"/> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb-doublewrite"> <xrefto id="optvar_innodb-doublewrite"/> <name>innodb-doublewrite</name> <shortdescription lang="en">Enable InnoDB doublewrite buffer</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb-doublewrite" setvar="innodb_doublewrite"/> @@ -4698,12 +4882,27 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_fast_shutdown"> - + <option command="mysqld" section="innodb" id="plugin-innodb-doublewrite"> + <xrefto id="optvar_plugin-innodb-doublewrite"/> + <name>plugin-innodb-doublewrite</name> + <shortdescription lang="en">Enable InnoDB doublewrite buffer</shortdescription> + <types> + <optype class="cmdline" format="--plugin-innodb-doublewrite" + setvar="plugin_innodb_doublewrite"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_fast_shutdown"> <xrefto id="optvar_innodb_fast_shutdown"/> <name>innodb_fast_shutdown</name> <shortdescription lang="en">Speeds up the shutdown process of the InnoDB - storage engine</shortdescription> + storage engine</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_fast_shutdown[=#]" setvar="innodb_fast_shutdown"/> @@ -4722,10 +4921,34 @@ <manual version="5.1"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin_innodb_fast_shutdown"> + <xrefto id="optvar_plugin_innodb_fast_shutdown"/> + <name>plugin_innodb_fast_shutdown</name> + <shortdescription lang="en">Speeds up the shutdown process of the InnoDB + storage engine</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_fast_shutdown[=#]" + setvar="plugin_innodb_fast_shutdown"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="numeric" platform="all"> + <value default="1"/> + <choice value="0"/> + <choice value="1"/> + <choice value="2"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb_file_io_threads"> <xrefto id="optvar_innodb_file_io_threads"/> <name>innodb_file_io_threads</name> - <shortdescription lang="en">Number of file I/O threads in InnoDB</shortdescription> + <shortdescription lang="en">Number of file I/O threads in InnoDB + </shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_file_io_threads=#" setvar="innodb_file_io_threads"/> @@ -4741,11 +4964,30 @@ <manual version="5.1"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin_innodb_file_io_threads"> + <xrefto id="optvar_plugin_innodb_file_io_threads"/> + <name>plugin_innodb_file_io_threads</name> + <shortdescription lang="en">Number of file I/O threads in InnoDB</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_file_io_threads=#" + setvar="plugin_innodb_file_io_threads"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="numeric" platform="all"> + <value default="4"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb_file_per_table"> <xrefto id="optvar_innodb_file_per_table"/> <name>innodb_file_per_table</name> <shortdescription lang="en">Stores each InnoDB table to an .ibd file in the - database dir</shortdescription> + database dir</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_file_per_table" setvar="innodb_file_per_table"/> @@ -4759,13 +5001,29 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_flush_log_at_trx_commit"> - + <option command="mysqld" section="innodb" id="plugin_innodb_file_per_table"> + <xrefto id="optvar_plugin_innodb_file_per_table"/> + <name>plugin_innodb_file_per_table</name> + <shortdescription lang="en">Stores each InnoDB table to an .ibd file in the + database dir</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_file_per_table" + setvar="plugin_innodb_file_per_table"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_flush_log_at_trx_commit"> <xrefto id="optvar_innodb_flush_log_at_trx_commit"/> <name>innodb_flush_log_at_trx_commit</name> <shortdescription lang="en">Set to 0 (write and flush once per second), 1 (write and flush at each commit) or 2 (write at commit, flush once per second)</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_flush_log_at_trx_commit[=#]" setvar="innodb_flush_log_at_trx_commit"/> @@ -4784,11 +5042,34 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_flush_method"> - + <option command="mysqld" section="innodb" id="plugin_innodb_flush_log_at_trx_commit"> + <xrefto id="optvar_plugin_innodb_flush_log_at_trx_commit"/> + <name>plugin_innodb_flush_log_at_trx_commit</name> + <shortdescription lang="en">Set to 0 (write and flush once per second), 1 + (write and flush at each commit) or 2 (write at commit, flush once per + second)</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_flush_log_at_trx_commit[=#]" + setvar="plugin_innodb_flush_log_at_trx_commit"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="numeric" platform="all"> + <value default="1"/> + <choice value="0"/> + <choice value="1"/> + <choice value="2"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_flush_method"> <xrefto id="optvar_innodb_flush_method"/> <name>innodb_flush_method</name> <shortdescription lang="en">With which method to flush data</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_flush_method=name" setvar="innodb_flush_method"/> @@ -4822,12 +5103,48 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_force_recovery"> - + <option command="mysqld" section="innodb" id="plugin_innodb_flush_method"> + <xrefto id="optvar_plugin_innodb_flush_method"/> + <name>plugin_innodb_flush_method</name> + <shortdescription lang="en">With which method to flush data</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_flush_method=name" + setvar="plugin_innodb_flush_method"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="enumeration" platform="windows"> + <value default="async_unbuffered"/> + </values> + <values vartype="enumeration" platform="linux"> + <value default="fdatasync"/> + <choice value="fdatasync"/> + <choice value="O_DSYNC"/> + <choice value="O_DIRECT"/> + </values> + <values vartype="enumeration" platform="hpux"> + <value default="fdatasync"/> + <choice value="fdatasync"/> + <choice value="O_DSYNC"/> + <choice value="O_DIRECT"/> + </values> + <values vartype="enumeration" platform="solaris"> + <value default="fdatasync"/> + <choice value="fdatasync"/> + <choice value="O_DSYNC"/> + <choice value="O_DIRECT"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_force_recovery"> <xrefto id="optvar_innodb_force_recovery"/> <name>innodb_force_recovery</name> <shortdescription lang="en">Helps to save your data in case the disk image - of the database becomes corrupt</shortdescription> + of the database becomes corrupt</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_force_recovery=#" setvar="innodb_force_recovery"/> @@ -4850,12 +5167,38 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_lock_wait_timeout"> - + <option command="mysqld" section="innodb" id="plugin_innodb_force_recovery"> + <xrefto id="optvar_plugin_innodb_force_recovery"/> + <name>plugin_innodb_force_recovery</name> + <shortdescription lang="en">Helps to save your data in case the disk image + of the database becomes corrupt</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_force_recovery=#" + setvar="plugin_innodb_force_recovery"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="enumeration" platform="all"> + <value default="0"/> + <choice value="0"/> + <choice value="SRV_FORCE_IGNORE_CORRUPT"/> + <choice value="SRV_FORCE_NO_BACKGROUND"/> + <choice value="SRV_FORCE_NO_TRX_UNDO"/> + <choice value="SRV_FORCE_NO_IBUF_MERGE"/> + <choice value="SRV_FORCE_NO_UNDO_LOG_SCAN"/> + <choice value="SRV_FORCE_NO_LOG_REDO"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_lock_wait_timeout"> <xrefto id="optvar_innodb_lock_wait_timeout"/> <name>innodb_lock_wait_timeout</name> <shortdescription lang="en">Timeout in seconds an InnoDB transaction may - wait for a lock before being rolled back</shortdescription> + wait for a lock before being rolled back</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_lock_wait_timeout=#" setvar="innodb_lock_wait_timeout"/> @@ -4871,12 +5214,31 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_locks_unsafe_for_binlog"> - + <option command="mysqld" section="innodb" id="plugin_innodb_lock_wait_timeout"> + <xrefto id="optvar_plugin_innodb_lock_wait_timeout"/> + <name>plugin_innodb_lock_wait_timeout</name> + <shortdescription lang="en">Timeout in seconds an InnoDB transaction may + wait for a lock before being rolled back</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_lock_wait_timeout=#" + setvar="plugin_innodb_lock_wait_timeout"/> + <optype class="mycnf"/> + <vartype isdynamic="no" class="server" scope="both"/> + </types> + <values vartype="numeric" platform="all"> + <value default="50"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_locks_unsafe_for_binlog"> <xrefto id="optvar_innodb_locks_unsafe_for_binlog"/> <name>innodb_locks_unsafe_for_binlog</name> <shortdescription lang="en">Force InnoDB not to use next-key locking. - Instead use only row-level locking</shortdescription> + Instead use only row-level locking</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_locks_unsafe_for_binlog" setvar="innodb_locks_unsafe_for_binlog"/> @@ -4893,8 +5255,26 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_log_arch_dir"> - + <option command="mysqld" section="innodb" id="plugin_innodb_locks_unsafe_for_binlog"> + <xrefto id="optvar_plugin_innodb_locks_unsafe_for_binlog"/> + <name>plugin_innodb_locks_unsafe_for_binlog</name> + <shortdescription lang="en">Force InnoDB not to use next-key locking. + Instead use only row-level locking</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_locks_unsafe_for_binlog" + setvar="plugin_innodb_locks_unsafe_for_binlog"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="boolean" platform="all"> + <value default="FALSE"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_log_arch_dir"> <name>innodb_log_arch_dir</name> <shortdescription lang="en">Where full logs should be archived</shortdescription> <deprecated version="5.0.24"/> @@ -4911,11 +5291,12 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_log_archive"> - + <option command="mysqld" section="innodb" id="innodb_log_archive"> <xrefto id="optvar_innodb_log_archive"/> <name>innodb_log_archive</name> - <shortdescription lang="en">Set to 1 if you want to have logs archived</shortdescription> + <shortdescription lang="en">Set to 1 if you want to have logs archived + </shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_log_archive[=#]"/> <optype class="mycnf"/> @@ -4930,12 +5311,28 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_log_buffer_size"> - + <option command="mysqld" section="innodb" id="plugin_innodb_log_archive"> + <xrefto id="optvar_plugin_innodb_log_archive"/> + <name>plugin_innodb_log_archive</name> + <shortdescription lang="en">Set to 1 if you want to have logs archived</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_log_archive[=#]"/> + <optype class="mycnf"/> + <vartype class="server" scope="both" isdynamic="no"/> + </types> + <values vartype="numeric" platform="all"> + <value default="0"/> + </values> + <versions> + <manual version="5.1"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_log_buffer_size"> <xrefto id="optvar_innodb_log_buffer_size"/> <name>innodb_log_buffer_size</name> <shortdescription lang="en">The size of the buffer which InnoDB uses to - write log to the log files on disk</shortdescription> + write log to the log files on disk</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_log_buffer_size=#" setvar="innodb_log_buffer_size"/> @@ -4951,12 +5348,30 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_log_file_size"> - + <option command="mysqld" section="innodb" id="plugin_innodb_log_buffer_size"> + <xrefto id="optvar_plugin_innodb_log_buffer_size"/> + <name>plugin_innodb_log_buffer_size</name> + <shortdescription lang="en">The size of the buffer which InnoDB uses to + write log to the log files on disk</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_log_buffer_size=#" + setvar="plugin_innodb_log_buffer_size"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="numeric" platform="all"> + <value default="1048576"/> + </values> + <versions> + <manual version="5.1"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_log_file_size"> <xrefto id="optvar_innodb_log_file_size"/> <name>innodb_log_file_size</name> - <shortdescription lang="en">Size of each log file in a log group</shortdescription> - + <shortdescription lang="en">Size of each log file in a log group + </shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_log_file_size=#" setvar="innodb_log_file_size"/> @@ -4972,13 +5387,31 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_log_files_in_group"> - + <option command="mysqld" section="innodb" id="plugin_innodb_log_file_size"> + <xrefto id="optvar_plugin_innodb_log_file_size"/> + <name>plugin_innodb_log_file_size</name> + <shortdescription lang="en">Size of each log file in a log group + </shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_log_file_size=#" + setvar="plugin_innodb_log_file_size"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="numeric" platform="all"> + <value default="5242880"/> + </values> + <versions> + <manual version="5.1"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_log_files_in_group"> <xrefto id="optvar_innodb_log_files_in_group"/> <name>innodb_log_files_in_group</name> <shortdescription lang="en">Number of log files in the log group. InnoDB - writes to the files in a circular fashion. Value 3 is recommended here</shortdescription> - + writes to the files in a circular fashion. Value 3 is recommended here + </shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_log_files_in_group=#" setvar="innodb_log_files_in_group"/> @@ -4994,11 +5427,30 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_log_group_home_dir"> - + <option command="mysqld" section="innodb" id="plugin_innodb_log_files_in_group"> + <xrefto id="optvar_plugin_innodb_log_files_in_group"/> + <name>plugin_innodb_log_files_in_group</name> + <shortdescription lang="en">Number of log files in the log group. InnoDB + writes to the files in a circular fashion. Value 3 is recommended here + </shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_log_files_in_group=#" + setvar="plugin_innodb_log_files_in_group"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="numeric" platform="all"> + <value default="2"/> + </values> + <versions> + <manual version="5.1"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_log_group_home_dir"> <xrefto id="optvar_innodb_log_group_home_dir"/> <name>innodb_log_group_home_dir</name> <shortdescription lang="en">Path to InnoDB log files</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_log_group_home_dir=name" setvar="innodb_log_group_home_dir"/> @@ -5012,12 +5464,27 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_max_dirty_pages_pct"> - + <option command="mysqld" section="innodb" id="plugin_innodb_log_group_home_dir"> + <xrefto id="optvar_plugin_innodb_log_group_home_dir"/> + <name>plugin_innodb_log_group_home_dir</name> + <shortdescription lang="en">Path to InnoDB log files</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_log_group_home_dir=name" + setvar="plugin_innodb_log_group_home_dir"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="filename" platform="all"/> + <versions> + <manual version="5.1"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_max_dirty_pages_pct"> <xrefto id="optvar_innodb_max_dirty_pages_pct"/> <name>innodb_max_dirty_pages_pct</name> - <shortdescription lang="en">Percentage of dirty pages allowed in bufferpool</shortdescription> - + <shortdescription lang="en">Percentage of dirty pages allowed in bufferpool + </shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_max_dirty_pages_pct=#" setvar="innodb_max_dirty_pages_pct"/> @@ -5033,13 +5500,31 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_max_purge_lag"> - + <option command="mysqld" section="innodb" id="plugin_innodb_max_dirty_pages_pct"> + <xrefto id="optvar_plugin_innodb_max_dirty_pages_pct"/> + <name>plugin_innodb_max_dirty_pages_pct</name> + <shortdescription lang="en">Percentage of dirty pages allowed in bufferpool + </shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_max_dirty_pages_pct=#" + setvar="plugin_innodb_max_dirty_pages_pct"/> + <optype class="mycnf"/> + <vartype isdynamic="yes" class="server" scope="both"/> + </types> + <values vartype="numeric" platform="all"> + <value default="90" maximum="100" minimum="0"/> + </values> + <versions> + <manual version="5.1"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_max_purge_lag"> <xrefto id="optvar_innodb_max_purge_lag"/> <name>innodb_max_purge_lag</name> <shortdescription lang="en">Desired maximum length of the purge queue (0 = - no limit)</shortdescription> - + no limit) + </shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_max_purge_lag=#" setvar="innodb_max_purge_lag"/> @@ -5056,12 +5541,31 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_mirrored_log_groups"> - + <option command="mysqld" section="innodb" id="plugin_innodb_max_purge_lag"> + <xrefto id="optvar_plugin_innodb_max_purge_lag"/> + <name>plugin_innodb_max_purge_lag</name> + <shortdescription lang="en">Desired maximum length of the purge queue (0 = + no limit) + </shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_max_purge_lag=#" + setvar="plugin_innodb_max_purge_lag"/> + <optype class="mycnf"/> + <vartype isdynamic="yes" class="server" scope="both"/> + </types> + <values vartype="numeric" platform="all"> + <value default="0"/> + </values> + <versions> + <manual version="5.1"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_mirrored_log_groups"> <xrefto id="optvar_innodb_mirrored_log_groups"/> <name>innodb_mirrored_log_groups</name> <shortdescription lang="en">Number of identical copies of log groups we keep - for the database</shortdescription> + for the database</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_mirrored_log_groups=#" setvar="innodb_mirrored_log_groups"/> @@ -5077,12 +5581,31 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_open_files"> - + <option command="mysqld" section="innodb" id="plugin_innodb_mirrored_log_groups"> + <xrefto id="optvar_plugin_innodb_mirrored_log_groups"/> + <name>plugin_innodb_mirrored_log_groups</name> + <shortdescription lang="en">Number of identical copies of log groups we keep + for the database</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_mirrored_log_groups=#" + setvar="plugin_innodb_mirrored_log_groups"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="numeric" platform="all"> + <value default="1"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_open_files"> <xrefto id="optvar_innodb_open_files"/> <name>innodb_open_files</name> <shortdescription lang="en">How many files at the maximum InnoDB keeps open - at the same time</shortdescription> + at the same time</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_open_files=#" setvar="innodb_open_files"/> @@ -5099,12 +5622,31 @@ <manual version="5.1"/> </versions> </option> - <option command="mysqld" section="innodb" id="innodb_rollback_on_timeout"> - + <option command="mysqld" section="innodb" id="plugin_innodb_open_files"> + <xrefto id="optvar_plugin_innodb_open_files"/> + <name>plugin_innodb_open_files</name> + <shortdescription lang="en">How many files at the maximum InnoDB keeps open + at the same time</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_open_files=#" + setvar="plugin_innodb_open_files"/> + <optype class="mycnf"/> + <vartype isdynamic="no" scope="both" class="server"/> + </types> + <values vartype="numeric" platform="all"> + <value default="300" minimum="10"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.8"/> + </versions> + </option> + <option command="mysqld" section="innodb" id="innodb_rollback_on_timeout"> <xrefto id="optvar_innodb_rollback_on_timeout"/> <name>innodb_rollback_on_timeout</name> <shortdescription lang="en">Roll back entire transaction on transaction - timeout, not just last statement</shortdescription> + timeout, not just last statement</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_rollback_on_timeout" setvar="innodb_rollback_on_timeout"/> @@ -5118,10 +5660,27 @@ <introduced version="5.1.15"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin_innodb_rollback_on_timeout"> + <xrefto id="optvar_plugin_innodb_rollback_on_timeout"/> + <name>plugin_innodb_rollback_on_timeout</name> + <shortdescription lang="en">Roll back entire transaction on transaction + timeout, not just last statement</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_rollback_on_timeout" + setvar="plugin_innodb_rollback_on_timeout"/> + <optype class="mycnf" inversion="5.0.32"/> + <vartype class="server" isdynamic="no" inversion="5.0.32"/> + </types> + <versions> + <manual version="5.1"/> + <introduced version="5.1.18"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb_stats_on_metadata"> <!-- <xrefto id="optvar_innodb_stats_on_metadata"/> --> <name>innodb_stats_on_metadata</name> <shortdescription lang="en">Enable or disable InnoDB table statistics updates for metadata statements</shortdescription> + <deprecated version="5.1.8"/> <types> <optype class="cmdline" format="--innodb_stats_on_metadata" setvar="innodb_stats_on_metadata"/> @@ -5136,6 +5695,23 @@ <introduced version="5.1.17"/> </versions> </option> + <option command="mysqld" section="innodb" id="plugin_innodb_stats_on_metadata"> + <name>plugin_innodb_stats_on_metadata</name> + <shortdescription lang="en">Enable or disable InnoDB table statistics updates for metadata statements</shortdescription> + <types> + <optype class="cmdline" format="--plugin_innodb_stats_on_metadata" + setvar="plugin_innodb_stats_on_metadata"/> + <optype class="mycnf"/> + <vartype isdynamic="no" class="server"/> + </types> + <values vartype="boolean" platform="all"> + <value default="ON"/> + </values> + <versions> + <manual version="5.1"/> + <introduced version="5.1.18"/> + </versions> + </option> <option command="mysqld" section="innodb" id="innodb_status_file"> <xrefto id="optvar_innodb_status_file"/> @@ -9321,8 +9897,7 @@ <introduced version="5.1.8"/> </versions> </option> - <option command="mysqld" section="server" id="table_cache"> - + <option command="mysqld" section="server" id="table_cache"> <xrefto id="optvar_table_cache"/> <name>table_cache</name> <shortdescription lang="en">Deprecated; use --table_open_cache instead</shortdescription>
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r6474 - trunk/dynamic-docs/command-optvars | plavin | 15 May |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.860 sec. using MySQL 5.1.14-beta-log