System Variable Index
Prev   

System Variable Index

auto_increment_increment

Section A.1, “MySQL 5.1 FAQ — General”
Section 3.6.9, “Using AUTO_INCREMENT”

auto_increment_offset

Section A.1, “MySQL 5.1 FAQ — General”
Section 3.6.9, “Using AUTO_INCREMENT”

automatic_sp_privileges

Section 19.2.2, “Stored Routines and MySQL Privileges”

binlog_format

Section 16.3.4, “Replication FAQ”
Section 16.3.1.17, “Replication of the System mysql Database”

bulk_insert_buffer_size

Section 13.5.1, “MyISAM Startup Options”

character_set_client

Section 21.10.5, “C API Prepared Statement Data types”
Section 9.1.4, “Connection Character Sets and Collations”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”
Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”
Section 20.16, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”

character_set_connection

Section 9.1.8.2, “CONVERT() and CAST()”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 9.1.4, “Connection Character Sets and Collations”
Section 11.6, “Date and Time Functions”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 9.8, “MySQL Server Locale Support”
Section 9.1.8.1, “Result Strings”
Section 9.1.7, “String Repertoire”
Section 8.1.1, “Strings”

character_set_database

Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”

character_set_filesystem

Section 11.4, “String Functions”

character_set_results

Section 9.1.4, “Connection Character Sets and Collations”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 9.1.10, “UTF-8 for Metadata”

character_set_server

Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”
Section 11.11.4, “Miscellaneous Functions”
Section 16.3.1.2, “Replication and Character Sets”
Section 9.1.3.1, “Server Character Set and Collation”

character_set_system

Section 9.1.10, “UTF-8 for Metadata”

character_sets_dir

Section 9.5.3, “Adding a Simple Collation to an 8-Bit Character Set”
Section 9.5.4, “Adding a UCA Collation to a Unicode Character Set”

collation_connection

Section 9.1.8.2, “CONVERT() and CAST()”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 9.1.4, “Connection Character Sets and Collations”
Section 11.6, “Date and Time Functions”
Section 9.1.8.1, “Result Strings”
Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”
Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”
Section 20.16, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”

collation_database

Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”

collation_server

Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”
Section 16.3.1.2, “Replication and Character Sets”
Section 9.1.3.1, “Server Character Set and Collation”

completion_type

Section 21.10.3.6, “mysql_commit()”
Section 21.10.3.57, “mysql_rollback()”

connect_timeout

Section 21.10.3.52, “mysql_real_connect()”

default_week_format

Section 11.6, “Date and Time Functions”

div_precision_increment

Section 11.5.1, “Arithmetic Operators”

event_scheduler

Section 21.9.2, “Restrictions When Using the Embedded MySQL Server”

expire_logs_days

Section 12.6.1.1, “PURGE BINARY LOGS Syntax”

foreign_key_checks

Section 16.3.1.28, “Replication and Variables”

ft_boolean_syntax

Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”

ft_max_word_len

Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 22.2.2, “Full-Text Parser Plugins”

ft_min_word_len

Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 22.2.2, “Full-Text Parser Plugins”

ft_stopword_file

Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”

group_concat_max_len

Section 11.12.1, “GROUP BY (Aggregate) Functions”

have_ndbcluster

Section 17.4.3, “MySQL Cluster System Variables”

have_openssl

Section 5.5.7.2, “Using SSL Connections”

have_partitioning

Chapter 18, Partitioning

have_ssl

Section 5.5.7.2, “Using SSL Connections”

init_connect

Section 9.1.5, “Configuring the Character Set and Collation for Applications”

innodb_file_io_threads

Section 22.1.1, “MySQL Threads”

innodb_file_per_table

Section 18.5, “Restrictions and Limitations on Partitioning”

innodb_lock_wait_timeout

Section 16.3.1.23, “Replication Retries and Timeouts”

insert_id

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”

interactive_timeout

Section 21.10.3.52, “mysql_real_connect()”

key_buffer_size

Section 6.4.3, “How to Repair Tables”
Section 4.2.3.3, “Using Option Files”

large_files_support

Section 18.5, “Restrictions and Limitations on Partitioning”

lc_time_names

Section 11.6, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”

license

Section 22.2.3.1, “General Plugin Structures and Functions”

log_bin_trust_function_creators

Section 19.6, “Binary Logging of Stored Programs”
Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”

long_query_time

Description

lower_case_table_names

Section 1.6, “How to Report Bugs or Problems”
Section 8.2.2, “Identifier Case Sensitivity”

max_allowed_packet

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 21.10.3.71, “mysql_use_result()”
Section 11.2.3, “Comparison Functions and Operators”
Section 21.10, “MySQL C API”
Section 11.4, “String Functions”
Section 10.4.3, “The BLOB and TEXT Types”
Section 4.2.3.3, “Using Option Files”

max_binlog_size

Section 16.4.2.1, “The Slave Relay Log”

max_connections

Section 22.5.1.4, “Debugging mysqld under gdb”
Section 5.5.4, “Limiting Account Resources”

max_heap_table_size

Section D.2, “Restrictions on Server-Side Cursors”
Section 13.9, “The MEMORY (HEAP) Storage Engine”

max_join_size

Section 4.5.1.1, “mysql Options”

max_prepared_stmt_count

Section 12.7, “SQL Syntax for Prepared Statements”

max_relay_log_size

Section 16.4.2.1, “The Slave Relay Log”

max_sort_length

Section 10.4.3, “The BLOB and TEXT Types”

max_sp_recursion_depth

Section 19.2.1, “Stored Routine Syntax”

max_user_connections

Section 5.5.4, “Limiting Account Resources”
Section 5.3.2, “Making MySQL Secure Against Attackers”

myisam_max_sort_file_size

Section 13.5.1, “MyISAM Startup Options”
Section 18.5, “Restrictions and Limitations on Partitioning”

myisam_sort_buffer_size

Section 13.5.1, “MyISAM Startup Options”

ndb_autoincrement_prefetch_sz

Section 17.4.3, “MySQL Cluster System Variables”

ndb_cache_check_time

Section 17.4.3, “MySQL Cluster System Variables”

ndb_extra_logging

Section 17.4.3, “MySQL Cluster System Variables”

ndb_force_send

Section 17.4.3, “MySQL Cluster System Variables”

ndb_index_stat_cache_entries

Section 17.4.3, “MySQL Cluster System Variables”

ndb_index_stat_enable

Section 17.4.3, “MySQL Cluster System Variables”

ndb_index_stat_update_freq

Section 17.4.3, “MySQL Cluster System Variables”

ndb_optimized_node_selection

Section 17.4.3, “MySQL Cluster System Variables”
Section 17.7.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”

ndb_report_thresh_binlog_epoch_slip

Section 17.4.3, “MySQL Cluster System Variables”

ndb_report_thresh_binlog_mem_usage

Section 17.4.3, “MySQL Cluster System Variables”

ndb_use_copying_alter_table

Section 17.4.3, “MySQL Cluster System Variables”

ndb_use_exact_count

Section 17.4.3, “MySQL Cluster System Variables”

ndb_use_transactions

Section 17.4.3, “MySQL Cluster System Variables”

ndb_wait_connected

Section 17.4.3, “MySQL Cluster System Variables”

net_buffer_length

Section 4.5.1.1, “mysql Options”
Description
Section 21.10, “MySQL C API”

net_read_timeout

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

net_retry_count

Section 21.10.3.49, “mysql_options()”

net_write_timeout

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

open_files_limit

Section 18.5, “Restrictions and Limitations on Partitioning”

plugin_dir

Section 22.2.1, “Characteristics of the Plugin Interface”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 22.2.3.3, “Creating a Plugin Library”
Section 13.4.1, “Pluggable Storage Engine Architecture”
Section 22.3.2.6, “User-Defined Function Security Precautions”

profiling

Section 20.26, “The INFORMATION_SCHEMA PROFILING Table”

relay_log_purge

Section 12.6.2.1, “CHANGE MASTER TO Syntax”

secure_file_priv

Section 11.4, “String Functions”

server_id

Section 11.11.4, “Miscellaneous Functions”

slave_net_timeout

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 16.3.1.15, “Replication During a Master Shutdown”

slave_transaction_retries

Section 16.3.1.23, “Replication Retries and Timeouts”

sort_buffer_size

Section 6.4.3, “How to Repair Tables”

sql_auto_is_null

Section 16.3.1.28, “Replication and Variables”

sql_auto_is_null = 0

Section 11.2.3, “Comparison Functions and Operators”

sql_log_bin

Section 12.6.1.3, “SET sql_log_bin Syntax”

sql_mode

Section 10.3.1.1, “TIMESTAMP Properties”
Section 1.6, “How to Report Bugs or Problems”
Section 16.3.1.28, “Replication and Variables”
Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”
Section 20.16, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”

ssl_cipher

Section 5.5.2, “Adding User Accounts”

storage_engine

Section 16.3.1.28, “Replication and Variables”
Section 13.3, “Setting the Storage Engine”

system_time_zone

Section 9.7, “MySQL Server Time Zone Support”

thread_cache_size

Section 22.5.1.4, “Debugging mysqld under gdb”

thread_stack

Section 19.2.1, “Stored Routine Syntax”

time_zone

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”
Section 9.7, “MySQL Server Time Zone Support”
Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”

timestamp

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”

tmp_table_size

Section 13.9, “The MEMORY (HEAP) Storage Engine”

unique_checks

Section 16.3.1.28, “Replication and Variables”

updatable_views_with_limit

Section 19.5.3, “Updatable and Insertable Views”

wait_timeout

Section 21.10.3.52, “mysql_real_connect()”
Prev   
Statement/Syntax Index Home