System Variable Index

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W

A

[index top]

autocommit

Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.4.32, “Changes in MySQL/InnoDB-3.23.52, August 16, 2002”
Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.26, “Changes in MySQL/InnoDB-4.0.6, December 19, 2002”
Section C.4.10, “Changes in MySQL/InnoDB-4.1.1, December 4, 2003”
Section C.3.44, “Changes in Release 3.23.17 (07 June 2000)”
Section C.3.40, “Changes in Release 3.23.21 (04 July 2000)”
Section C.3.5, “Changes in Release 3.23.55 (23 January 2003)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section 13.2.9.8, “Deadlock Detection and Rollback”
Section 12.2.1, “DELETE Syntax”
Section 13.2.9.9, “How to Cope with Deadlocks”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 12.3.5.1, “Interaction of Table Locking and Transactions”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 13.2.15, “Restrictions on InnoDB Tables”
Section 13.2.9.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”
Section 5.1.3, “Server System Variables”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 1.9.5.4, “Transactions and Atomic Operations”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

B

[index top]

back_log

Section 5.1.3, “Server System Variables”

basedir

Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 5.1.3, “Server System Variables”

bdb_cache_size

Section 5.1.3, “Server System Variables”

bdb_home

Section 5.1.3, “Server System Variables”

bdb_lock_max

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”

bdb_log_buffer_size

Section 5.1.3, “Server System Variables”

bdb_logdir

Section 5.1.3, “Server System Variables”

bdb_max_lock

Section 13.5.3, “BDB Startup Options”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section 5.1.3, “Server System Variables”

bdb_shared_data

Section 5.1.3, “Server System Variables”

bdb_tmpdir

Section 5.1.3, “Server System Variables”

bdb_version

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.3.30, “Changes in Release 3.23.31 (17 January 2001: Production)”
Section 5.1.3, “Server System Variables”

big_tables

Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
Section 5.1.3, “Server System Variables”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

binlog_cache_size

Section 13.5.3, “BDB Startup Options”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 5.3.4, “The Binary Log”

bulk_insert_buffer_size

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 13.1.1, “MyISAM Startup Options”
Section 5.1.3, “Server System Variables”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

C

[index top]

character_set

Section 5.1.3, “Server System Variables”

character_set_client

Section 17.6.8.1, “C API Prepared Statement Type Codes”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section 9.6, “Character Set Configuration”
Section 9.1.4, “Connection Character Sets and Collations”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 5.1.3, “Server System Variables”
Section 12.4.4, “SET Syntax”

character_set_connection

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 9.1.7.4, “Collations Must Be for the Right Character Set”
Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.8.2, “CONVERT() and CAST()”
Section 11.7, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”
Section 9.1.8.1, “Result Strings”
Section 5.1.3, “Server System Variables”
Section 12.4.4, “SET Syntax”
Section 8.1.1, “String Literals”

character_set_database

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 5.1.3, “Server System Variables”
Section 12.4.4, “SET Syntax”

character_set_results

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 9.1.6, “Character Set for Error Messages”
Section 9.1.4, “Connection Character Sets and Collations”
Section 5.1.3, “Server System Variables”
Section 12.4.4, “SET Syntax”
Section 9.1.10, “UTF-8 for Metadata”

character_set_server

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 9.6, “Character Set Configuration”
Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”
Section 11.14, “Miscellaneous Functions”
Section 14.7.2, “Replication and Character Sets”
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server System Variables”

character_set_system

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 9.6, “Character Set Configuration”
Section 5.1.3, “Server System Variables”
Section 9.1.10, “UTF-8 for Metadata”

character_sets

Section 5.1.3, “Server System Variables”

character_sets_dir

Section 9.5.3, “Adding a Simple Collation to an 8-Bit Character Set”
Section 5.1.3, “Server System Variables”

collation_connection

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 9.1.7.4, “Collations Must Be for the Right Character Set”
Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.8.2, “CONVERT() and CAST()”
Section 11.7, “Date and Time Functions”
Section 9.1.8.1, “Result Strings”
Section 5.1.3, “Server System Variables”
Section 12.4.4, “SET Syntax”

collation_database

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”
Section 5.1.3, “Server System Variables”

collation_server

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”
Section 14.7.2, “Replication and Character Sets”
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server System Variables”

concurrent_insert

Section 7.6.3, “Concurrent Inserts”
Section 5.1.3, “Server System Variables”

connect_timeout

Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section B.5.2.3, “Lost connection to MySQL server”
Section 17.6.6.50, “mysql_real_connect()”
Section 5.1.3, “Server System Variables”
Section 4.2.3.3, “Using Option Files”

convert_character_set

Section 5.1.3, “Server System Variables”

D

[index top]

datadir

Section 5.1.3, “Server System Variables”

date_format

Section 5.1.3, “Server System Variables”

datetime_format

Section 5.1.3, “Server System Variables”

default_week_format

Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 11.7, “Date and Time Functions”
Section 5.1.3, “Server System Variables”

delay_key_write

Section C.3.45, “Changes in Release 3.23.16 (16 May 2000)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 12.1.5, “CREATE TABLE Syntax”
Section 5.1.3, “Server System Variables”

delayed_insert_limit

Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 5.1.3, “Server System Variables”

delayed_insert_timeout

Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 5.1.3, “Server System Variables”

delayed_queue_size

Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 5.1.3, “Server System Variables”

E

[index top]

error_count

Section 5.1.3, “Server System Variables”
Section 12.4.5.11, “SHOW ERRORS Syntax”
Section B.1, “Sources of Error Information”

expire_logs_days

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 12.5.1.1, “PURGE BINARY LOGS Syntax”
Section 5.3.6, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”

F

[index top]

flush

Section 5.1.3, “Server System Variables”

flush_time

Section 5.1.3, “Server System Variables”

foreign_key_checks

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 14.7.20, “Replication and Variables”
Section 5.1.3, “Server System Variables”

ft_boolean_syntax

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.3, “Server System Variables”

ft_max_word_len

Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.3, “Server System Variables”

ft_min_word_len

Section 11.9.2, “Boolean Full-Text Searches”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.3, “Server System Variables”

ft_query_expansion_limit

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 5.1.3, “Server System Variables”

ft_stopword_file

Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.3, “Server System Variables”

G

[index top]

group_concat_max_len

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.21, “Changes in MySQL 4.1.5 (2004-09-16)”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 5.1.3, “Server System Variables”

H

[index top]

have_archive

Section 5.1.3, “Server System Variables”

have_bdb

Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section 5.1.3, “Server System Variables”

have_blackhole_engine

Section 5.1.3, “Server System Variables”

have_compress

Section 5.1.3, “Server System Variables”

have_crypt

Section 5.1.3, “Server System Variables”

have_csv

Section 5.1.3, “Server System Variables”

have_example_engine

Section 5.1.3, “Server System Variables”

have_geometry

Section 5.1.3, “Server System Variables”

have_innodb

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section B.5.5.5, “Rollback Failure for Nontransactional Tables”
Section 5.1.3, “Server System Variables”

have_isam

Section 5.1.3, “Server System Variables”

have_merge_engine

Section 5.1.3, “Server System Variables”

have_ndbcluster

Section 15.3.4.3, “MySQL Cluster System Variables”

have_openssl

Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section 5.1.3, “Server System Variables”
Section 5.6.6.2, “Using SSL Connections”

have_query_cache

Section 7.5.3.3, “Query Cache Configuration”
Section 5.1.3, “Server System Variables”

have_raid

Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section 5.1.3, “Server System Variables”

have_rtree_keys

Section 5.1.3, “Server System Variables”

have_symlink

Section 5.1.3, “Server System Variables”

I

[index top]

identity

Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section 1.5, “MySQL 4.0 in a Nutshell”
Section 5.1.3, “Server System Variables”

init_connect

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”

init_file

Section 5.1.3, “Server System Variables”

init_slave

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 14.8.3, “Replication Slave Options and Variables”

innodb_additional_mem_pool_size

Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.4, “Changes in MySQL/InnoDB-4.1.2, May 30, 2004”
Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_autoextend_increment

Section 13.2.6, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section C.1.21, “Changes in MySQL 4.1.5 (2004-09-16)”
Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section 13.2.3, “InnoDB Configuration”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_buffer_pool_awe_mem_mb

Section C.4.17, “Changes in MySQL/InnoDB-4.1.0, April 3, 2003”
Section 13.2.3, “InnoDB Configuration”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_buffer_pool_size

Section 13.2.13.1, “InnoDB Error Codes”
Section 13.2.14.1, “InnoDB Performance Tuning Tips”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 7.5.2, “The InnoDB Buffer Pool”

innodb_data_file_path

Section 13.2.6, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section 13.2.3.4, “Dealing with InnoDB Initialization Problems”
Section 13.2.3, “InnoDB Configuration”
Section 13.2.2, “InnoDB in MySQL 3.23”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Chapter 13, Storage Engines
Section 5.2, “The mysqld-max Extended MySQL Server”
Section 13.2.3.2, “Using Raw Devices for the Shared Tablespace”

innodb_data_home_dir

Section 13.2.3.4, “Dealing with InnoDB Initialization Problems”
Section 13.2.3, “InnoDB Configuration”
Section 13.2.2, “InnoDB in MySQL 3.23”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_fast_shutdown

Section C.3.16, “Changes in Release 3.23.44 (31 October 2001)”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_file_io_threads

Section 13.2.14.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 18.1.1, “MySQL Threads”

innodb_file_per_table

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.4.4, “Changes in MySQL/InnoDB-4.1.2, May 30, 2004”
Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”
Section 13.2.3.3, “Creating the InnoDB Tablespace”
Section 13.2.5.5, “InnoDB and MySQL Replication”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 13.2.14.2.2, “InnoDB Tablespace Monitor Output”
Section 13.2.13.2, “Operating System Error Codes”
Section 13.2.14.4, “Troubleshooting InnoDB Data Dictionary Operations”
Section 13.2.3.1, “Using Per-Table Tablespaces”

innodb_flush_log_at_trx_commit

Section C.4.15, “Changes in MySQL/InnoDB-3.23.57, June 20, 2003”
Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”
Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 13.2.14.1, “InnoDB Performance Tuning Tips”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_flush_method

Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section C.3.20, “Changes in Release 3.23.40 (18 July 2001)”
Section 13.2.14.1, “InnoDB Performance Tuning Tips”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_force_recovery

Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.4.29, “Changes in MySQL/InnoDB-3.23.53, October 9, 2002”
Section C.4.30, “Changes in MySQL/InnoDB-4.0.4, October 2, 2002”
Section C.4.28, “Changes in MySQL/InnoDB-4.0.5, November 18, 2002”
Section C.3.16, “Changes in Release 3.23.44 (31 October 2001)”
Section 13.2.7.2, “Forcing InnoDB Recovery”
Section 1.8, “How to Report Bugs or Problems”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_lock_wait_timeout

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section 13.2.9.8, “Deadlock Detection and Rollback”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 14.7.17, “Replication Retries and Timeouts”
Section 14.8.3, “Replication Slave Options and Variables”

innodb_locks_unsafe_for_binlog

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.1, “Changes in MySQL 4.1.25 (2008-12-01)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”
Section 13.2.9.4, “InnoDB Record, Gap, and Next-Key Locks”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_log_arch_dir

Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_log_archive

Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_log_buffer_size

Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_log_file_size

Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_log_files_in_group

Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_log_group_home_dir

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_max_dirty_pages_pct

Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”
Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_max_purge_lag

Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 13.2.10, “InnoDB Multi-Versioning”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_mirrored_log_groups

Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_open_files

Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_table_locks

Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 13.2.4, “InnoDB Startup Options and System Variables”

innodb_thread_concurrency

Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.4.4, “Changes in MySQL/InnoDB-4.1.2, May 30, 2004”
Section C.3.16, “Changes in Release 3.23.44 (31 October 2001)”
Section 13.2.14.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 13.2.4, “InnoDB Startup Options and System Variables”

insert_id

Section 5.1.3, “Server System Variables”

interactive_timeout

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 2.12.4.1, “FreeBSD Notes”
Section 2.12.2.1, “Mac OS X 10.x (Darwin)”
Section 17.6.6.50, “mysql_real_connect()”
Section 5.1.3, “Server System Variables”

J

[index top]

join_buffer_size

Section 7.3.1.6, “Nested-Loop Join Algorithms”
Section 5.1.3, “Server System Variables”

K

[index top]

key_buffer_size

Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 7.2.3, “Estimating Query Performance”
Section 7.8.4, “How MySQL Uses Memory”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 7.5.1.2, “Multiple Key Caches”
Section B.5.8.4, “Open Issues in MySQL”
Section 7.5.1.6, “Restructuring a Key Cache”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 7.3.2.3, “Speed of DELETE Statements”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 7.3.2.4, “Speed of REPAIR TABLE Statements”
Section 5.1.4.1, “Structured System Variables”
Section 7.5.1, “The MyISAM Key Cache”
Section 7.8.2, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”

key_cache_age_threshold

Section 7.5.1.3, “Midpoint Insertion Strategy”
Section 5.1.3, “Server System Variables”
Section 5.1.4.1, “Structured System Variables”

key_cache_block_size

Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section 7.5.1.5, “Key Cache Block Size”
Section 7.5.1.6, “Restructuring a Key Cache”
Section 5.1.3, “Server System Variables”
Section 5.1.4.1, “Structured System Variables”

key_cache_division_limit

Section 7.5.1.3, “Midpoint Insertion Strategy”
Section 5.1.3, “Server System Variables”
Section 5.1.4.1, “Structured System Variables”

L

[index top]

language

Section 5.1.3, “Server System Variables”

large_files_support

Section 5.1.3, “Server System Variables”

last_insert_id

Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section 5.1.3, “Server System Variables”

lc_time_names

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 11.7, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

license

Section 5.1.3, “Server System Variables”

local_infile

Section 5.1.3, “Server System Variables”

locked_in_memory

Section 5.1.3, “Server System Variables”

log

Section 5.1.3, “Server System Variables”

log_bin

Section 14.8.4, “Binary Log Options and Variables”

log_error

Section 5.1.3, “Server System Variables”

log_slave_updates

Section 14.8.4, “Binary Log Options and Variables”

log_slow_queries

Section 5.1.3, “Server System Variables”

log_update

Section 5.1.3, “Server System Variables”

log_warnings

Section 5.1.3, “Server System Variables”
Section 5.3.1, “The Error Log”

long_query_time

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section 5.3, “MySQL Server Logs”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 5.3.5, “The Slow Query Log”

low_priority_updates

Section 5.1.3, “Server System Variables”
Section 7.6.2, “Table Locking Issues”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

lower_case_file_system

Section 5.1.3, “Server System Variables”

lower_case_table_names

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 12.4.1.2, “GRANT Syntax”
Section 14.9, “How Servers Evaluate Replication Filtering Rules”
Section 1.8, “How to Report Bugs or Problems”
Section 8.2.2, “Identifier Case Sensitivity”
Section 14.7.20, “Replication and Variables”
Section 12.4.1.3, “REVOKE Syntax”
Section 5.1.3, “Server System Variables”

M

[index top]

max_allowed_packet

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section C.2.24, “Changes in Release 4.0.8 (07 January 2003)”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 11.3.2, “Comparison Functions and Operators”
Section B.5.5.6, “Deleting Rows from Related Tables”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 7.8.4, “How MySQL Uses Memory”
Section B.5.2.3, “Lost connection to MySQL server”
Section 17.6, “MySQL C API”
Section B.5.2.9, “MySQL server has gone away”
Section 17.6.6.69, “mysql_use_result()”
Section B.5.2.10, “Packet Too Large”
Section 5.1.3, “Server System Variables”
Section 11.5, “String Functions”
Section 10.4.3, “The BLOB and TEXT Types”
Section 4.2.3.3, “Using Option Files”

max_binlog_cache_size

Section 13.5.3, “BDB Startup Options”
Section 14.8.4, “Binary Log Options and Variables”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section 5.3.4, “The Binary Log”

max_binlog_size

Section 14.8.4, “Binary Log Options and Variables”
Section C.3.28, “Changes in Release 3.23.33 (09 February 2001)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 5.3, “MySQL Server Logs”
Section 5.3.6, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 5.3.4, “The Binary Log”
Section 14.3.2, “The Slave Relay Log”

max_connect_errors

Section 12.4.6.2, “FLUSH Syntax”
Section B.5.2.6, “Host 'host_name' is blocked”
Section 5.1.3, “Server System Variables”

max_connections

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 18.4.1.3, “Debugging mysqld under gdb”
Section 7.7.2, “How MySQL Opens and Closes Tables”
Section 7.8.3, “How MySQL Uses Threads for Client Connections”
Section 2.12.1.4, “Linux Postinstallation Notes”
Section 5.5.1, “Privileges Provided by MySQL”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section B.5.2.7, “Too many connections”

max_delayed_threads

Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 5.1.3, “Server System Variables”

max_error_count

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 5.1.3, “Server System Variables”
Section 12.4.5.26, “SHOW WARNINGS Syntax”

max_heap_table_size

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 7.7.4, “How MySQL Uses Internal Temporary Tables”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section B.5.2.12, “The table is full”

max_insert_delayed_threads

Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 5.1.3, “Server System Variables”

max_join_size

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.3.50, “Changes in Release 3.23.11 (16 February 2000)”
Section 7.2.2, “EXPLAIN Output Format”
Section 5.1.3, “Server System Variables”
Section 12.4.4, “SET Syntax”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”
Section 5.1.4, “Using System Variables”

max_length_for_sort_data

Section 7.3.1.7, “ORDER BY Optimization”
Section 5.1.3, “Server System Variables”

max_prepared_stmt_count

Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 12.6, “SQL Syntax for Prepared Statements”

max_relay_log_size

Section 14.8.4, “Binary Log Options and Variables”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”
Section 14.3.2, “The Slave Relay Log”

max_seeks_for_key

Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 13.2.15, “Restrictions on InnoDB Tables”
Section 5.1.3, “Server System Variables”

max_sort_length

Section C.1.21, “Changes in MySQL 4.1.5 (2004-09-16)”
Section 12.1.5, “CREATE TABLE Syntax”
Section B.5.8.4, “Open Issues in MySQL”
Section 5.1.3, “Server System Variables”
Section 10.4.3, “The BLOB and TEXT Types”

max_tmp_tables

Section 7.7.2, “How MySQL Opens and Closes Tables”
Section 5.1.3, “Server System Variables”

max_user_connections

Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 5.4.3, “Making MySQL Secure Against Attackers”
Section 5.1.3, “Server System Variables”
Section 5.6.4, “Setting Account Resource Limits”

max_write_lock_count

Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 5.1.3, “Server System Variables”
Section 7.6.2, “Table Locking Issues”

myisam_data_pointer_size

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 12.1.5, “CREATE TABLE Syntax”
Section 5.1.3, “Server System Variables”
Section B.5.2.12, “The table is full”

myisam_max_extra_sort_file_size

Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 13.1.1, “MyISAM Startup Options”
Section 5.1.3, “Server System Variables”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

myisam_max_sort_file_size

Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 13.1.1, “MyISAM Startup Options”
Section 5.1.3, “Server System Variables”
Section 7.3.2.4, “Speed of REPAIR TABLE Statements”

myisam_recover_options

Section 5.1.3, “Server System Variables”

myisam_repair_threads

Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.6, “Changes in Release 4.0.26 (08 September 2005)”
Section 5.1.3, “Server System Variables”

myisam_sort_buffer_size

Section 12.1.2, “ALTER TABLE Syntax”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section 13.1.1, “MyISAM Startup Options”
Section 5.1.3, “Server System Variables”
Section 7.3.2.4, “Speed of REPAIR TABLE Statements”

myisam_stats_method

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 7.4.4, “MyISAM Index Statistics Collection”
Section 5.1.3, “Server System Variables”

N

[index top]

named_pipe

Section 5.1.3, “Server System Variables”

ndb_autoincrement_prefetch_sz

Section 15.3.4.3, “MySQL Cluster System Variables”

ndb_cache_check_time

Section 15.3.4.3, “MySQL Cluster System Variables”

ndb_force_send

Section 15.3.4.3, “MySQL Cluster System Variables”

ndb_index_stat_cache_entries

Section 15.3.4.3, “MySQL Cluster System Variables”

ndb_index_stat_enable

Section 15.3.4.3, “MySQL Cluster System Variables”

ndb_index_stat_update_freq

Section 15.3.4.3, “MySQL Cluster System Variables”

ndb_optimized_node_selection

Section 15.3.4.3, “MySQL Cluster System Variables”
Section 15.5.5.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”

ndb_report_thresh_binlog_epoch_slip

Section 15.3.4.3, “MySQL Cluster System Variables”

ndb_report_thresh_binlog_mem_usage

Section 15.3.4.3, “MySQL Cluster System Variables”

ndb_use_exact_count

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section 15.3.4.3, “MySQL Cluster System Variables”

ndb_use_transactions

Section 15.3.4.3, “MySQL Cluster System Variables”

net_buffer_length

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 7.8.4, “How MySQL Uses Memory”
Section 17.6, “MySQL C API”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.3, “Server System Variables”

net_read_timeout

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.3.42, “Changes in Release 3.23.19”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 2.12.4.1, “FreeBSD Notes”
Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section B.5.2.3, “Lost connection to MySQL server”
Section 2.12.2.1, “Mac OS X 10.x (Darwin)”
Section 5.1.3, “Server System Variables”

net_retry_count

Section 17.6.6.47, “mysql_options()”
Section 5.1.3, “Server System Variables”

net_write_timeout

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.3.42, “Changes in Release 3.23.19”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section 5.1.3, “Server System Variables”

new

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section 5.1.3, “Server System Variables”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”

O

[index top]

old_passwords

Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section 5.1.3, “Server System Variables”

one_shot

Section 5.1.3, “Server System Variables”

open_files_limit

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 5.1.3, “Server System Variables”

P

[index top]

pid_file

Section 5.1.3, “Server System Variables”

plugin_dir

Section C.1.1, “Changes in MySQL 4.1.25 (2008-12-01)”
Section 18.2.2.5, “Compiling and Installing User-Defined Functions”
Section 12.4.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 2.9.1, “Installing MySQL from a Standard Source Distribution”
Section 5.4.3, “Making MySQL Secure Against Attackers”
Section 5.1.3, “Server System Variables”
Section 2.10.2, “Unix Postinstallation Procedures”

port

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 5.1.3, “Server System Variables”

preload_buffer_size

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 5.1.3, “Server System Variables”

prepared_stmt_count

Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 5.1.3, “Server System Variables”

protocol_version

Section 5.1.3, “Server System Variables”

pseudo_thread_id

Section 5.1.3, “Server System Variables”

Q

[index top]

query_alloc_block_size

Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section 5.1.3, “Server System Variables”

query_cache_limit

Section 7.5.3.3, “Query Cache Configuration”
Section 5.1.3, “Server System Variables”

query_cache_min_res_unit

Section 7.5.3.3, “Query Cache Configuration”
Section 5.1.3, “Server System Variables”

query_cache_size

Section 7.5.3.3, “Query Cache Configuration”
Section 5.1.3, “Server System Variables”
Section 7.5.3, “The MySQL Query Cache”
Section 5.1.4, “Using System Variables”

query_cache_type

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 7.5.3.3, “Query Cache Configuration”
Section 7.5.3.2, “Query Cache SELECT Options”
Section 12.2.7, “SELECT Syntax”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

query_cache_wlock_invalidate

Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section 5.1.3, “Server System Variables”

query_prealloc_size

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section 5.1.3, “Server System Variables”

R

[index top]

rand_seed

Section 5.1.3, “Server System Variables”

range_alloc_block_size

Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 5.1.3, “Server System Variables”

read_buffer_size

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 7.8.4, “How MySQL Uses Memory”
Section 5.1.3, “Server System Variables”
Section 7.3.2.4, “Speed of REPAIR TABLE Statements”
Section 7.8.2, “Tuning Server Parameters”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

read_only

Section 5.5.1, “Privileges Provided by MySQL”
Section 5.1.3, “Server System Variables”

read_rnd_buffer_size

Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 7.8.4, “How MySQL Uses Memory”
Section 7.3.1.7, “ORDER BY Optimization”
Section 5.1.3, “Server System Variables”
Section 7.8.2, “Tuning Server Parameters”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

relay_log_purge

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 5.1.3, “Server System Variables”

relay_log_space_limit

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 7.11.5, “Replication Slave I/O Thread States”
Section 5.1.3, “Server System Variables”

rpl_recovery_rank

Section 14.8.3, “Replication Slave Options and Variables”

S

[index top]

safe_show_database

Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 5.1.3, “Server System Variables”

secure_auth

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 5.1.3, “Server System Variables”

server_id

Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.1.3, “Server System Variables”

shared_memory

Section 5.1.3, “Server System Variables”

shared_memory_base_name

Section 5.1.3, “Server System Variables”

skip_external_locking

Section 7.6.4, “External Locking”
Section 5.1.3, “Server System Variables”

skip_networking

Section 5.1.3, “Server System Variables”

skip_show_database

Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

slave_compressed_protocol

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 14.8.3, “Replication Slave Options and Variables”

slave_load_tmpdir

Section 14.8.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

slave_net_timeout

Section C.3.20, “Changes in Release 3.23.40 (18 July 2001)”
Section 14.7.10, “Replication and Master or Slave Shutdowns”
Section 14.10, “Replication FAQ”
Section 7.11.5, “Replication Slave I/O Thread States”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

slave_skip_errors

Section 14.8.3, “Replication Slave Options and Variables”

slave_transaction_retries

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section 14.7.17, “Replication Retries and Timeouts”
Section 14.8.3, “Replication Slave Options and Variables”

slow_launch_time

Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

socket

Section 5.1.3, “Server System Variables”

sort_buffer_size

Section 6.6.3, “How to Repair MyISAM Tables”
Section 7.3.1.7, “ORDER BY Optimization”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 7.8.2, “Tuning Server Parameters”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

sql_auto_is_null

Section 11.3.2, “Comparison Functions and Operators”
Section 14.7.20, “Replication and Variables”
Section 5.1.3, “Server System Variables”

sql_big_selects

Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 5.1.3, “Server System Variables”

sql_buffer_result

Section 5.1.3, “Server System Variables”

sql_log_bin

Section C.3.45, “Changes in Release 3.23.16 (16 May 2000)”
Section 15.1.4.8, “Issues Exclusive to MySQL Cluster”
Section 5.1.3, “Server System Variables”
Section 12.5.1.3, “SET sql_log_bin Syntax”

sql_log_off

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 5.1.3, “Server System Variables”
Section 5.3.2, “The General Query Log”

sql_log_update

Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section 5.1.3, “Server System Variables”

sql_mode

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.21, “Changes in MySQL 4.1.5 (2004-09-16)”
Section 1.8, “How to Report Bugs or Problems”
Section 14.7.3, “Replication and DIRECTORY Table Options”
Section 14.7.20, “Replication and Variables”
Section 1.9.3, “Running MySQL in ANSI Mode”
Section 1.9.2, “Selecting SQL Modes”
Section 5.1.6, “Server SQL Modes”
Section 5.1.3, “Server System Variables”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 5.1.4, “Using System Variables”

sql_notes

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section 5.1.3, “Server System Variables”
Section 12.4.5.26, “SHOW WARNINGS Syntax”

sql_quote_show_create

Section 5.1.3, “Server System Variables”
Section 12.4.5.6, “SHOW CREATE DATABASE Syntax”
Section 12.4.5.7, “SHOW CREATE TABLE Syntax”

sql_safe_updates

Section C.3.50, “Changes in Release 3.23.11 (16 February 2000)”
Section 5.1.3, “Server System Variables”

sql_select_limit

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 5.1.3, “Server System Variables”

sql_slave_skip_counter

Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”

sql_warnings

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 5.1.3, “Server System Variables”

storage_engine

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 14.7.20, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Chapter 13, Storage Engines

sync_binlog

Section 14.8.4, “Binary Log Options and Variables”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 14.7.10, “Replication and Master or Slave Shutdowns”
Section 5.3.4, “The Binary Log”

sync_frm

Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section 5.1.3, “Server System Variables”

system_time_zone

Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section 9.7, “MySQL Server Time Zone Support”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

T

[index top]

table_cache

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 7.11.2, “General Thread States”
Section 7.7.2, “How MySQL Opens and Closes Tables”
Section 7.8.4, “How MySQL Uses Memory”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 7.8.2, “Tuning Server Parameters”

table_type

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 14.7.20, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Chapter 13, Storage Engines

thread_cache_size

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section 18.4.1.3, “Debugging mysqld under gdb”
Section 7.8.3, “How MySQL Uses Threads for Client Connections”
Section 7.3.3, “Other Optimization Tips”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

thread_concurrency

Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 5.1.3, “Server System Variables”

thread_stack

Section 7.8.4, “How MySQL Uses Memory”
Section 5.1.3, “Server System Variables”

time_format

Section 5.1.3, “Server System Variables”

time_zone

Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section 11.7, “Date and Time Functions”
Section 9.7, “MySQL Server Time Zone Support”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”

timestamp

Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 5.1.3, “Server System Variables”

timezone

Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

tmp_table_size

Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 7.7.4, “How MySQL Uses Internal Temporary Tables”
Section 7.8.4, “How MySQL Uses Memory”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section B.5.2.12, “The table is full”

tmpdir

Section B.5.2.13, “Can't create/write to file”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.8, “Changes in MySQL 4.1.18 (2006-01-27)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 6.2, “Database Backup Methods”
Section 7.3.1.7, “ORDER BY Optimization”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

transaction_alloc_block_size

Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 5.1.3, “Server System Variables”

transaction_prealloc_size

Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 5.1.3, “Server System Variables”

tx_isolation

Section 5.1.3, “Server System Variables”
Section 12.3.6, “SET TRANSACTION Syntax”

U

[index top]

unique_checks

Section 13.2.5.2, “Converting Tables from Other Storage Engines to InnoDB”
Section 14.7.20, “Replication and Variables”
Section 5.1.3, “Server System Variables”

V

[index top]

version

Section 5.1.3, “Server System Variables”

version_bdb

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 5.1.3, “Server System Variables”

version_comment

Section 5.1.3, “Server System Variables”

version_compile_machine

Section 5.1.3, “Server System Variables”

version_compile_os

Section 5.1.3, “Server System Variables”

W

[index top]

wait_timeout

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 2.12.4.1, “FreeBSD Notes”
Section 2.12.2.1, “Mac OS X 10.x (Darwin)”
Section B.5.2.9, “MySQL server has gone away”
Section 17.6.6.50, “mysql_real_connect()”
Section 5.1.3, “Server System Variables”

warning_count

Section 5.1.3, “Server System Variables”
Section 12.4.5.26, “SHOW WARNINGS Syntax”
Section B.1, “Sources of Error Information”