<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>System Variable Index</title><link rel="stylesheet" href="mysql-html.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.69.1"><link rel="start" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="up" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="prev" href="dynindex-statement.html" title="Statement/Syntax Index"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">System Variable Index</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dynindex-statement.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> </td></tr></table><hr></div><div class="index"><div class="titlepage"><div><div><h2 class="title"><a name="dynindex-sysvar"></a>System Variable Index</h2></div></div></div><div class="indexdiv"><h3 class="title"><code class="literal">auto_increment_increment</code></h3><dl><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-limitations-resolved" title="17.1.5.11. Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster
NDB 6.x">Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster
NDB 6.x”</a></dt><dt><a href="replication.html#replication-options-master" title="16.1.3.2. Replication Master Options and Variables">Section 16.1.3.2, “Replication Master Options and Variables”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="tutorial.html#example-auto-increment" title="3.6.9. Using AUTO_INCREMENT">Section 3.6.9, “Using <code class="literal">AUTO_INCREMENT</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">auto_increment_offset</code></h3><dl><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-limitations-resolved" title="17.1.5.11. Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster
NDB 6.x">Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster
NDB 6.x”</a></dt><dt><a href="replication.html#replication-options-master" title="16.1.3.2. Replication Master Options and Variables">Section 16.1.3.2, “Replication Master Options and Variables”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="tutorial.html#example-auto-increment" title="3.6.9. Using AUTO_INCREMENT">Section 3.6.9, “Using <code class="literal">AUTO_INCREMENT</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">autocommit</code></h3><dl><dt><a href="sql-syntax.html#delete" title="12.2.2. DELETE Syntax">Section 12.2.2, “<code class="literal">DELETE</code> Syntax”</a></dt><dt><a href="storage-engines.html#innodb-locking-reads" title="13.6.8.3. SELECT ... FOR UPDATE
and SELECT ... LOCK IN
SHARE MODE Locking Reads">Section 13.6.8.3, “<code class="literal">SELECT ... FOR UPDATE</code>
and <code class="literal">SELECT ... LOCK IN
SHARE MODE</code> Locking Reads”</a></dt><dt><a href="sql-syntax.html#commit" title="12.4.1. START TRANSACTION,
COMMIT, and
ROLLBACK Syntax">Section 12.4.1, “<code class="literal">START TRANSACTION</code>,
<code class="literal">COMMIT</code>, and
<code class="literal">ROLLBACK</code> Syntax”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-changes-5-1-ndb-6-3" title="17.1.4.4. Features Added in MySQL Cluster NDB 6.3">Section 17.1.4.4, “Features Added in MySQL Cluster NDB 6.3”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">autocommit = 0</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="storage-engines.html#innodb-deadlock-detection" title="13.6.8.8. Deadlock Detection and Rollback">Section 13.6.8.8, “Deadlock Detection and Rollback”</a></dt><dt><a href="storage-engines.html#innodb-locks-set" title="13.6.8.6. Locks Set by Different SQL Statements in InnoDB">Section 13.6.8.6, “Locks Set by Different SQL Statements in <code class="literal">InnoDB</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">autocommit = 1</code></h3><dl><dt><a href="storage-engines.html#innodb-deadlocks" title="13.6.8.9. How to Cope with Deadlocks">Section 13.6.8.9, “How to Cope with Deadlocks”</a></dt><dt><a href="sql-syntax.html#lock-tables-and-transactions" title="12.4.5.1. Interaction of Table Locking and Transactions">Section 12.4.5.1, “Interaction of Table Locking and Transactions”</a></dt><dt><a href="storage-engines.html#innodb-restrictions" title="13.6.14. Restrictions on InnoDB Tables">Section 13.6.14, “Restrictions on <code class="literal">InnoDB</code> Tables”</a></dt><dt><a href="introduction.html#ansi-diff-transactions" title="1.7.5.2. Transactions and Atomic Operations">Section 1.7.5.2, “Transactions and Atomic Operations”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">automatic_sp_privileges</code></h3><dl><dt><a href="sql-syntax.html#create-procedure" title="12.1.15. CREATE PROCEDURE and
CREATE FUNCTION Syntax">Section 12.1.15, “<code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="stored-programs-views.html#stored-routines-privileges" title="19.2.2. Stored Routines and MySQL Privileges">Section 19.2.2, “Stored Routines and MySQL Privileges”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">back_log</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">basedir</code></h3><dl><dt><a href="sql-syntax.html#install-plugin" title="12.5.3.3. INSTALL PLUGIN Syntax">Section 12.5.3.3, “<code class="literal">INSTALL PLUGIN</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">bdb_cache_size</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">bdb_home</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">bdb_log_buffer_size</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">bdb_logdir</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">bdb_max_lock</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">bdb_shared_data</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">bdb_tmpdir</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">bdb_version</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">big_tables</code></h3><dl><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">binlog_cache_size</code></h3><dl><dt><a href="replication.html#replication-options-binary-log" title="16.1.3.4. Binary Log Options and Variables">Section 16.1.3.4, “Binary Log Options and Variables”</a></dt><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">binlog_format</code></h3><dl><dt><a href="replication.html#replication-options-binary-log" title="16.1.3.4. Binary Log Options and Variables">Section 16.1.3.4, “Binary Log Options and Variables”</a></dt><dt><a href="server-administration.html#binary-log-mysql-database" title="5.2.4.4. Logging Format for Changes to mysql Database Tables">Section 5.2.4.4, “Logging Format for Changes to <code class="literal">mysql</code> Database Tables”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-faq" title="16.3.4. Replication FAQ">Section 16.3.4, “Replication FAQ”</a></dt><dt><a href="replication.html#replication-features-mysqldb" title="16.3.1.19. Replication of the System mysql Database">Section 16.3.1.19, “Replication of the System <code class="literal">mysql</code> Database”</a></dt><dt><a href="server-administration.html#binary-log-setting" title="5.2.4.2. Setting The Binary Log Format">Section 5.2.4.2, “Setting The Binary Log Format”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">bulk_insert_buffer_size</code></h3><dl><dt><a href="storage-engines.html#myisam-start" title="13.5.1. MyISAM Startup Options">Section 13.5.1, “<code class="literal">MyISAM</code> Startup Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="optimization.html#insert-speed" title="7.2.21. Speed of INSERT Statements">Section 7.2.21, “Speed of <code class="literal">INSERT</code> Statements”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">character_set</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">character_set_client</code></h3><dl><dt><a href="sql-syntax.html#load-data" title="12.2.6. LOAD DATA INFILE
Syntax">Section 12.2.6, “<code class="literal">LOAD DATA INFILE</code>
Syntax”</a></dt><dt><a href="sql-syntax.html#set-option" title="12.5.4. SET Syntax">Section 12.5.4, “<code class="literal">SET</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-event" title="12.5.5.9. SHOW CREATE EVENT Syntax">Section 12.5.5.9, “<code class="literal">SHOW CREATE EVENT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-procedure" title="12.5.5.11. SHOW CREATE PROCEDURE Syntax">Section 12.5.5.11, “<code class="literal">SHOW CREATE PROCEDURE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-view" title="12.5.5.14. SHOW CREATE VIEW Syntax">Section 12.5.5.14, “<code class="literal">SHOW CREATE VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-events" title="12.5.5.19. SHOW EVENTS Syntax">Section 12.5.5.19, “<code class="literal">SHOW EVENTS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-procedure-status" title="12.5.5.30. SHOW PROCEDURE STATUS Syntax">Section 12.5.5.30, “<code class="literal">SHOW PROCEDURE STATUS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-triggers" title="12.5.5.40. SHOW TRIGGERS Syntax">Section 12.5.5.40, “<code class="literal">SHOW TRIGGERS</code> Syntax”</a></dt><dt><a href="connectors-apis.html#c-api-prepared-statement-datatypes" title="21.9.5. C API Prepared Statement Data types">Section 21.9.5, “C API Prepared Statement Data types”</a></dt><dt><a href="internationalization-localization.html#charset-connection" title="9.1.4. Connection Character Sets and Collations">Section 9.1.4, “Connection Character Sets and Collations”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="information-schema.html#events-table" title="20.20. The INFORMATION_SCHEMA EVENTS Table">Section 20.20, “The <code class="literal">INFORMATION_SCHEMA EVENTS</code> Table”</a></dt><dt><a href="information-schema.html#routines-table" title="20.14. The INFORMATION_SCHEMA ROUTINES Table">Section 20.14, “The <code class="literal">INFORMATION_SCHEMA ROUTINES</code> Table”</a></dt><dt><a href="information-schema.html#triggers-table" title="20.16. The INFORMATION_SCHEMA TRIGGERS Table">Section 20.16, “The <code class="literal">INFORMATION_SCHEMA TRIGGERS</code> Table”</a></dt><dt><a href="information-schema.html#views-table" title="20.15. The INFORMATION_SCHEMA VIEWS Table">Section 20.15, “The <code class="literal">INFORMATION_SCHEMA VIEWS</code> Table”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">character_set_connection</code></h3><dl><dt><a href="internationalization-localization.html#charset-convert" title="9.1.9.2. CONVERT() and
CAST()">Section 9.1.9.2, “<code class="literal">CONVERT()</code> and
<code class="literal">CAST()</code>”</a></dt><dt><a href="sql-syntax.html#set-option" title="12.5.4. SET Syntax">Section 12.5.4, “<code class="literal">SET</code> Syntax”</a></dt><dt><a href="internationalization-localization.html#charset-literal" title="9.1.3.5. Character String Literal Character Set and Collation">Section 9.1.3.5, “Character String Literal Character Set and Collation”</a></dt><dt><a href="internationalization-localization.html#charset-collation-charset" title="9.1.7.6. Collations Must Be for the Right Character Set">Section 9.1.7.6, “Collations Must Be for the Right Character Set”</a></dt><dt><a href="internationalization-localization.html#charset-connection" title="9.1.4. Connection Character Sets and Collations">Section 9.1.4, “Connection Character Sets and Collations”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="internationalization-localization.html#locale-support" title="9.8. MySQL Server Locale Support">Section 9.8, “MySQL Server Locale Support”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="internationalization-localization.html#charset-repertoire" title="9.1.8. String Repertoire">Section 9.1.8, “String Repertoire”</a></dt><dt><a href="language-structure.html#string-syntax" title="8.1.1. Strings">Section 8.1.1, “Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">character_set_database</code></h3><dl><dt><a href="sql-syntax.html#create-procedure" title="12.1.15. CREATE PROCEDURE and
CREATE FUNCTION Syntax">Section 12.1.15, “<code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#load-data" title="12.2.6. LOAD DATA INFILE
Syntax">Section 12.2.6, “<code class="literal">LOAD DATA INFILE</code>
Syntax”</a></dt><dt><a href="sql-syntax.html#set-option" title="12.5.4. SET Syntax">Section 12.5.4, “<code class="literal">SET</code> Syntax”</a></dt><dt><a href="internationalization-localization.html#charset-connection" title="9.1.4. Connection Character Sets and Collations">Section 9.1.4, “Connection Character Sets and Collations”</a></dt><dt><a href="internationalization-localization.html#charset-database" title="9.1.3.2. Database Character Set and Collation">Section 9.1.3.2, “Database Character Set and Collation”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">character_set_filesystem</code></h3><dl><dt><a href="sql-syntax.html#load-data" title="12.2.6. LOAD DATA INFILE
Syntax">Section 12.2.6, “<code class="literal">LOAD DATA INFILE</code>
Syntax”</a></dt><dt><a href="sql-syntax.html#select" title="12.2.8. SELECT Syntax">Section 12.2.8, “<code class="literal">SELECT</code> Syntax”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">character_set_results</code></h3><dl><dt><a href="sql-syntax.html#set-option" title="12.5.4. SET Syntax">Section 12.5.4, “<code class="literal">SET</code> Syntax”</a></dt><dt><a href="internationalization-localization.html#charset-errors" title="9.1.6. Character Set for Error Messages">Section 9.1.6, “Character Set for Error Messages”</a></dt><dt><a href="internationalization-localization.html#charset-connection" title="9.1.4. Connection Character Sets and Collations">Section 9.1.4, “Connection Character Sets and Collations”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="internationalization-localization.html#charset-metadata" title="9.1.11. UTF-8 for Metadata">Section 9.1.11, “UTF-8 for Metadata”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">character_set_server</code></h3><dl><dt><a href="internationalization-localization.html#charset-connection" title="9.1.4. Connection Character Sets and Collations">Section 9.1.4, “Connection Character Sets and Collations”</a></dt><dt><a href="internationalization-localization.html#charset-database" title="9.1.3.2. Database Character Set and Collation">Section 9.1.3.2, “Database Character Set and Collation”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-charset" title="16.3.1.2. Replication and Character Sets">Section 16.3.1.2, “Replication and Character Sets”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="internationalization-localization.html#charset-server" title="9.1.3.1. Server Character Set and Collation">Section 9.1.3.1, “Server Character Set and Collation”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">character_set_system</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="internationalization-localization.html#charset-metadata" title="9.1.11. UTF-8 for Metadata">Section 9.1.11, “UTF-8 for Metadata”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">character_sets</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">character_sets_dir</code></h3><dl><dt><a href="internationalization-localization.html#adding-collation-simple-8bit" title="9.5.3. Adding a Simple Collation to an 8-Bit Character Set">Section 9.5.3, “Adding a Simple Collation to an 8-Bit Character Set”</a></dt><dt><a href="internationalization-localization.html#adding-collation-unicode-uca" title="9.5.4. Adding a UCA Collation to a Unicode Character Set">Section 9.5.4, “Adding a UCA Collation to a Unicode Character Set”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">collation_connection</code></h3><dl><dt><a href="internationalization-localization.html#charset-convert" title="9.1.9.2. CONVERT() and
CAST()">Section 9.1.9.2, “<code class="literal">CONVERT()</code> and
<code class="literal">CAST()</code>”</a></dt><dt><a href="sql-syntax.html#set-option" title="12.5.4. SET Syntax">Section 12.5.4, “<code class="literal">SET</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-event" title="12.5.5.9. SHOW CREATE EVENT Syntax">Section 12.5.5.9, “<code class="literal">SHOW CREATE EVENT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-procedure" title="12.5.5.11. SHOW CREATE PROCEDURE Syntax">Section 12.5.5.11, “<code class="literal">SHOW CREATE PROCEDURE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-view" title="12.5.5.14. SHOW CREATE VIEW Syntax">Section 12.5.5.14, “<code class="literal">SHOW CREATE VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-events" title="12.5.5.19. SHOW EVENTS Syntax">Section 12.5.5.19, “<code class="literal">SHOW EVENTS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-procedure-status" title="12.5.5.30. SHOW PROCEDURE STATUS Syntax">Section 12.5.5.30, “<code class="literal">SHOW PROCEDURE STATUS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-triggers" title="12.5.5.40. SHOW TRIGGERS Syntax">Section 12.5.5.40, “<code class="literal">SHOW TRIGGERS</code> Syntax”</a></dt><dt><a href="internationalization-localization.html#charset-literal" title="9.1.3.5. Character String Literal Character Set and Collation">Section 9.1.3.5, “Character String Literal Character Set and Collation”</a></dt><dt><a href="internationalization-localization.html#charset-collation-charset" title="9.1.7.6. Collations Must Be for the Right Character Set">Section 9.1.7.6, “Collations Must Be for the Right Character Set”</a></dt><dt><a href="internationalization-localization.html#charset-connection" title="9.1.4. Connection Character Sets and Collations">Section 9.1.4, “Connection Character Sets and Collations”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="information-schema.html#events-table" title="20.20. The INFORMATION_SCHEMA EVENTS Table">Section 20.20, “The <code class="literal">INFORMATION_SCHEMA EVENTS</code> Table”</a></dt><dt><a href="information-schema.html#routines-table" title="20.14. The INFORMATION_SCHEMA ROUTINES Table">Section 20.14, “The <code class="literal">INFORMATION_SCHEMA ROUTINES</code> Table”</a></dt><dt><a href="information-schema.html#triggers-table" title="20.16. The INFORMATION_SCHEMA TRIGGERS Table">Section 20.16, “The <code class="literal">INFORMATION_SCHEMA TRIGGERS</code> Table”</a></dt><dt><a href="information-schema.html#views-table" title="20.15. The INFORMATION_SCHEMA VIEWS Table">Section 20.15, “The <code class="literal">INFORMATION_SCHEMA VIEWS</code> Table”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">collation_database</code></h3><dl><dt><a href="sql-syntax.html#create-procedure" title="12.1.15. CREATE PROCEDURE and
CREATE FUNCTION Syntax">Section 12.1.15, “<code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="internationalization-localization.html#charset-connection" title="9.1.4. Connection Character Sets and Collations">Section 9.1.4, “Connection Character Sets and Collations”</a></dt><dt><a href="internationalization-localization.html#charset-database" title="9.1.3.2. Database Character Set and Collation">Section 9.1.3.2, “Database Character Set and Collation”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">collation_server</code></h3><dl><dt><a href="internationalization-localization.html#charset-connection" title="9.1.4. Connection Character Sets and Collations">Section 9.1.4, “Connection Character Sets and Collations”</a></dt><dt><a href="internationalization-localization.html#charset-database" title="9.1.3.2. Database Character Set and Collation">Section 9.1.3.2, “Database Character Set and Collation”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="replication.html#replication-features-charset" title="16.3.1.2. Replication and Character Sets">Section 16.3.1.2, “Replication and Character Sets”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="internationalization-localization.html#charset-server" title="9.1.3.1. Server Character Set and Collation">Section 9.1.3.1, “Server Character Set and Collation”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">completion_type</code></h3><dl><dt><a href="sql-syntax.html#commit" title="12.4.1. START TRANSACTION,
COMMIT, and
ROLLBACK Syntax">Section 12.4.1, “<code class="literal">START TRANSACTION</code>,
<code class="literal">COMMIT</code>, and
<code class="literal">ROLLBACK</code> Syntax”</a></dt><dt><a href="connectors-apis.html#mysql-commit" title="21.9.3.6. mysql_commit()">Section 21.9.3.6, “<code class="literal">mysql_commit()</code>”</a></dt><dt><a href="connectors-apis.html#mysql-rollback" title="21.9.3.57. mysql_rollback()">Section 21.9.3.57, “<code class="literal">mysql_rollback()</code>”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">concurrent_insert</code></h3><dl><dt><a href="optimization.html#concurrent-inserts" title="7.3.3. Concurrent Inserts">Section 7.3.3, “Concurrent Inserts”</a></dt><dt><a href="optimization.html#internal-locking" title="7.3.1. Internal Locking Methods">Section 7.3.1, “Internal Locking Methods”</a></dt><dt><a href="optimization.html#miscellaneous-optimization-tips" title="7.2.24. Other Optimization Tips">Section 7.2.24, “Other Optimization Tips”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">connect_timeout</code></h3><dl><dt><a href="error-handling.html#error-lost-connection" title="B.1.2.3. Lost connection to MySQL server">Section B.1.2.3, “<code class="literal">Lost connection to MySQL server</code>”</a></dt><dt><a href="connectors-apis.html#mysql-real-connect" title="21.9.3.52. mysql_real_connect()">Section 21.9.3.52, “<code class="literal">mysql_real_connect()</code>”</a></dt><dt><a href="error-handling.html#communication-errors" title="B.1.2.11. Communication Errors and Aborted Connections">Section B.1.2.11, “Communication Errors and Aborted Connections”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="programs.html#option-files" title="4.2.3.3. Using Option Files">Section 4.2.3.3, “Using Option Files”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">connect_timeout = 2</code></h3><dl><dt><a href="programs.html#option-files" title="4.2.3.3. Using Option Files">Section 4.2.3.3, “Using Option Files”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">convert_character_set</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">datadir</code></h3><dl><dt><a href="installing.html#windows-installation" title="2.5. Installing MySQL on Windows">Section 2.5, “Installing MySQL on Windows”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">date_format</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">datetime_format</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">debug</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">debug_sync</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">default_week_format</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">delay_key_write</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">delayed_insert_limit</code></h3><dl><dt><a href="sql-syntax.html#insert-delayed" title="12.2.5.2. INSERT DELAYED Syntax">Section 12.2.5.2, “<code class="literal">INSERT DELAYED</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">delayed_insert_timeout</code></h3><dl><dt><a href="sql-syntax.html#insert-delayed" title="12.2.5.2. INSERT DELAYED Syntax">Section 12.2.5.2, “<code class="literal">INSERT DELAYED</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">delayed_queue_size</code></h3><dl><dt><a href="sql-syntax.html#insert-delayed" title="12.2.5.2. INSERT DELAYED Syntax">Section 12.2.5.2, “<code class="literal">INSERT DELAYED</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">div_precision_increment</code></h3><dl><dt><a href="functions.html#arithmetic-functions" title="11.5.1. Arithmetic Operators">Section 11.5.1, “Arithmetic Operators”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">engine_condition_pushdown</code></h3><dl><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">error_count</code></h3><dl><dt><a href="sql-syntax.html#show-errors" title="12.5.5.18. SHOW ERRORS Syntax">Section 12.5.5.18, “<code class="literal">SHOW ERRORS</code> Syntax”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">event_scheduler</code></h3><dl><dt><a href="sql-syntax.html#show-processlist" title="12.5.5.31. SHOW PROCESSLIST Syntax">Section 12.5.5.31, “<code class="literal">SHOW PROCESSLIST</code> Syntax”</a></dt><dt><a href="connectors-apis.html#libmysqld-restrictions" title="21.8.2. Restrictions When Using the Embedded MySQL Server">Section 21.8.2, “Restrictions When Using the Embedded MySQL Server”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expire_logs_days</code></h3><dl><dt><a href="sql-syntax.html#purge-binary-logs" title="12.6.1.1. PURGE BINARY LOGS Syntax">Section 12.6.1.1, “<code class="literal">PURGE BINARY LOGS</code> Syntax”</a></dt><dt><a href="server-administration.html#log-file-maintenance" title="5.2.6. Server Log Maintenance">Section 5.2.6, “Server Log Maintenance”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">flush</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">flush_time</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">foreign_key_checks</code></h3><dl><dt><a href="storage-engines.html#innodb-foreign-key-constraints" title="13.6.4.4. FOREIGN KEY Constraints">Section 13.6.4.4, “<code class="literal">FOREIGN KEY</code> Constraints”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">foreign_key_checks = 0</code></h3><dl><dt><a href="storage-engines.html#innodb-foreign-key-constraints" title="13.6.4.4. FOREIGN KEY Constraints">Section 13.6.4.4, “<code class="literal">FOREIGN KEY</code> Constraints”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ft_boolean_syntax</code></h3><dl><dt><a href="functions.html#fulltext-fine-tuning" title="11.8.6. Fine-Tuning MySQL Full-Text Search">Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ft_max_word_len</code></h3><dl><dt><a href="replication.html#replication-howto-rawdata" title="16.1.1.6. Creating a Data Snapshot Using Raw Data Files">Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”</a></dt><dt><a href="functions.html#fulltext-fine-tuning" title="11.8.6. Fine-Tuning MySQL Full-Text Search">Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”</a></dt><dt><a href="extending-mysql.html#plugin-full-text-plugins" title="22.2.2. Full-Text Parser Plugins">Section 22.2.2, “Full-Text Parser Plugins”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ft_min_word_len</code></h3><dl><dt><a href="replication.html#replication-howto-rawdata" title="16.1.1.6. Creating a Data Snapshot Using Raw Data Files">Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”</a></dt><dt><a href="functions.html#fulltext-fine-tuning" title="11.8.6. Fine-Tuning MySQL Full-Text Search">Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”</a></dt><dt><a href="extending-mysql.html#plugin-full-text-plugins" title="22.2.2. Full-Text Parser Plugins">Section 22.2.2, “Full-Text Parser Plugins”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ft_query_expansion_limit</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ft_stopword_file</code></h3><dl><dt><a href="replication.html#replication-howto-rawdata" title="16.1.1.6. Creating a Data Snapshot Using Raw Data Files">Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”</a></dt><dt><a href="functions.html#fulltext-fine-tuning" title="11.8.6. Fine-Tuning MySQL Full-Text Search">Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">general_log</code></h3><dl><dt><a href="introduction.html#mysql-nutshell" title="1.4.1. What Is New in MySQL 5.1">Section 1.4.1, “What Is New in MySQL 5.1”</a></dt><dt><a href="server-administration.html#log-tables" title="5.2.1. Selecting General Query and Slow Query Log Output Destinations">Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#query-log" title="5.2.3. The General Query Log">Section 5.2.3, “The General Query Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">general_log_file</code></h3><dl><dt><a href="server-administration.html#log-tables" title="5.2.1. Selecting General Query and Slow Query Log Output Destinations">Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#query-log" title="5.2.3. The General Query Log">Section 5.2.3, “The General Query Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">group_concat_max_len</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_archive</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_bdb</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_blackhole_engine</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_community_features</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_compress</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_crypt</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_csv</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_dynamic_loading</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_example_engine</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_federated_engine</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_geometry</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_innodb</code></h3><dl><dt><a href="error-handling.html#non-transactional-tables" title="B.1.5.5. Rollback Failure for Nontransactional Tables">Section B.1.5.5, “Rollback Failure for Nontransactional Tables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_isam</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_merge_engine</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_ndbcluster</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_openssl</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#secure-using-ssl" title="5.5.7.2. Using SSL Connections">Section 5.5.7.2, “Using SSL Connections”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_partitioning</code></h3><dl><dt><a href="partitioning.html" title="Chapter 18. Partitioning">Chapter 18, <i>Partitioning</i></a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_profiling</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_query_cache</code></h3><dl><dt><a href="optimization.html#query-cache-configuration" title="7.5.5.3. Query Cache Configuration">Section 7.5.5.3, “Query Cache Configuration”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_raid</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_row_based_replication</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_rtree_keys</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_ssl</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#secure-using-ssl" title="5.5.7.2. Using SSL Connections">Section 5.5.7.2, “Using SSL Connections”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">have_symlink</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">hostname</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">identity</code></h3><dl><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ignore_builtin_innodb</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">init_connect</code></h3><dl><dt><a href="internationalization-localization.html#charset-applications" title="9.1.5. Configuring the Character Set and Collation for Applications">Section 9.1.5, “Configuring the Character Set and Collation for Applications”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">init_file</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">init_slave</code></h3><dl><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_adaptive_hash_index</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_additional_mem_pool_size</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_autoextend_increment</code></h3><dl><dt><a href="storage-engines.html#innodb-configuration" title="13.6.2. InnoDB Configuration">Section 13.6.2, “<code class="literal">InnoDB</code> Configuration”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="storage-engines.html#adding-and-removing" title="13.6.5. Adding, Removing, or Resizing InnoDB Data and Log
Files">Section 13.6.5, “Adding, Removing, or Resizing <code class="literal">InnoDB</code> Data and Log
Files”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_autoinc_lock_mode</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="storage-engines.html#innodb-auto-increment-configurable" title="13.6.4.3.2. Configurable InnoDB Auto-Increment Locking">Section 13.6.4.3.2, “Configurable <code class="literal">InnoDB</code> Auto-Increment Locking”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_buffer_pool_awe_mem_mb</code></h3><dl><dt><a href="storage-engines.html#innodb-configuration" title="13.6.2. InnoDB Configuration">Section 13.6.2, “<code class="literal">InnoDB</code> Configuration”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_buffer_pool_size</code></h3><dl><dt><a href="storage-engines.html#innodb-error-codes" title="13.6.12.1. InnoDB Error Codes">Section 13.6.12.1, “<code class="literal">InnoDB</code> Error Codes”</a></dt><dt><a href="storage-engines.html#innodb-tuning" title="13.6.13.1. InnoDB Performance Tuning Tips">Section 13.6.13.1, “<code class="literal">InnoDB</code> Performance Tuning Tips”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_checksums</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_commit_concurrency</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_concurrency_tickets</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_data_file_path</code></h3><dl><dt><a href="storage-engines.html#innodb-configuration" title="13.6.2. InnoDB Configuration">Section 13.6.2, “<code class="literal">InnoDB</code> Configuration”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="storage-engines.html#adding-and-removing" title="13.6.5. Adding, Removing, or Resizing InnoDB Data and Log
Files">Section 13.6.5, “Adding, Removing, or Resizing <code class="literal">InnoDB</code> Data and Log
Files”</a></dt><dt><a href="storage-engines.html#error-creating-innodb" title="13.6.2.4. Dealing with InnoDB Initialization Problems">Section 13.6.2.4, “Dealing with <code class="literal">InnoDB</code> Initialization Problems”</a></dt><dt><a href="storage-engines.html" title="Chapter 13. Storage Engines">Chapter 13, <i>Storage Engines</i></a></dt><dt><a href="http://dev.mysql.com/doc/refman/4.1/en/mysqld-max.html#mysqld-max" target="_top">The <span><strong class="command">mysqld-max</strong></span> Extended MySQL Server</a></dt><dt><a href="storage-engines.html#innodb-raw-devices" title="13.6.2.2. Using Raw Devices for the Shared Tablespace">Section 13.6.2.2, “Using Raw Devices for the Shared Tablespace”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_data_home_dir</code></h3><dl><dt><a href="storage-engines.html#innodb-configuration" title="13.6.2. InnoDB Configuration">Section 13.6.2, “<code class="literal">InnoDB</code> Configuration”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="storage-engines.html#error-creating-innodb" title="13.6.2.4. Dealing with InnoDB Initialization Problems">Section 13.6.2.4, “Dealing with <code class="literal">InnoDB</code> Initialization Problems”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_doublewrite</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_extra_dirty_writes</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_fast_shutdown</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="storage-engines.html#adding-and-removing" title="13.6.5. Adding, Removing, or Resizing InnoDB Data and Log
Files">Section 13.6.5, “Adding, Removing, or Resizing <code class="literal">InnoDB</code> Data and Log
Files”</a></dt><dt><a href="server-administration.html#server-shutdown" title="5.1.11. The Shutdown Process">Section 5.1.11, “The Shutdown Process”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_file_io_threads</code></h3><dl><dt><a href="storage-engines.html#innodb-general-monitor" title="13.6.13.2.1. InnoDB Standard Monitor and Lock Monitor Output">Section 13.6.13.2.1, “<code class="literal">InnoDB</code> Standard Monitor and Lock Monitor Output”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="extending-mysql.html#mysql-threads" title="22.1.1. MySQL Threads">Section 22.1.1, “MySQL Threads”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_file_per_table</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="storage-engines.html#innodb-and-mysql-replication" title="13.6.4.5. InnoDB and MySQL Replication">Section 13.6.4.5, “<code class="literal">InnoDB</code> and MySQL Replication”</a></dt><dt><a href="storage-engines.html#innodb-init" title="13.6.2.3. Creating the InnoDB Tablespace">Section 13.6.2.3, “Creating the <code class="literal">InnoDB</code> Tablespace”</a></dt><dt><a href="storage-engines.html#operating-system-error-codes" title="13.6.12.2. Operating System Error Codes">Section 13.6.12.2, “Operating System Error Codes”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt><dt><a href="storage-engines.html#multiple-tablespaces" title="13.6.2.1. Using Per-Table Tablespaces">Section 13.6.2.1, “Using Per-Table Tablespaces”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_flush_log_at_trx_commit</code></h3><dl><dt><a href="storage-engines.html#innodb-tuning" title="13.6.13.1. InnoDB Performance Tuning Tips">Section 13.6.13.1, “<code class="literal">InnoDB</code> Performance Tuning Tips”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_flush_method</code></h3><dl><dt><a href="storage-engines.html#innodb-tuning" title="13.6.13.1. InnoDB Performance Tuning Tips">Section 13.6.13.1, “<code class="literal">InnoDB</code> Performance Tuning Tips”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_flush_method = O_DIRECT</code></h3><dl><dt><a href="storage-engines.html#innodb-tuning" title="13.6.13.1. InnoDB Performance Tuning Tips">Section 13.6.13.1, “<code class="literal">InnoDB</code> Performance Tuning Tips”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_force_recovery</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="storage-engines.html#forcing-recovery" title="13.6.6.2. Forcing InnoDB Recovery">Section 13.6.6.2, “Forcing <code class="literal">InnoDB</code> Recovery”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_io_capacity</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_lock_wait_timeout</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="storage-engines.html#innodb-deadlock-detection" title="13.6.8.8. Deadlock Detection and Rollback">Section 13.6.8.8, “Deadlock Detection and Rollback”</a></dt><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="replication.html#replication-features-timeout" title="16.3.1.25. Replication Retries and Timeouts">Section 16.3.1.25, “Replication Retries and Timeouts”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_locks_unsafe_for_binlog</code></h3><dl><dt><a href="storage-engines.html#innodb-record-level-locks" title="13.6.8.4. InnoDB Record, Gap, and Next-Key Locks">Section 13.6.8.4, “<code class="literal">InnoDB</code> Record, Gap, and Next-Key Locks”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="sql-syntax.html#set-transaction" title="12.4.6. SET TRANSACTION Syntax">Section 12.4.6, “<code class="literal">SET TRANSACTION</code> Syntax”</a></dt><dt><a href="storage-engines.html#innodb-consistent-read" title="13.6.8.2. Consistent Nonlocking Reads">Section 13.6.8.2, “Consistent Nonlocking Reads”</a></dt><dt><a href="storage-engines.html#innodb-locks-set" title="13.6.8.6. Locks Set by Different SQL Statements in InnoDB">Section 13.6.8.6, “Locks Set by Different SQL Statements in <code class="literal">InnoDB</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_log_arch_dir</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_log_archive</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_log_buffer_size</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_log_file_size</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_log_files_in_group</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_log_group_home_dir</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_max_dirty_pages_pct</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_max_merged_io</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_max_purge_lag</code></h3><dl><dt><a href="storage-engines.html#innodb-multi-versioning" title="13.6.9. InnoDB Multi-Versioning">Section 13.6.9, “<code class="literal">InnoDB</code> Multi-Versioning”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_mirrored_log_groups</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_open_files</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_read_io_threads</code></h3><dl><dt><a href="storage-engines.html#innodb-general-monitor" title="13.6.13.2.1. InnoDB Standard Monitor and Lock Monitor Output">Section 13.6.13.2.1, “<code class="literal">InnoDB</code> Standard Monitor and Lock Monitor Output”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="extending-mysql.html#mysql-threads" title="22.1.1. MySQL Threads">Section 22.1.1, “MySQL Threads”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_rollback_on_timeout</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_stats_on_metadata</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_support_xa</code></h3><dl><dt><a href="storage-engines.html#innodb-tuning" title="13.6.13.1. InnoDB Performance Tuning Tips">Section 13.6.13.1, “<code class="literal">InnoDB</code> Performance Tuning Tips”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="storage-engines.html#innodb-deadlocks" title="13.6.8.9. How to Cope with Deadlocks">Section 13.6.8.9, “How to Cope with Deadlocks”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_sync_spin_loops</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_table_locks</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_thread_concurrency</code></h3><dl><dt><a href="storage-engines.html#innodb-general-monitor" title="13.6.13.2.1. InnoDB Standard Monitor and Lock Monitor Output">Section 13.6.13.2.1, “<code class="literal">InnoDB</code> Standard Monitor and Lock Monitor Output”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_thread_concurrency_timer_based</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_thread_sleep_delay</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_use_legacy_cardinality_algorithm</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">innodb_write_io_threads</code></h3><dl><dt><a href="storage-engines.html#innodb-general-monitor" title="13.6.13.2.1. InnoDB Standard Monitor and Lock Monitor Output">Section 13.6.13.2.1, “<code class="literal">InnoDB</code> Standard Monitor and Lock Monitor Output”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="extending-mysql.html#mysql-threads" title="22.1.1. MySQL Threads">Section 22.1.1, “MySQL Threads”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">insert_id</code></h3><dl><dt><a href="storage-engines.html#federated-usagenotes" title="13.11.3. FEDERATED Storage Engine Notes and Tips">Section 13.11.3, “<code class="literal">FEDERATED</code> Storage Engine Notes and Tips”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">interactive_timeout</code></h3><dl><dt><a href="connectors-apis.html#mysql-real-connect" title="21.9.3.52. mysql_real_connect()">Section 21.9.3.52, “<code class="literal">mysql_real_connect()</code>”</a></dt><dt><a href="error-handling.html#communication-errors" title="B.1.2.11. Communication Errors and Aborted Connections">Section B.1.2.11, “Communication Errors and Aborted Connections”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">join_buffer_size</code></h3><dl><dt><a href="optimization.html#nested-loop-joins" title="7.2.10. Nested-Loop Join Algorithms">Section 7.2.10, “Nested-Loop Join Algorithms”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">join_cache_level</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">keep_files_on_create</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">key_buffer_size</code></h3><dl><dt><a href="error-handling.html#open-bugs-general" title="B.1.8.2. Additional Known Issues">Section B.1.8.2, “Additional Known Issues”</a></dt><dt><a href="optimization.html#estimating-performance" title="7.2.2. Estimating Query Performance">Section 7.2.2, “Estimating Query Performance”</a></dt><dt><a href="optimization.html#memory-use" title="7.5.8. How MySQL Uses Memory">Section 7.5.8, “How MySQL Uses Memory”</a></dt><dt><a href="backup-and-recovery.html#repair" title="6.4.3. How to Repair Tables">Section 6.4.3, “How to Repair Tables”</a></dt><dt><a href="optimization.html#multiple-key-caches" title="7.4.5.2. Multiple Key Caches">Section 7.4.5.2, “Multiple Key Caches”</a></dt><dt><a href="error-handling.html#open-bugs" title="B.1.8.1. Open Issues in MySQL">Section B.1.8.1, “Open Issues in MySQL”</a></dt><dt><a href="optimization.html#key-cache-restructuring" title="7.4.5.6. Restructuring a Key Cache">Section 7.4.5.6, “Restructuring a Key Cache”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="optimization.html#delete-speed" title="7.2.23. Speed of DELETE Statements">Section 7.2.23, “Speed of <code class="literal">DELETE</code> Statements”</a></dt><dt><a href="optimization.html#insert-speed" title="7.2.21. Speed of INSERT Statements">Section 7.2.21, “Speed of <code class="literal">INSERT</code> Statements”</a></dt><dt><a href="server-administration.html#structured-system-variables" title="5.1.6.1. Structured System Variables">Section 5.1.6.1, “Structured System Variables”</a></dt><dt><a href="optimization.html#myisam-key-cache" title="7.4.5. The MyISAM Key Cache">Section 7.4.5, “The <code class="literal">MyISAM</code> Key Cache”</a></dt><dt><a href="optimization.html#server-parameters" title="7.5.3. Tuning Server Parameters">Section 7.5.3, “Tuning Server Parameters”</a></dt><dt><a href="programs.html#option-files" title="4.2.3.3. Using Option Files">Section 4.2.3.3, “Using Option Files”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">key_cache_age_threshold</code></h3><dl><dt><a href="optimization.html#midpoint-insertion" title="7.4.5.3. Midpoint Insertion Strategy">Section 7.4.5.3, “Midpoint Insertion Strategy”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#structured-system-variables" title="5.1.6.1. Structured System Variables">Section 5.1.6.1, “Structured System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">key_cache_block_size</code></h3><dl><dt><a href="optimization.html#key-cache-block-size" title="7.4.5.5. Key Cache Block Size">Section 7.4.5.5, “Key Cache Block Size”</a></dt><dt><a href="optimization.html#key-cache-restructuring" title="7.4.5.6. Restructuring a Key Cache">Section 7.4.5.6, “Restructuring a Key Cache”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#structured-system-variables" title="5.1.6.1. Structured System Variables">Section 5.1.6.1, “Structured System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">key_cache_division_limit</code></h3><dl><dt><a href="optimization.html#midpoint-insertion" title="7.4.5.3. Midpoint Insertion Strategy">Section 7.4.5.3, “Midpoint Insertion Strategy”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#structured-system-variables" title="5.1.6.1. Structured System Variables">Section 5.1.6.1, “Structured System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">language</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">large_files_support</code></h3><dl><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">large_page_size</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">large_pages</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">last_insert_id</code></h3><dl><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">lc_messages</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="internationalization-localization.html#error-message-language" title="9.3. Setting the Error Message Language">Section 9.3, “Setting the Error Message Language”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">lc_messages_dir</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="internationalization-localization.html#error-message-language" title="9.3. Setting the Error Message Language">Section 9.3, “Setting the Error Message Language”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">lc_time_names</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="internationalization-localization.html#locale-support" title="9.8. MySQL Server Locale Support">Section 9.8, “MySQL Server Locale Support”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">license</code></h3><dl><dt><a href="extending-mysql.html#plugin-api-general" title="22.2.3.1. General Plugin Structures and Functions">Section 22.2.3.1, “General Plugin Structures and Functions”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">local_infile</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">locked_in_memory</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">log</code></h3><dl><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">log_bin</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">log_bin_trust_function_creators</code></h3><dl><dt><a href="replication.html#replication-options-binary-log" title="16.1.3.4. Binary Log Options and Variables">Section 16.1.3.4, “Binary Log Options and Variables”</a></dt><dt><a href="stored-programs-views.html#stored-programs-logging" title="19.6. Binary Logging of Stored Programs">Section 19.6, “Binary Logging of Stored Programs”</a></dt><dt><a href="introduction.html#mysql-nutshell" title="1.4.1. What Is New in MySQL 5.1">Section 1.4.1, “What Is New in MySQL 5.1”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="introduction.html#mysql-next-series-plans" title="1.4.2. What Is Planned for MySQL 5.4">Section 1.4.2, “What Is Planned for MySQL 5.4”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">log_error</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">log_output</code></h3><dl><dt><a href="server-administration.html#log-tables" title="5.2.1. Selecting General Query and Slow Query Log Output Destinations">Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#query-log" title="5.2.3. The General Query Log">Section 5.2.3, “The General Query Log”</a></dt><dt><a href="server-administration.html#slow-query-log" title="5.2.5. The Slow Query Log">Section 5.2.5, “The Slow Query Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">log_queries_not_using_indexes</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">log_slave_updates</code></h3><dl><dt><a href="replication.html#replication-options-binary-log" title="16.1.3.4. Binary Log Options and Variables">Section 16.1.3.4, “Binary Log Options and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">log_slow_queries</code></h3><dl><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">log_update</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">log_warnings</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#error-log" title="5.2.2. The Error Log">Section 5.2.2, “The Error Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">long_query_time</code></h3><dl><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqladmin-description.html" target="_top">Description</a></dt><dt><a href="server-administration.html#server-logs" title="5.2. MySQL Server Logs">Section 5.2, “MySQL Server Logs”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#slow-query-log" title="5.2.5. The Slow Query Log">Section 5.2.5, “The Slow Query Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">low_priority_updates</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">lower_case_file_system</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">lower_case_table_names</code></h3><dl><dt><a href="storage-engines.html#innodb-foreign-key-constraints" title="13.6.4.4. FOREIGN KEY Constraints">Section 13.6.4.4, “<code class="literal">FOREIGN KEY</code> Constraints”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#revoke" title="12.5.1.5. REVOKE Syntax">Section 12.5.1.5, “<code class="literal">REVOKE</code> Syntax”</a></dt><dt><a href="introduction.html#bug-reports" title="1.6. How to Report Bugs or Problems">Section 1.6, “How to Report Bugs or Problems”</a></dt><dt><a href="language-structure.html#identifier-case-sensitivity" title="8.2.2. Identifier Case Sensitivity">Section 8.2.2, “Identifier Case Sensitivity”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_allowed_packet</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><dt><a href="error-handling.html#error-lost-connection" title="B.1.2.3. Lost connection to MySQL server">Section B.1.2.3, “<code class="literal">Lost connection to MySQL server</code>”</a></dt><dt><a href="error-handling.html#gone-away" title="B.1.2.9. MySQL server has gone away">Section B.1.2.9, “<code class="literal">MySQL server has gone away</code>”</a></dt><dt><a href="error-handling.html#packet-too-large" title="B.1.2.10. Packet too large">Section B.1.2.10, “<code class="literal">Packet too large</code>”</a></dt><dt><a href="connectors-apis.html#mysql-use-result" title="21.9.3.71. mysql_use_result()">Section 21.9.3.71, “<code class="literal">mysql_use_result()</code>”</a></dt><dt><a href="error-handling.html#communication-errors" title="B.1.2.11. Communication Errors and Aborted Connections">Section B.1.2.11, “Communication Errors and Aborted Connections”</a></dt><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="error-handling.html#deleting-from-related-tables" title="B.1.5.6. Deleting Rows from Related Tables">Section B.1.5.6, “Deleting Rows from Related Tables”</a></dt><dt><a href="optimization.html#memory-use" title="7.5.8. How MySQL Uses Memory">Section 7.5.8, “How MySQL Uses Memory”</a></dt><dt><a href="connectors-apis.html#c" title="21.9. MySQL C API">Section 21.9, “MySQL C API”</a></dt><dt><a href="replication.html#replication-features-max-allowed-packet" title="16.3.1.17. Replication and max_allowed_packet">Section 16.3.1.17, “Replication and <code class="literal">max_allowed_packet</code>”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt><dt><a href="data-types.html#blob" title="10.4.3. The BLOB and
TEXT Types">Section 10.4.3, “The <code class="literal">BLOB</code> and
<code class="literal">TEXT</code> Types”</a></dt><dt><a href="programs.html#option-files" title="4.2.3.3. Using Option Files">Section 4.2.3.3, “Using Option Files”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_binlog_cache_size</code></h3><dl><dt><a href="replication.html#replication-options-binary-log" title="16.1.3.4. Binary Log Options and Variables">Section 16.1.3.4, “Binary Log Options and Variables”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_binlog_size</code></h3><dl><dt><a href="replication.html#replication-options-binary-log" title="16.1.3.4. Binary Log Options and Variables">Section 16.1.3.4, “Binary Log Options and Variables”</a></dt><dt><a href="server-administration.html#server-logs" title="5.2. MySQL Server Logs">Section 5.2, “MySQL Server Logs”</a></dt><dt><a href="replication.html#slave-logs" title="16.4.2. Replication Relay and Status Files">Section 16.4.2, “Replication Relay and Status Files”</a></dt><dt><a href="server-administration.html#log-file-maintenance" title="5.2.6. Server Log Maintenance">Section 5.2.6, “Server Log Maintenance”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt><dt><a href="replication.html#slave-logs-relaylog" title="16.4.2.1. The Slave Relay Log">Section 16.4.2.1, “The Slave Relay Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_connect_errors</code></h3><dl><dt><a href="sql-syntax.html#flush" title="12.5.6.3. FLUSH Syntax">Section 12.5.6.3, “<code class="literal">FLUSH</code> Syntax”</a></dt><dt><a href="error-handling.html#blocked-host" title="B.1.2.6. Host 'host_name' is
blocked">Section B.1.2.6, “<code class="literal">Host '<em class="replaceable"><code>host_name</code></em>' is
blocked</code>”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_connections</code></h3><dl><dt><a href="error-handling.html#not-enough-file-handles" title="B.1.2.18. 'File' Not Found and
Similar Errors">Section B.1.2.18, “<span class="errortext">'<em class="replaceable"><code>File</code></em>' Not Found</span> and
Similar Errors”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="error-handling.html#too-many-connections" title="B.1.2.7. Too many connections">Section B.1.2.7, “<code class="literal">Too many connections</code>”</a></dt><dt><a href="extending-mysql.html#using-gdb-on-mysqld" title="22.5.1.4. Debugging mysqld under gdb">Section 22.5.1.4, “Debugging <span><strong class="command">mysqld</strong></span> under <span><strong class="command">gdb</strong></span>”</a></dt><dt><a href="optimization.html#table-cache" title="7.4.7. How MySQL Opens and Closes Tables">Section 7.4.7, “How MySQL Opens and Closes Tables”</a></dt><dt><a href="optimization.html#connection-threads" title="7.5.7. How MySQL Uses Threads for Client Connections">Section 7.5.7, “How MySQL Uses Threads for Client Connections”</a></dt><dt><a href="server-administration.html#user-resources" title="5.5.4. Limiting Account Resources">Section 5.5.4, “Limiting Account Resources”</a></dt><dt><a href="server-administration.html#grant-table-structure" title="5.4.2. Privilege System Grant Tables">Section 5.4.2, “Privilege System Grant Tables”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_connections+1</code></h3><dl><dt><a href="error-handling.html#too-many-connections" title="B.1.2.7. Too many connections">Section B.1.2.7, “<code class="literal">Too many connections</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_delayed_threads</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_error_count</code></h3><dl><dt><a href="sql-syntax.html#load-data" title="12.2.6. LOAD DATA INFILE
Syntax">Section 12.2.6, “<code class="literal">LOAD DATA INFILE</code>
Syntax”</a></dt><dt><a href="sql-syntax.html#show-warnings" title="12.5.5.42. SHOW WARNINGS Syntax">Section 12.5.5.42, “<code class="literal">SHOW WARNINGS</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_heap_table_size</code></h3><dl><dt><a href="error-handling.html#full-table" title="B.1.2.12. The table is full">Section B.1.2.12, “<code class="literal">The table is full</code>”</a></dt><dt><a href="optimization.html#internal-temporary-tables" title="7.5.10. How MySQL Uses Internal Temporary Tables">Section 7.5.10, “How MySQL Uses Internal Temporary Tables”</a></dt><dt><a href="restrictions.html#cursor-restrictions" title="D.2. Restrictions on Server-Side Cursors">Section D.2, “Restrictions on Server-Side Cursors”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="storage-engines.html#memory-storage-engine" title="13.9. The MEMORY (HEAP) Storage Engine">Section 13.9, “The <code class="literal">MEMORY</code> (<code class="literal">HEAP</code>) Storage Engine”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_insert_delayed_threads</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_join_size</code></h3><dl><dt><a href="programs.html#mysql-command-options" title="4.5.1.1. mysql Options">Section 4.5.1.1, “<span><strong class="command">mysql</strong></span> Options”</a></dt><dt><a href="sql-syntax.html#set-option" title="12.5.4. SET Syntax">Section 12.5.4, “<code class="literal">SET</code> Syntax”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt><dt><a href="server-administration.html#using-system-variables" title="5.1.6. Using System Variables">Section 5.1.6, “Using System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_length_for_sort_data</code></h3><dl><dt><a href="optimization.html#order-by-optimization" title="7.2.13. ORDER BY Optimization">Section 7.2.13, “<code class="literal">ORDER BY</code> Optimization”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_prepared_stmt_count</code></h3><dl><dt><a href="sql-syntax.html#sql-syntax-prepared-statements" title="12.7. SQL Syntax for Prepared Statements">Section 12.7, “SQL Syntax for Prepared Statements”</a></dt><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_relay_log_size</code></h3><dl><dt><a href="replication.html#replication-options-binary-log" title="16.1.3.4. Binary Log Options and Variables">Section 16.1.3.4, “Binary Log Options and Variables”</a></dt><dt><a href="replication.html#slave-logs" title="16.4.2. Replication Relay and Status Files">Section 16.4.2, “Replication Relay and Status Files”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="replication.html#slave-logs-relaylog" title="16.4.2.1. The Slave Relay Log">Section 16.4.2.1, “The Slave Relay Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_seeks_for_key</code></h3><dl><dt><a href="storage-engines.html#innodb-restrictions" title="13.6.14. Restrictions on InnoDB Tables">Section 13.6.14, “Restrictions on <code class="literal">InnoDB</code> Tables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_sort_length</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="error-handling.html#open-bugs-general" title="B.1.8.2. Additional Known Issues">Section B.1.8.2, “Additional Known Issues”</a></dt><dt><a href="error-handling.html#open-bugs" title="B.1.8.1. Open Issues in MySQL">Section B.1.8.1, “Open Issues in MySQL”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="data-types.html#blob" title="10.4.3. The BLOB and
TEXT Types">Section 10.4.3, “The <code class="literal">BLOB</code> and
<code class="literal">TEXT</code> Types”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_sp_recursion_depth</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="stored-programs-views.html#stored-routines-syntax" title="19.2.1. Stored Routine Syntax">Section 19.2.1, “Stored Routine Syntax”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_tmp_tables</code></h3><dl><dt><a href="optimization.html#table-cache" title="7.4.7. How MySQL Opens and Closes Tables">Section 7.4.7, “How MySQL Opens and Closes Tables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_user_connections</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#user-resources" title="5.5.4. Limiting Account Resources">Section 5.5.4, “Limiting Account Resources”</a></dt><dt><a href="server-administration.html#security-against-attack" title="5.3.2. Making MySQL Secure Against Attackers">Section 5.3.2, “Making MySQL Secure Against Attackers”</a></dt><dt><a href="server-administration.html#grant-table-structure" title="5.4.2. Privilege System Grant Tables">Section 5.4.2, “Privilege System Grant Tables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">max_write_lock_count</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="optimization.html#table-locking" title="7.3.2. Table Locking Issues">Section 7.3.2, “Table Locking Issues”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">min_examined_row_limit</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#slow-query-log" title="5.2.5. The Slow Query Log">Section 5.2.5, “The Slow Query Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">myisam_data_pointer_size</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="error-handling.html#full-table" title="B.1.2.12. The table is full">Section B.1.2.12, “<code class="literal">The table is full</code>”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">myisam_max_extra_sort_file_size</code></h3><dl><dt><a href="storage-engines.html#myisam-start" title="13.5.1. MyISAM Startup Options">Section 13.5.1, “<code class="literal">MyISAM</code> Startup Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">myisam_max_sort_file_size</code></h3><dl><dt><a href="storage-engines.html#myisam-start" title="13.5.1. MyISAM Startup Options">Section 13.5.1, “<code class="literal">MyISAM</code> Startup Options”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">myisam_recover_options</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">myisam_repair_threads</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">myisam_sort_buffer_size</code></h3><dl><dt><a href="sql-syntax.html#alter-table" title="12.1.7. ALTER TABLE Syntax">Section 12.1.7, “<code class="literal">ALTER TABLE</code> Syntax”</a></dt><dt><a href="storage-engines.html#myisam-start" title="13.5.1. MyISAM Startup Options">Section 13.5.1, “<code class="literal">MyISAM</code> Startup Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">myisam_stats_method</code></h3><dl><dt><a href="optimization.html#myisam-index-statistics" title="7.4.6. MyISAM Index Statistics Collection">Section 7.4.6, “<code class="literal">MyISAM</code> Index Statistics Collection”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">myisam_use_mmap</code></h3><dl><dt><a href="optimization.html#memory-use" title="7.5.8. How MySQL Uses Memory">Section 7.5.8, “How MySQL Uses Memory”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">named_pipe</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_autoincrement_prefetch_sz</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_cache_check_time</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_extra_logging</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_force_send</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_index_stat_cache_entries</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_index_stat_enable</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_index_stat_update_freq</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_optimized_node_selection</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-changes-5-1-ndb-6-3" title="17.1.4.4. Features Added in MySQL Cluster NDB 6.3">Section 17.1.4.4, “Features Added in MySQL Cluster NDB 6.3”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-log-statistics" title="17.5.4.3. Using CLUSTERLOG STATISTICS in the MySQL Cluster
Management Client">Section 17.5.4.3, “Using <code class="literal">CLUSTERLOG STATISTICS</code> in the MySQL Cluster
Management Client”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_report_thresh_binlog_epoch_slip</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_report_thresh_binlog_mem_usage</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_use_copying_alter_table</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_use_exact_count</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_use_transactions</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ndb_wait_connected</code></h3><dl><dt><a href="mysql-cluster.html#mysql-cluster-system-variables" title="17.3.4.3. MySQL Cluster System Variables">Section 17.3.4.3, “MySQL Cluster System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">net_buffer_length</code></h3><dl><dt><a href="programs.html#mysql-command-options" title="4.5.1.1. mysql Options">Section 4.5.1.1, “<span><strong class="command">mysql</strong></span> Options”</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump-description.html" target="_top">Description</a></dt><dt><a href="optimization.html#memory-use" title="7.5.8. How MySQL Uses Memory">Section 7.5.8, “How MySQL Uses Memory”</a></dt><dt><a href="connectors-apis.html#c" title="21.9. MySQL C API">Section 21.9, “MySQL C API”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">net_read_timeout</code></h3><dl><dt><a href="sql-syntax.html#load-data-from-master" title="12.6.2.2. LOAD DATA FROM MASTER Syntax">Section 12.6.2.2, “<code class="literal">LOAD DATA FROM MASTER</code> Syntax”</a></dt><dt><a href="error-handling.html#error-lost-connection" title="B.1.2.3. Lost connection to MySQL server">Section B.1.2.3, “<code class="literal">Lost connection to MySQL server</code>”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">net_retry_count</code></h3><dl><dt><a href="connectors-apis.html#mysql-options" title="21.9.3.49. mysql_options()">Section 21.9.3.49, “<code class="literal">mysql_options()</code>”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">net_write_timeout</code></h3><dl><dt><a href="sql-syntax.html#load-data-from-master" title="12.6.2.2. LOAD DATA FROM MASTER Syntax">Section 12.6.2.2, “<code class="literal">LOAD DATA FROM MASTER</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">new</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">old</code></h3><dl><dt><a href="sql-syntax.html#index-hints" title="12.2.8.2. Index Hint Syntax">Section 12.2.8.2, “Index Hint Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">old_alter_table</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">old_passwords</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">one_shot</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">open_files_limit</code></h3><dl><dt><a href="error-handling.html#not-enough-file-handles" title="B.1.2.18. 'File' Not Found and
Similar Errors">Section B.1.2.18, “<span class="errortext">'<em class="replaceable"><code>File</code></em>' Not Found</span> and
Similar Errors”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">optimizer_prune_level</code></h3><dl><dt><a href="optimization.html#controlling-optimizer" title="7.5.4. Controlling Query Optimizer Performance">Section 7.5.4, “Controlling Query Optimizer Performance”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">optimizer_search_depth</code></h3><dl><dt><a href="optimization.html#controlling-optimizer" title="7.5.4. Controlling Query Optimizer Performance">Section 7.5.4, “Controlling Query Optimizer Performance”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">optimizer_switch</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="optimization.html#switchable-optimizations" title="7.2.18. Using optimizer_switch to Control the
Optimizer">Section 7.2.18, “Using <code class="literal">optimizer_switch</code> to Control the
Optimizer”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">optimizer_use_mrr</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">pid_file</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">plugin_dir</code></h3><dl><dt><a href="sql-syntax.html#create-function-udf" title="12.5.3.1. CREATE FUNCTION Syntax">Section 12.5.3.1, “<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#install-plugin" title="12.5.3.3. INSTALL PLUGIN Syntax">Section 12.5.3.3, “<code class="literal">INSTALL PLUGIN</code> Syntax”</a></dt><dt><a href="extending-mysql.html#plugin-api-characteristics" title="22.2.1. Characteristics of the Plugin Interface">Section 22.2.1, “Characteristics of the Plugin Interface”</a></dt><dt><a href="extending-mysql.html#udf-compiling" title="22.3.2.5. Compiling and Installing User-Defined Functions">Section 22.3.2.5, “Compiling and Installing User-Defined Functions”</a></dt><dt><a href="extending-mysql.html#plugin-creating" title="22.2.3.3. Creating a Plugin Library">Section 22.2.3.3, “Creating a Plugin Library”</a></dt><dt><a href="storage-engines.html#pluggable-storage" title="13.4.1. Pluggable Storage Engine Architecture">Section 13.4.1, “Pluggable Storage Engine Architecture”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt><dt><a href="extending-mysql.html#udf-security" title="22.3.2.6. User-Defined Function Security Precautions">Section 22.3.2.6, “User-Defined Function Security Precautions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">port</code></h3><dl><dt><a href="error-handling.html#can-not-connect-to-server" title="B.1.2.2. Can't connect to [local] MySQL server">Section B.1.2.2, “<code class="literal">Can't connect to [local] MySQL server</code>”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">preload_buffer_size</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">prepared_stmt_count</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">profiling</code></h3><dl><dt><a href="sql-syntax.html#show-profiles" title="12.5.5.33. SHOW PROFILES Syntax">Section 12.5.5.33, “<code class="literal">SHOW PROFILES</code> Syntax”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt><dt><a href="information-schema.html#profiling-table" title="20.26. The INFORMATION_SCHEMA PROFILING Table">Section 20.26, “The <code class="literal">INFORMATION_SCHEMA PROFILING</code> Table”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">profiling_history_size</code></h3><dl><dt><a href="sql-syntax.html#show-profiles" title="12.5.5.33. SHOW PROFILES Syntax">Section 12.5.5.33, “<code class="literal">SHOW PROFILES</code> Syntax”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">protocol_version</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">pseudo_thread_id</code></h3><dl><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">query_alloc_block_size</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">query_cache_limit</code></h3><dl><dt><a href="optimization.html#query-cache-configuration" title="7.5.5.3. Query Cache Configuration">Section 7.5.5.3, “Query Cache Configuration”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">query_cache_min_res_unit</code></h3><dl><dt><a href="optimization.html#query-cache-configuration" title="7.5.5.3. Query Cache Configuration">Section 7.5.5.3, “Query Cache Configuration”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">query_cache_size</code></h3><dl><dt><a href="optimization.html#query-cache-configuration" title="7.5.5.3. Query Cache Configuration">Section 7.5.5.3, “Query Cache Configuration”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="optimization.html#query-cache" title="7.5.5. The MySQL Query Cache">Section 7.5.5, “The MySQL Query Cache”</a></dt><dt><a href="server-administration.html#using-system-variables" title="5.1.6. Using System Variables">Section 5.1.6, “Using System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">query_cache_type</code></h3><dl><dt><a href="sql-syntax.html#select" title="12.2.8. SELECT Syntax">Section 12.2.8, “<code class="literal">SELECT</code> Syntax”</a></dt><dt><a href="optimization.html#query-cache-in-select" title="7.5.5.2. Query Cache SELECT Options">Section 7.5.5.2, “Query Cache <code class="literal">SELECT</code> Options”</a></dt><dt><a href="optimization.html#query-cache-configuration" title="7.5.5.3. Query Cache Configuration">Section 7.5.5.3, “Query Cache Configuration”</a></dt><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">query_cache_wlock_invalidate</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">query_prealloc_size</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">rand_seed1</code></h3><dl><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">rand_seed2</code></h3><dl><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">range_alloc_block_size</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">read_buffer_size</code></h3><dl><dt><a href="optimization.html#memory-use" title="7.5.8. How MySQL Uses Memory">Section 7.5.8, “How MySQL Uses Memory”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="optimization.html#server-parameters" title="7.5.3. Tuning Server Parameters">Section 7.5.3, “Tuning Server Parameters”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">read_only</code></h3><dl><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="server-administration.html#log-tables" title="5.2.1. Selecting General Query and Slow Query Log Output Destinations">Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">read_rnd_buffer_size</code></h3><dl><dt><a href="optimization.html#order-by-optimization" title="7.2.13. ORDER BY Optimization">Section 7.2.13, “<code class="literal">ORDER BY</code> Optimization”</a></dt><dt><a href="optimization.html#memory-use" title="7.5.8. How MySQL Uses Memory">Section 7.5.8, “How MySQL Uses Memory”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="optimization.html#server-parameters" title="7.5.3. Tuning Server Parameters">Section 7.5.3, “Tuning Server Parameters”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">relay_log_purge</code></h3><dl><dt><a href="sql-syntax.html#change-master-to" title="12.6.2.1. CHANGE MASTER TO Syntax">Section 12.6.2.1, “<code class="literal">CHANGE MASTER TO</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">relay_log_recovery</code></h3><dl><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">relay_log_space_limit</code></h3><dl><dt><a href="optimization.html#slave-io-thread-states" title="7.5.6.5. Replication Slave I/O Thread States">Section 7.5.6.5, “Replication Slave I/O Thread States”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">report_host</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">report_password</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">report_port</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">report_user</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">rpl_recovery_rank</code></h3><dl><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">rpl_semi_sync_master_enabled</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">rpl_semi_sync_master_reply_log_file_pos</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">rpl_semi_sync_master_timeout</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">rpl_semi_sync_master_trace_level</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">rpl_semi_sync_slave_enabled</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">rpl_semi_sync_slave_trace_level</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">safe_show_database</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">secure_auth</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">secure_file_priv</code></h3><dl><dt><a href="sql-syntax.html#load-data" title="12.2.6. LOAD DATA INFILE
Syntax">Section 12.2.6, “<code class="literal">LOAD DATA INFILE</code>
Syntax”</a></dt><dt><a href="sql-syntax.html#select" title="12.2.8. SELECT Syntax">Section 12.2.8, “<code class="literal">SELECT</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">server_id</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">shared_memory</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">shared_memory_base_name</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">skip_external_locking</code></h3><dl><dt><a href="optimization.html#external-locking" title="7.3.4. External Locking">Section 7.3.4, “External Locking”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">skip_networking</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">skip_show_database</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">slave_compressed_protocol</code></h3><dl><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">slave_exec_mode</code></h3><dl><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">slave_load_tmpdir</code></h3><dl><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">slave_net_timeout</code></h3><dl><dt><a href="sql-syntax.html#change-master-to" title="12.6.2.1. CHANGE MASTER TO Syntax">Section 12.6.2.1, “<code class="literal">CHANGE MASTER TO</code> Syntax”</a></dt><dt><a href="replication.html#replication-features-mastershutdown" title="16.3.1.16. Replication During a Master Shutdown">Section 16.3.1.16, “Replication During a Master Shutdown”</a></dt><dt><a href="replication.html#replication-faq" title="16.3.4. Replication FAQ">Section 16.3.4, “Replication FAQ”</a></dt><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="optimization.html#slave-io-thread-states" title="7.5.6.5. Replication Slave I/O Thread States">Section 7.5.6.5, “Replication Slave I/O Thread States”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">slave_skip_errors</code></h3><dl><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">slave_transaction_retries</code></h3><dl><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="replication.html#replication-features-timeout" title="16.3.1.25. Replication Retries and Timeouts">Section 16.3.1.25, “Replication Retries and Timeouts”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">slow_launch_time</code></h3><dl><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">slow_query_log</code></h3><dl><dt><a href="server-administration.html#log-tables" title="5.2.1. Selecting General Query and Slow Query Log Output Destinations">Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#slow-query-log" title="5.2.5. The Slow Query Log">Section 5.2.5, “The Slow Query Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">slow_query_log_file</code></h3><dl><dt><a href="server-administration.html#log-tables" title="5.2.1. Selecting General Query and Slow Query Log Output Destinations">Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#slow-query-log" title="5.2.5. The Slow Query Log">Section 5.2.5, “The Slow Query Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">socket</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sort_buffer_size</code></h3><dl><dt><a href="optimization.html#order-by-optimization" title="7.2.13. ORDER BY Optimization">Section 7.2.13, “<code class="literal">ORDER BY</code> Optimization”</a></dt><dt><a href="backup-and-recovery.html#repair" title="6.4.3. How to Repair Tables">Section 6.4.3, “How to Repair Tables”</a></dt><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="optimization.html#server-parameters" title="7.5.3. Tuning Server Parameters">Section 7.5.3, “Tuning Server Parameters”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_auto_is_null</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_auto_is_null = 0</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_big_selects</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_buffer_result</code></h3><dl><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_log_bin</code></h3><dl><dt><a href="sql-syntax.html#set-sql-log-bin" title="12.6.1.3. SET sql_log_bin Syntax">Section 12.6.1.3, “<code class="literal">SET sql_log_bin</code> Syntax”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-limitations-exclusive-to-cluster" title="17.1.5.8. Issues Exclusive to MySQL Cluster">Section 17.1.5.8, “Issues Exclusive to MySQL Cluster”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-limitations-syntax" title="17.1.5.1. Noncompliance with SQL Syntax in MySQL Cluster">Section 17.1.5.1, “Noncompliance with SQL Syntax in MySQL Cluster”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_log_off</code></h3><dl><dt><a href="server-administration.html#log-tables" title="5.2.1. Selecting General Query and Slow Query Log Output Destinations">Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”</a></dt><dt><a href="server-administration.html#log-file-maintenance" title="5.2.6. Server Log Maintenance">Section 5.2.6, “Server Log Maintenance”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt><dt><a href="server-administration.html#query-log" title="5.2.3. The General Query Log">Section 5.2.3, “The General Query Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_log_update</code></h3><dl><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_mode</code></h3><dl><dt><a href="sql-syntax.html#create-event" title="12.1.11. CREATE EVENT Syntax">Section 12.1.11, “<code class="literal">CREATE EVENT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-procedure" title="12.1.15. CREATE PROCEDURE and
CREATE FUNCTION Syntax">Section 12.1.15, “<code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-trigger" title="12.1.19. CREATE TRIGGER Syntax">Section 12.1.19, “<code class="literal">CREATE TRIGGER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-view" title="12.5.5.14. SHOW CREATE VIEW Syntax">Section 12.5.5.14, “<code class="literal">SHOW CREATE VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-triggers" title="12.5.5.40. SHOW TRIGGERS Syntax">Section 12.5.5.40, “<code class="literal">SHOW TRIGGERS</code> Syntax”</a></dt><dt><a href="data-types.html#timestamp" title="10.3.1.1. TIMESTAMP Properties">Section 10.3.1.1, “<code class="literal">TIMESTAMP</code> Properties”</a></dt><dt><a href="introduction.html#bug-reports" title="1.6. How to Report Bugs or Problems">Section 1.6, “How to Report Bugs or Problems”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="error-handling.html#using-date" title="B.1.5.2. Problems Using DATE Columns">Section B.1.5.2, “Problems Using <code class="literal">DATE</code> Columns”</a></dt><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="introduction.html#ansi-mode" title="1.7.3. Running MySQL in ANSI Mode">Section 1.7.3, “Running MySQL in ANSI Mode”</a></dt><dt><a href="introduction.html#sql-mode" title="1.7.2. Selecting SQL Modes">Section 1.7.2, “Selecting SQL Modes”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="information-schema.html#routines-table" title="20.14. The INFORMATION_SCHEMA ROUTINES Table">Section 20.14, “The <code class="literal">INFORMATION_SCHEMA ROUTINES</code> Table”</a></dt><dt><a href="information-schema.html#triggers-table" title="20.16. The INFORMATION_SCHEMA TRIGGERS Table">Section 20.16, “The <code class="literal">INFORMATION_SCHEMA TRIGGERS</code> Table”</a></dt><dt><a href="information-schema.html#views-table" title="20.15. The INFORMATION_SCHEMA VIEWS Table">Section 20.15, “The <code class="literal">INFORMATION_SCHEMA VIEWS</code> Table”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt><dt><a href="server-administration.html#using-system-variables" title="5.1.6. Using System Variables">Section 5.1.6, “Using System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_notes</code></h3><dl><dt><a href="sql-syntax.html#show-warnings" title="12.5.5.42. SHOW WARNINGS Syntax">Section 12.5.5.42, “<code class="literal">SHOW WARNINGS</code> Syntax”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_quote_show_create</code></h3><dl><dt><a href="sql-syntax.html#show-create-database" title="12.5.5.8. SHOW CREATE DATABASE Syntax">Section 12.5.5.8, “<code class="literal">SHOW CREATE DATABASE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-table" title="12.5.5.12. SHOW CREATE TABLE Syntax">Section 12.5.5.12, “<code class="literal">SHOW CREATE TABLE</code> Syntax”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_safe_updates</code></h3><dl><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_select_limit</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_slave_skip_counter</code></h3><dl><dt><a href="sql-syntax.html#show-slave-status" title="12.5.5.36. SHOW SLAVE STATUS Syntax">Section 12.5.5.36, “<code class="literal">SHOW SLAVE STATUS</code> Syntax”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sql_warnings</code></h3><dl><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ssl_ca</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ssl_capath</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ssl_cert</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ssl_cipher</code></h3><dl><dt><a href="server-administration.html#adding-users" title="5.5.2. Adding User Accounts">Section 5.5.2, “Adding User Accounts”</a></dt><dt><a href="server-administration.html#grant-table-structure" title="5.4.2. Privilege System Grant Tables">Section 5.4.2, “Privilege System Grant Tables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ssl_key</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">storage_engine</code></h3><dl><dt><a href="introduction.html#mysql-nutshell" title="1.4.1. What Is New in MySQL 5.1">Section 1.4.1, “What Is New in MySQL 5.1”</a></dt><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="storage-engines.html#storage-engine-setting" title="13.3. Setting the Storage Engine">Section 13.3, “Setting the Storage Engine”</a></dt><dt><a href="storage-engines.html" title="Chapter 13. Storage Engines">Chapter 13, <i>Storage Engines</i></a></dt><dt><a href="introduction.html#mysql-next-series-plans" title="1.4.2. What Is Planned for MySQL 5.4">Section 1.4.2, “What Is Planned for MySQL 5.4”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sync_binlog</code></h3><dl><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="replication.html#replication-options-binary-log" title="16.1.3.4. Binary Log Options and Variables">Section 16.1.3.4, “Binary Log Options and Variables”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sync_frm</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sync_master_info</code></h3><dl><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sync_relay_log</code></h3><dl><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">sync_relay_log_info</code></h3><dl><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">system_time_zone</code></h3><dl><dt><a href="internationalization-localization.html#time-zone-support" title="9.7. MySQL Server Time Zone Support">Section 9.7, “MySQL Server Time Zone Support”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">table_cache</code></h3><dl><dt><a href="error-handling.html#not-enough-file-handles" title="B.1.2.18. 'File' Not Found and
Similar Errors">Section B.1.2.18, “<span class="errortext">'<em class="replaceable"><code>File</code></em>' Not Found</span> and
Similar Errors”</a></dt><dt><a href="optimization.html#table-cache" title="7.4.7. How MySQL Opens and Closes Tables">Section 7.4.7, “How MySQL Opens and Closes Tables”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="optimization.html#server-parameters" title="7.5.3. Tuning Server Parameters">Section 7.5.3, “Tuning Server Parameters”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">table_definition_cache</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">table_lock_wait_timeout</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">table_open_cache</code></h3><dl><dt><a href="error-handling.html#not-enough-file-handles" title="B.1.2.18. 'File' Not Found and
Similar Errors">Section B.1.2.18, “<span class="errortext">'<em class="replaceable"><code>File</code></em>' Not Found</span> and
Similar Errors”</a></dt><dt><a href="optimization.html#table-cache" title="7.4.7. How MySQL Opens and Closes Tables">Section 7.4.7, “How MySQL Opens and Closes Tables”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="optimization.html#server-parameters" title="7.5.3. Tuning Server Parameters">Section 7.5.3, “Tuning Server Parameters”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">table_type</code></h3><dl><dt><a href="introduction.html#mysql-nutshell" title="1.4.1. What Is New in MySQL 5.1">Section 1.4.1, “What Is New in MySQL 5.1”</a></dt><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="storage-engines.html" title="Chapter 13. Storage Engines">Chapter 13, <i>Storage Engines</i></a></dt><dt><a href="introduction.html#mysql-next-series-plans" title="1.4.2. What Is Planned for MySQL 5.4">Section 1.4.2, “What Is Planned for MySQL 5.4”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">thread_cache_size</code></h3><dl><dt><a href="extending-mysql.html#using-gdb-on-mysqld" title="22.5.1.4. Debugging mysqld under gdb">Section 22.5.1.4, “Debugging <span><strong class="command">mysqld</strong></span> under <span><strong class="command">gdb</strong></span>”</a></dt><dt><a href="optimization.html#connection-threads" title="7.5.7. How MySQL Uses Threads for Client Connections">Section 7.5.7, “How MySQL Uses Threads for Client Connections”</a></dt><dt><a href="optimization.html#miscellaneous-optimization-tips" title="7.2.24. Other Optimization Tips">Section 7.2.24, “Other Optimization Tips”</a></dt><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">thread_concurrency</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">thread_handling</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">thread_stack</code></h3><dl><dt><a href="optimization.html#memory-use" title="7.5.8. How MySQL Uses Memory">Section 7.5.8, “How MySQL Uses Memory”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="stored-programs-views.html#stored-routines-syntax" title="19.2.1. Stored Routine Syntax">Section 19.2.1, “Stored Routine Syntax”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">time_format</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">time_zone</code></h3><dl><dt><a href="sql-syntax.html#show-events" title="12.5.5.19. SHOW EVENTS Syntax">Section 12.5.5.19, “<code class="literal">SHOW EVENTS</code> Syntax”</a></dt><dt><a href="data-types.html#timestamp" title="10.3.1.1. TIMESTAMP Properties">Section 10.3.1.1, “<code class="literal">TIMESTAMP</code> Properties”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="internationalization-localization.html#time-zone-support" title="9.7. MySQL Server Time Zone Support">Section 9.7, “MySQL Server Time Zone Support”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="information-schema.html#events-table" title="20.20. The INFORMATION_SCHEMA EVENTS Table">Section 20.20, “The <code class="literal">INFORMATION_SCHEMA EVENTS</code> Table”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">timed_mutexes</code></h3><dl><dt><a href="sql-syntax.html#show-engine" title="12.5.5.16. SHOW ENGINE Syntax">Section 12.5.5.16, “<code class="literal">SHOW ENGINE</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">timestamp</code></h3><dl><dt><a href="storage-engines.html#federated-usagenotes" title="13.11.3. FEDERATED Storage Engine Notes and Tips">Section 13.11.3, “<code class="literal">FEDERATED</code> Storage Engine Notes and Tips”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">timestamp = {timestamp_value | DEFAULT}</code></h3><dl><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">timezone</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">tmp_table_size</code></h3><dl><dt><a href="error-handling.html#full-table" title="B.1.2.12. The table is full">Section B.1.2.12, “<code class="literal">The table is full</code>”</a></dt><dt><a href="optimization.html#general-thread-states" title="7.5.6.2. General Thread States">Section 7.5.6.2, “General Thread States”</a></dt><dt><a href="optimization.html#internal-temporary-tables" title="7.5.10. How MySQL Uses Internal Temporary Tables">Section 7.5.10, “How MySQL Uses Internal Temporary Tables”</a></dt><dt><a href="optimization.html#memory-use" title="7.5.8. How MySQL Uses Memory">Section 7.5.8, “How MySQL Uses Memory”</a></dt><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="storage-engines.html#memory-storage-engine" title="13.9. The MEMORY (HEAP) Storage Engine">Section 13.9, “The <code class="literal">MEMORY</code> (<code class="literal">HEAP</code>) Storage Engine”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">transaction_alloc_block_size</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">transaction_prealloc_size</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">tx_isolation</code></h3><dl><dt><a href="sql-syntax.html#set-transaction" title="12.4.6. SET TRANSACTION Syntax">Section 12.4.6, “<code class="literal">SET TRANSACTION</code> Syntax”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">unique_checks</code></h3><dl><dt><a href="storage-engines.html#converting-tables-to-innodb" title="13.6.4.2. Converting Tables from Other Storage Engines to
InnoDB">Section 13.6.4.2, “Converting Tables from Other Storage Engines to
<code class="literal">InnoDB</code>”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">updatable_views_with_limit</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="stored-programs-views.html#view-updatability" title="19.5.3. Updatable and Insertable Views">Section 19.5.3, “Updatable and Insertable Views”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">version_bdb</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">version_comment</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">version_compile_machine</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">version_compile_os</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">wait_timeout</code></h3><dl><dt><a href="error-handling.html#gone-away" title="B.1.2.9. MySQL server has gone away">Section B.1.2.9, “<code class="literal">MySQL server has gone away</code>”</a></dt><dt><a href="connectors-apis.html#mysql-real-connect" title="21.9.3.52. mysql_real_connect()">Section 21.9.3.52, “<code class="literal">mysql_real_connect()</code>”</a></dt><dt><a href="error-handling.html#communication-errors" title="B.1.2.11. Communication Errors and Aborted Connections">Section B.1.2.11, “Communication Errors and Aborted Connections”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">warning_count</code></h3><dl><dt><a href="sql-syntax.html#show-warnings" title="12.5.5.42. SHOW WARNINGS Syntax">Section 12.5.5.42, “<code class="literal">SHOW WARNINGS</code> Syntax”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="dynindex-statement.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> </td></tr><tr><td width="40%" align="left" valign="top">Statement/Syntax Index </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> </td></tr></table></div></body></html>
