Skip navigation links
MySQL 5.0 Reference Manual :: System Variable Index
Status Variable Index »
Section Navigation      [Toggle]

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]

auto_increment_increment

Section 17.1.5.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”
Section 16.1.2.2, “Replication Master Options and Variables”
Section 3.6.9, “Using AUTO_INCREMENT”

auto_increment_offset

Section 17.1.5.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”
Section 16.1.2.2, “Replication Master Options and Variables”
Section 3.6.9, “Using AUTO_INCREMENT”

autocommit

Section 13.2.2, “DELETE Syntax”
Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 14.2.7.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 14.2.7.8, “Deadlock Detection and Rollback”
Section 13.3.5.1, “Interaction of Table Locking and Transactions”
Section 14.2.13, “Limits on InnoDB Tables”
Section 14.2.7.6, “Locks Set by Different SQL Statements in InnoDB”
Section 16.4.1.25, “Replication and Transactions”
Section 5.1.4, “Server System Variables”
Section 1.8.5.3, “Transactions and Atomic Operations”

automatic_sp_privileges

Section 13.1.3, “ALTER PROCEDURE Syntax”
Section 13.1.9, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 5.1.4, “Server System Variables”
Section 18.2.2, “Stored Routines and MySQL Privileges”

B

[index top]

back_log

Section 5.1.4, “Server System Variables”

basedir

Section 5.1.4, “Server System Variables”

bdb_cache_size

Section 5.1.4, “Server System Variables”

bdb_home

Section 5.1.4, “Server System Variables”

bdb_log_buffer_size

Section 5.1.4, “Server System Variables”

bdb_logdir

Section 5.1.4, “Server System Variables”

bdb_max_lock

Section 14.5.3, “BDB Startup Options”
Section 5.1.4, “Server System Variables”

bdb_shared_data

Section 5.1.4, “Server System Variables”

bdb_tmpdir

Section 5.1.4, “Server System Variables”

big_tables

Section 5.1.4, “Server System Variables”

binlog_cache_size

Section 14.5.3, “BDB Startup Options”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”

bulk_insert_buffer_size

Section 14.1.1, “MyISAM Startup Options”
Section 5.1.4, “Server System Variables”
Section 8.3.2.1, “Speed of INSERT Statements”

C

[index top]

character_set_client

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.7.4, “SET Syntax”
Section 20.6.9.1, “C API Prepared Statement Type Codes”
Section 10.5, “Character Set Configuration”
Section 10.1.4, “Connection Character Sets and Collations”
Section 16.4.1.28, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”

character_set_connection

Section 10.1.9.2, “CONVERT() and CAST()”
Section 13.7.4, “SET Syntax”
Section 10.1.3.5, “Character String Literal Character Set and Collation”
Section 10.1.4, “Connection Character Sets and Collations”
Section 12.7, “Date and Time Functions”
Section 10.7, “MySQL Server Locale Support”
Section 10.1.9.1, “Result Strings”
Section 5.1.4, “Server System Variables”
Section 9.1.1, “String Literals”
Section 10.1.8, “String Repertoire”

character_set_database

Section 13.1.9, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.7.4, “SET Syntax”
Section 10.1.4, “Connection Character Sets and Collations”
Section 10.1.3.2, “Database Character Set and Collation”
Section 5.1.4, “Server System Variables”

character_set_filesystem

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.2.8.1, “SELECT ... INTO Syntax”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 12.5, “String Functions”

character_set_results

Section 13.7.4, “SET Syntax”
Section 10.1.6, “Character Set for Error Messages”
Section 10.1.4, “Connection Character Sets and Collations”
Section 5.1.4, “Server System Variables”
Section 10.1.11, “UTF-8 for Metadata”

character_set_server

Section 10.5, “Character Set Configuration”
Section 10.1.4, “Connection Character Sets and Collations”
Section 10.1.3.2, “Database Character Set and Collation”
Section 16.4.1.2, “Replication and Character Sets”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.4, “Server System Variables”

character_set_system

Section 10.5, “Character Set Configuration”
Section 5.1.4, “Server System Variables”
Section 10.1.11, “UTF-8 for Metadata”

character_sets_dir

Section 10.4.3, “Adding a Simple Collation to an 8-Bit Character Set”
Section 10.4.4.1, “Defining a UCA Collation Using LDML Syntax”
Section 5.1.4, “Server System Variables”

collation_connection

Section 10.1.9.2, “CONVERT() and CAST()”
Section 13.7.4, “SET Syntax”
Section 10.1.3.5, “Character String Literal Character Set and Collation”
Section 10.1.4, “Connection Character Sets and Collations”
Section 12.7, “Date and Time Functions”
Section 16.4.1.28, “Replication and Variables”
Section 10.1.9.1, “Result Strings”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”

collation_database

Section 13.1.9, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 10.1.4, “Connection Character Sets and Collations”
Section 10.1.3.2, “Database Character Set and Collation”
Section 16.4.1.28, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”

collation_server

Section 10.1.4, “Connection Character Sets and Collations”
Section 10.1.3.2, “Database Character Set and Collation”
Section 16.4.1.2, “Replication and Character Sets”
Section 16.4.1.28, “Replication and Variables”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”

completion_type

Section 20.6.7.6, “mysql_commit()”
Section 20.6.7.57, “mysql_rollback()”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 5.1.4, “Server System Variables”

concurrent_insert

Section 8.7.3, “Concurrent Inserts”
Section 8.7.1, “Internal Locking Methods”
Section 8.3.3, “Other Optimization Tips”
Section 5.1.4, “Server System Variables”

connect_timeout

Section C.5.2.3, “Lost connection to MySQL server”
Section 20.6.7.52, “mysql_real_connect()”
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.4, “Server System Variables”

D

[index top]

datadir

Section 2.10, “Installing MySQL on Microsoft Windows”
Section 5.1.4, “Server System Variables”

date_format

Section 5.1.4, “Server System Variables”

datetime_format

Section 5.1.4, “Server System Variables”

default_week_format

Section 12.7, “Date and Time Functions”
Section 5.1.4, “Server System Variables”

delay_key_write

Section 13.1.10, “CREATE TABLE Syntax”
Section 5.1.4, “Server System Variables”

delayed_insert_limit

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.4, “Server System Variables”

delayed_insert_timeout

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.4, “Server System Variables”

delayed_queue_size

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.4, “Server System Variables”

div_precision_increment

Section 12.6.1, “Arithmetic Operators”
Section 5.1.4, “Server System Variables”

E

[index top]

engine_condition_pushdown

Section 8.3.1.5, “Engine Condition Pushdown Optimization”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

error_count

Section 13.7.5.14, “SHOW ERRORS Syntax”
Section 5.1.4, “Server System Variables”
Section C.1, “Sources of Error Information”

expire_logs_days

Section 13.4.1.1, “PURGE BINARY LOGS Syntax”
Section 5.2.5, “Server Log Maintenance”
Section 5.1.4, “Server System Variables”

F

[index top]

flush

Section 5.1.4, “Server System Variables”

flush_time

Section 5.1.4, “Server System Variables”

foreign_key_checks

Section 16.4.1.28, “Replication and Variables”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”
Section 13.1.10.2, “Using FOREIGN KEY Constraints”

ft_boolean_syntax

Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.4, “Server System Variables”

ft_max_word_len

Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.4, “Server System Variables”

ft_min_word_len

Section 12.9.2, “Boolean Full-Text Searches”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.4, “Server System Variables”

ft_query_expansion_limit

Section 5.1.4, “Server System Variables”

ft_stopword_file

Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.4, “Server System Variables”

G

[index top]

group_concat_max_len

Section 12.15.1, “GROUP BY (Aggregate) Functions”
Section 5.1.4, “Server System Variables”

H

[index top]

have_archive

Section 5.1.4, “Server System Variables”

have_bdb

Section 5.1.4, “Server System Variables”

have_blackhole_engine

Section 5.1.4, “Server System Variables”

have_community_features

Section 5.1.4, “Server System Variables”

have_compress

Section 5.1.4, “Server System Variables”

have_crypt

Section 5.1.4, “Server System Variables”

have_csv

Section 5.1.4, “Server System Variables”

have_example_engine

Section 5.1.4, “Server System Variables”

have_federated_engine

Section 5.1.4, “Server System Variables”

have_geometry

Section 5.1.4, “Server System Variables”

have_innodb

Section C.5.5.5, “Rollback Failure for Nontransactional Tables”
Section 5.1.4, “Server System Variables”

have_isam

Section 5.1.4, “Server System Variables”

have_merge_engine

Section 5.1.4, “Server System Variables”

have_ndbcluster

Section 17.3.4.3, “MySQL Cluster System Variables”

have_openssl

Section 6.3.6.2, “Configuring MySQL for SSL”
Section 5.1.4, “Server System Variables”

have_profiling

Section 5.1.4, “Server System Variables”

have_query_cache

Section 8.6.3.3, “Query Cache Configuration”
Section 5.1.4, “Server System Variables”

have_raid

Section 5.1.4, “Server System Variables”

have_rtree_keys

Section 5.1.4, “Server System Variables”

have_ssl

Section 6.3.6.2, “Configuring MySQL for SSL”
Section 5.1.4, “Server System Variables”

have_symlink

Section 5.1.4, “Server System Variables”
Section 8.9.6.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section 8.9.6.3, “Using Symbolic Links for Databases on Windows”

hostname

Section 5.1.4, “Server System Variables”

I

[index top]

identity

Section 5.1.4, “Server System Variables”

init_connect

Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

init_file

Section 5.1.4, “Server System Variables”

init_slave

Section 16.1.2.3, “Replication Slave Options and Variables”

innodb_autoextend_increment

Section 14.2.1, “InnoDB Configuration”
Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 14.2.4, “Adding, Removing, or Resizing InnoDB Data and Log Files”

innodb_buffer_pool_awe_mem_mb

Section 14.2.1, “InnoDB Configuration”

innodb_buffer_pool_size

Section 14.2.12.1, “InnoDB Performance Tuning Tips”
Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 8.6.2, “The InnoDB Buffer Pool”

innodb_checksums

Section 14.2.2, “InnoDB Startup Options and System Variables”

innodb_concurrency_tickets

Section 14.2.2, “InnoDB Startup Options and System Variables”

innodb_data_file_path

Section 14.2.1, “InnoDB Configuration”
Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 14.2.4, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 14.2.1.4, “Dealing with InnoDB Initialization Problems”
Section 14.2.1.2, “Using Raw Devices for the Shared Tablespace”

innodb_data_home_dir

Section 14.2.1, “InnoDB Configuration”
Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 14.2.1.4, “Dealing with InnoDB Initialization Problems”

innodb_fast_shutdown

Section 14.2.4, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 5.1.10, “The Shutdown Process”

innodb_file_io_threads

Section 14.2.12.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 21.1.1, “MySQL Threads”

innodb_file_per_table

Section 13.1.10, “CREATE TABLE Syntax”
Section 14.2.3.5, “InnoDB and MySQL Replication”
Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.2, “InnoDB Tablespace Monitor Output”
Section 14.2.1.3, “Creating the InnoDB Tablespace”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 14.2.12.4, “Troubleshooting InnoDB Data Dictionary Operations”
Section 14.2.1.1, “Using Per-Table Tablespaces”

innodb_flush_log_at_trx_commit

Section 14.2.12.1, “InnoDB Performance Tuning Tips”
Section 14.2.2, “InnoDB Startup Options and System Variables”

innodb_flush_method

Section 14.2.12.1, “InnoDB Performance Tuning Tips”
Section 14.2.2, “InnoDB Startup Options and System Variables”

innodb_force_recovery

Section 14.2.5.2, “Forcing InnoDB Recovery”
Section 1.7, “How to Report Bugs or Problems”

innodb_lock_wait_timeout

Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 14.2.7.8, “Deadlock Detection and Rollback”
Section 16.4.1.22, “Replication Retries and Timeouts”
Section 16.1.2.3, “Replication Slave Options and Variables”

innodb_locks_unsafe_for_binlog

Section 14.2.7.4, “InnoDB Record, Gap, and Next-Key Locks”
Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 14.2.7.2, “Consistent Nonlocking Reads”
Section 14.2.7.6, “Locks Set by Different SQL Statements in InnoDB”

innodb_log_file_size

Section 14.2.1, “InnoDB Configuration”
Section 14.2.2, “InnoDB Startup Options and System Variables”

innodb_max_purge_lag

Section 14.2.8, “InnoDB Multi-Versioning”
Section 14.2.2, “InnoDB Startup Options and System Variables”

innodb_support_xa

Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 14.2.7.9, “How to Cope with Deadlocks”

innodb_table_locks

Section 14.2.2, “InnoDB Startup Options and System Variables”

innodb_thread_concurrency

Section 14.2.12.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.2.2, “InnoDB Startup Options and System Variables”

innodb_use_legacy_cardinality_algorithm

Section 14.2.2, “InnoDB Startup Options and System Variables”

insert_id

Section 5.1.4, “Server System Variables”

interactive_timeout

Section 20.6.7.52, “mysql_real_connect()”
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 2.20.4.1, “FreeBSD Notes”
Section 2.20.2.1, “Mac OS X 10.x (Darwin)”
Section 5.1.4, “Server System Variables”

J

[index top]

join_buffer_size

Section 8.3.1.8, “Nested-Loop Join Algorithms”
Section 5.1.4, “Server System Variables”

K

[index top]

keep_files_on_create

Section 5.1.4, “Server System Variables”

key_buffer_size

Section 8.2.4, “Estimating Query Performance”
Section 8.9.4, “How MySQL Uses Memory”
Section 7.6.3, “How to Repair MyISAM Tables”
Section C.5.8, “Known Issues in MySQL”
Section 8.6.1.2, “Multiple Key Caches”
Section 8.6.1.6, “Restructuring a Key Cache”
Section 5.1.3, “Server Command Options”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 8.3.2.3, “Speed of DELETE Statements”
Section 8.3.2.1, “Speed of INSERT Statements”
Section 8.3.2.4, “Speed of REPAIR TABLE Statements”
Section 5.1.5.1, “Structured System Variables”
Section 8.6.1, “The MyISAM Key Cache”
Section 8.9.2, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”

key_cache_age_threshold

Section 8.6.1.3, “Midpoint Insertion Strategy”
Section 5.1.4, “Server System Variables”
Section 5.1.5.1, “Structured System Variables”

key_cache_block_size

Section 8.6.1.5, “Key Cache Block Size”
Section 8.6.1.6, “Restructuring a Key Cache”
Section 5.1.4, “Server System Variables”
Section 5.1.5.1, “Structured System Variables”

key_cache_division_limit

Section 8.6.1.3, “Midpoint Insertion Strategy”
Section 5.1.4, “Server System Variables”
Section 5.1.5.1, “Structured System Variables”

L

[index top]

language

Section 5.1.4, “Server System Variables”

large_files_support

Section 5.1.4, “Server System Variables”

large_page_size

Section 5.1.4, “Server System Variables”

large_pages

Section 5.1.4, “Server System Variables”

last_insert_id

Section 5.1.4, “Server System Variables”

lc_time_names

Section 12.7, “Date and Time Functions”
Section 10.7, “MySQL Server Locale Support”
Section 5.1.4, “Server System Variables”
Section 2.19.1.2, “Upgrading from MySQL 4.1 to 5.0”

license

Section 5.1.4, “Server System Variables”

local

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”

local_infile

Section 5.1.4, “Server System Variables”

locked_in_memory

Section 5.1.4, “Server System Variables”

log

Section 5.1.4, “Server System Variables”

log_bin

Section 16.1.2.4, “Binary Log Options and Variables”

log_bin_trust_function_creators

Section 16.1.2.4, “Binary Log Options and Variables”
Section 18.6, “Binary Logging of Stored Programs”
Section 5.1.4, “Server System Variables”

log_error

Section 5.1.4, “Server System Variables”
Section 5.2.1, “The Error Log”

log_queries_not_using_indexes

Section 5.1.4, “Server System Variables”

log_slave_updates

Section 16.1.2.4, “Binary Log Options and Variables”

log_slow_queries

Section 5.1.4, “Server System Variables”

log_warnings

Section 5.1.4, “Server System Variables”
Section 5.2.1, “The Error Log”

long_query_time

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.2, “MySQL Server Logs”
Section 5.1.3, “Server Command Options”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.4, “The Slow Query Log”

low_priority_updates

Section 5.1.4, “Server System Variables”
Section 8.7.2, “Table Locking Issues”

lower_case_file_system

Section 5.1.4, “Server System Variables”

lower_case_table_names

Section 13.7.1.3, “GRANT Syntax”
Section 13.7.1.5, “REVOKE Syntax”
Section 13.7.5.34, “SHOW TABLES Syntax”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 1.7, “How to Report Bugs or Problems”
Section 9.2.2, “Identifier Case Sensitivity”
Section 16.4.1.28, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 13.1.10.2, “Using FOREIGN KEY Constraints”

M

[index top]

max_allowed_packet

Section 12.15.1, “GROUP BY (Aggregate) Functions”
Section C.5.2.3, “Lost connection to MySQL server”
Section C.5.2.9, “MySQL server has gone away”
Section 20.6.7.71, “mysql_use_result()”
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 12.3.2, “Comparison Functions and Operators”
Section C.5.5.6, “Deleting Rows from Related Tables”
Section 8.9.4, “How MySQL Uses Memory”
Section 20.6, “MySQL C API”
Section C.5.2.10, “Packet Too Large”
Section 5.1.4, “Server System Variables”
Section 12.5, “String Functions”
Section 11.1.6.3, “The BLOB and TEXT Types”
Section 4.2.3.3, “Using Option Files”

max_binlog_cache_size

Section 14.5.3, “BDB Startup Options”
Section 16.1.2.4, “Binary Log Options and Variables”
Section 5.2.3, “The Binary Log”

max_binlog_size

Section 16.1.2.4, “Binary Log Options and Variables”
Section 5.2, “MySQL Server Logs”
Section 5.2.5, “Server Log Maintenance”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”
Section 16.2.2.1, “The Slave Relay Log”

max_connect_errors

Section 13.7.6.2, “FLUSH Syntax”
Section C.5.2.6, “Host 'host_name' is blocked”
Section 8.9.8, “DNS Lookup Optimization and the Host Cache”
Section 5.1.4, “Server System Variables”

max_connections

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section C.5.2.7, “Too many connections”
Section 21.3.1.4, “Debugging mysqld under gdb”
Section 8.8.3, “How MySQL Opens and Closes Tables”
Section 8.9.3, “How MySQL Uses Threads for Client Connections”
Section 2.20.1.4, “Linux Postinstallation Notes”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

max_delayed_threads

Section 5.1.4, “Server System Variables”

max_error_count

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.7.5.14, “SHOW ERRORS Syntax”
Section 13.7.5.37, “SHOW WARNINGS Syntax”
Section 5.1.4, “Server System Variables”

max_heap_table_size

Section 8.8.5, “How MySQL Uses Internal Temporary Tables”
Section E.7.3, “Limits on Table Size”
Section 16.4.1.14, “Replication and MEMORY Tables”
Section 16.4.1.28, “Replication and Variables”
Section E.2, “Restrictions on Server-Side Cursors”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 14.4, “The MEMORY (HEAP) Storage Engine”

max_insert_delayed_threads

Section 5.1.4, “Server System Variables”

max_join_size

Section 4.5.1.1, “mysql Options”
Section 8.2.2, “EXPLAIN Output Format”
Section 13.7.4, “SET Syntax”
Section 5.1.4, “Server System Variables”
Section 5.1.5, “Using System Variables”

max_length_for_sort_data

Section 8.3.1.11, “ORDER BY Optimization”
Section 5.1.4, “Server System Variables”

max_prepared_stmt_count

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 13.5, “SQL Syntax for Prepared Statements”

max_relay_log_size

Section 16.1.2.4, “Binary Log Options and Variables”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”
Section 16.2.2.1, “The Slave Relay Log”

max_seeks_for_key

Section 14.2.13, “Limits on InnoDB Tables”
Section 5.1.4, “Server System Variables”

max_sort_length

Section 13.1.10, “CREATE TABLE Syntax”
Section C.5.8, “Known Issues in MySQL”
Section 5.1.4, “Server System Variables”
Section 11.1.6.3, “The BLOB and TEXT Types”

max_sp_recursion_depth

Section 5.1.4, “Server System Variables”
Section 18.2.1, “Stored Routine Syntax”

max_tmp_tables

Section 5.1.4, “Server System Variables”

max_user_connections

Section 13.7.1.3, “GRANT Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.2.2, “Privilege System Grant Tables”
Section 5.1.4, “Server System Variables”
Section 6.3.4, “Setting Account Resource Limits”

max_write_lock_count

Section 5.1.4, “Server System Variables”
Section 8.7.2, “Table Locking Issues”

myisam_data_pointer_size

Section 13.1.10, “CREATE TABLE Syntax”
Section E.7.3, “Limits on Table Size”
Section 5.1.4, “Server System Variables”

myisam_max_extra_sort_file_size

Section 5.1.4, “Server System Variables”

myisam_max_sort_file_size

Section 14.1.1, “MyISAM Startup Options”
Section 5.1.4, “Server System Variables”
Section 8.3.2.4, “Speed of REPAIR TABLE Statements”

myisam_mmap_size

Section 5.1.4, “Server System Variables”

myisam_recover_options

Section 5.1.4, “Server System Variables”

myisam_repair_threads

Section 5.1.4, “Server System Variables”

myisam_sort_buffer_size

Section 13.1.4, “ALTER TABLE Syntax”
Section 14.1.1, “MyISAM Startup Options”
Section 5.1.4, “Server System Variables”
Section 8.3.2.4, “Speed of REPAIR TABLE Statements”

myisam_stats_method

Section 8.5.4, “MyISAM Index Statistics Collection”
Section 5.1.4, “Server System Variables”

N

[index top]

named_pipe

Section 5.1.4, “Server System Variables”

ndb_autoincrement_prefetch_sz

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_cache_check_time

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_force_send

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_index_stat_cache_entries

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_index_stat_enable

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_index_stat_update_freq

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_optimized_node_selection

Section 17.3.4.3, “MySQL Cluster System Variables”
Section 17.5.6.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”

ndb_report_thresh_binlog_epoch_slip

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_report_thresh_binlog_mem_usage

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_use_exact_count

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_use_transactions

Section 17.3.4.3, “MySQL Cluster System Variables”

net_buffer_length

Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 8.9.4, “How MySQL Uses Memory”
Section 20.6, “MySQL C API”
Section 5.1.4, “Server System Variables”

net_read_timeout

Section 13.4.2.2, “LOAD DATA FROM MASTER Syntax”
Section C.5.2.3, “Lost connection to MySQL server”
Section 2.20.4.1, “FreeBSD Notes”
Section 2.20.2.1, “Mac OS X 10.x (Darwin)”
Section 5.1.4, “Server System Variables”

net_retry_count

Section 20.6.7.49, “mysql_options()”
Section 5.1.4, “Server System Variables”

net_write_timeout

Section 13.4.2.2, “LOAD DATA FROM MASTER Syntax”
Section 5.1.4, “Server System Variables”

new

Section 5.1.4, “Server System Variables”

O

[index top]

old_passwords

Section C.5.2.4, “Client does not support authentication protocol”
Section 13.7.1.6, “SET PASSWORD Syntax”
Section 6.3.5, “Assigning Account Passwords”
Section 12.12, “Encryption and Compression Functions”
Section 6.1.2.5, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 20.7, “MySQL PHP API”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 5.1.4, “Server System Variables”

one_shot

Section 5.1.4, “Server System Variables”

open_files_limit

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 5.1.4, “Server System Variables”

optimizer_prune_level

Section 8.4, “Controlling the Query Optimizer”
Section 5.1.4, “Server System Variables”

optimizer_search_depth

Section 8.4, “Controlling the Query Optimizer”
Section 5.1.4, “Server System Variables”

P

[index top]

pid_file

Section 5.1.4, “Server System Variables”

plugin_dir

Section 13.7.3.1, “CREATE FUNCTION Syntax for User-defined Functions”
Section 6.1.2.2, “Administrator Guidelines for Password Security”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 5.1.4, “Server System Variables”
Section 2.18.1, “Unix Postinstallation Procedures”

port

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

preload_buffer_size

Section 5.1.4, “Server System Variables”

prepared_stmt_count

Section 5.1.4, “Server System Variables”

profiling

Section 13.7.5.28, “SHOW PROFILE Syntax”
Section 5.1.4, “Server System Variables”
Section 19.7, “The INFORMATION_SCHEMA PROFILING Table”

profiling_history_size

Section 13.7.5.28, “SHOW PROFILE Syntax”
Section 5.1.4, “Server System Variables”

protocol_version

Section 5.1.4, “Server System Variables”

pseudo_thread_id

Section 5.1.4, “Server System Variables”

Q

[index top]

query_alloc_block_size

Section 5.1.4, “Server System Variables”

query_cache_limit

Section 8.6.3.3, “Query Cache Configuration”
Section 5.1.4, “Server System Variables”

query_cache_min_res_unit

Section 8.6.3.3, “Query Cache Configuration”
Section 5.1.4, “Server System Variables”

query_cache_size

Section 8.6.3.3, “Query Cache Configuration”
Section 5.1.4, “Server System Variables”
Section 8.6.3, “The MySQL Query Cache”
Section 5.1.5, “Using System Variables”

query_cache_type

Section 13.2.8, “SELECT Syntax”
Section 8.6.3.2, “Query Cache SELECT Options”
Section 8.6.3.3, “Query Cache Configuration”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

query_cache_wlock_invalidate

Section 5.1.4, “Server System Variables”

query_prealloc_size

Section 5.1.4, “Server System Variables”

R

[index top]

rand_seed

Section 5.1.4, “Server System Variables”

range_alloc_block_size

Section 5.1.4, “Server System Variables”

read_buffer_size

Section 8.9.4, “How MySQL Uses Memory”
Section 5.1.4, “Server System Variables”
Section 8.3.2.4, “Speed of REPAIR TABLE Statements”

read_only

Section 13.7.1.6, “SET PASSWORD Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 16.4.1.28, “Replication and Variables”
Section 5.1.4, “Server System Variables”

read_rnd_buffer_size

Section 8.3.1.11, “ORDER BY Optimization”
Section 8.9.4, “How MySQL Uses Memory”
Section 5.1.4, “Server System Variables”
Section 8.9.2, “Tuning Server Parameters”

relay_log

Section 16.1.2.3, “Replication Slave Options and Variables”

relay_log_index

Section 16.1.2.3, “Replication Slave Options and Variables”

relay_log_info_file

Section 16.1.2.3, “Replication Slave Options and Variables”

relay_log_purge

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 5.1.4, “Server System Variables”

relay_log_space_limit

Section 8.10.6, “Replication Slave I/O Thread States”
Section 5.1.4, “Server System Variables”

Rpl_recovery_rank

Section 13.7.5.30, “SHOW SLAVE HOSTS Syntax”

rpl_recovery_rank

Section 16.1.2.3, “Replication Slave Options and Variables”

S

[index top]

secure_auth

Section 6.1.2.4, “Password Hashing in MySQL”
Section 5.1.4, “Server System Variables”

secure_file_priv

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.2.8.1, “SELECT ... INTO Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.4, “Server System Variables”
Section 12.5, “String Functions”

server_id

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.1.4, “Server System Variables”

shared_memory

Section 5.1.4, “Server System Variables”

shared_memory_base_name

Section 5.1.4, “Server System Variables”

skip_external_locking

Section 8.7.4, “External Locking”
Section 5.1.4, “Server System Variables”

skip_networking

Section 5.1.4, “Server System Variables”

skip_show_database

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

slave_compressed_protocol

Section 16.1.2.3, “Replication Slave Options and Variables”

slave_load_tmpdir

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

slave_net_timeout

Section 16.1.3.1, “Checking Replication Status”
Section 16.4.1.13, “Replication and Master or Slave Shutdowns”
Section 8.10.6, “Replication Slave I/O Thread States”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

slave_skip_errors

Section 16.1.2.3, “Replication Slave Options and Variables”

slave_transaction_retries

Section 16.4.1.22, “Replication Retries and Timeouts”
Section 16.1.2.3, “Replication Slave Options and Variables”

slow_launch_time

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

socket

Section 5.1.4, “Server System Variables”

sort_buffer_size

Section 8.3.1.11, “ORDER BY Optimization”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

sql_auto_is_null

Section 12.3.2, “Comparison Functions and Operators”
Section 16.4.1.28, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”

sql_big_selects

Section 5.1.4, “Server System Variables”

sql_buffer_result

Section 5.1.4, “Server System Variables”

sql_log_bin

Section 13.4.1.3, “SET sql_log_bin Syntax”
Section 17.1.5.8, “Issues Exclusive to MySQL Cluster”
Section 5.1.4, “Server System Variables”
Section 16.4.3, “Upgrading a Replication Setup”

sql_log_off

Section 5.2.5, “Server Log Maintenance”
Section 5.1.4, “Server System Variables”

sql_log_update

Section 5.1.4, “Server System Variables”

sql_mode

Section 13.1.9, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.11, “CREATE TRIGGER Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.7.5.10, “SHOW CREATE VIEW Syntax”
Section 13.7.5.35, “SHOW TRIGGERS Syntax”
Section 12.17.3, “Expression Handling”
Section 1.7, “How to Report Bugs or Problems”
Section C.5.5.2, “Problems Using DATE Columns”
Section 16.4.1.28, “Replication and Variables”
Section 1.8.3, “Running MySQL in ANSI Mode”
Section 1.8.2, “Selecting SQL Modes”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 19.8, “The INFORMATION_SCHEMA ROUTINES Table”
Section 19.15, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.17, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.3, “The Binary Log”
Section 5.1.5, “Using System Variables”

sql_notes

Section 13.7.5.37, “SHOW WARNINGS Syntax”
Section 5.1.4, “Server System Variables”

sql_quote_show_create

Section 13.7.5.6, “SHOW CREATE DATABASE Syntax”
Section 13.7.5.9, “SHOW CREATE TABLE Syntax”
Section 5.1.4, “Server System Variables”

sql_safe_updates

Section 5.1.4, “Server System Variables”

sql_select_limit

Section 5.1.4, “Server System Variables”

sql_slave_skip_counter

Section 13.7.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.1.2.3, “Replication Slave Options and Variables”

sql_warnings

Section 5.1.4, “Server System Variables”

ssl_ca

Section 5.1.4, “Server System Variables”

ssl_capath

Section 5.1.4, “Server System Variables”

ssl_cert

Section 5.1.4, “Server System Variables”

ssl_cipher

Section 5.1.4, “Server System Variables”

ssl_key

Section 5.1.4, “Server System Variables”

storage_engine

Section 16.4.1.28, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Chapter 14, Storage Engines
Section 16.3.2, “Using Replication with Different Master and Slave Storage Engines”

sync_binlog

Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 16.1.2.4, “Binary Log Options and Variables”
Section 16.4.1.13, “Replication and Master or Slave Shutdowns”
Section 5.2.3, “The Binary Log”

sync_frm

Section 5.1.4, “Server System Variables”

system_time_zone

Section 10.6, “MySQL Server Time Zone Support”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

T

[index top]

table_cache

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 8.10.2, “General Thread States”
Section 8.8.3, “How MySQL Opens and Closes Tables”
Section 8.9.4, “How MySQL Uses Memory”
Section 5.1.3, “Server Command Options”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 8.9.2, “Tuning Server Parameters”

table_lock_wait_timeout

Section 5.1.4, “Server System Variables”

table_type

Section 5.1.4, “Server System Variables”
Chapter 14, Storage Engines
Section 16.3.2, “Using Replication with Different Master and Slave Storage Engines”

thread_cache_size

Section 21.3.1.4, “Debugging mysqld under gdb”
Section 8.9.3, “How MySQL Uses Threads for Client Connections”
Section 8.3.3, “Other Optimization Tips”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

thread_concurrency

Section 5.1.4, “Server System Variables”

thread_stack

Section 8.9.4, “How MySQL Uses Memory”
Section 5.1.4, “Server System Variables”
Section 18.2.1, “Stored Routine Syntax”

time_format

Section 5.1.4, “Server System Variables”

time_zone

Section 12.7, “Date and Time Functions”
Section 10.6, “MySQL Server Time Zone Support”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 11.1.5.1, “The DATE, DATETIME, and TIMESTAMP Types”

timed_mutexes

Section 13.7.5.22, “SHOW MUTEX STATUS Syntax”
Section 5.1.4, “Server System Variables”

timestamp

Section 5.1.4, “Server System Variables”

tmp_table_size

Section 8.8.5, “How MySQL Uses Internal Temporary Tables”
Section E.2, “Restrictions on Server-Side Cursors”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

tmpdir

Section C.5.2.13, “Can't create/write to file”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 8.3.1.11, “ORDER BY Optimization”
Section 16.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.2, “Database Backup Methods”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

transaction_alloc_block_size

Section 5.1.4, “Server System Variables”

transaction_prealloc_size

Section 5.1.4, “Server System Variables”

tx_isolation

Section 13.3.6, “SET TRANSACTION Syntax”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

U

[index top]

unique_checks

Section 14.2.3.2, “Converting Tables from Other Storage Engines to InnoDB”
Section 16.4.1.28, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”

updatable_views_with_limit

Section 5.1.4, “Server System Variables”
Section 18.4.3, “Updatable and Insertable Views”

V

[index top]

version

Section 12.13, “Information Functions”
Section 5.1.4, “Server System Variables”

version_bdb

Section 5.1.4, “Server System Variables”

version_comment

Section 5.1.4, “Server System Variables”

version_compile_machine

Section 5.1.4, “Server System Variables”

version_compile_os

Section 5.1.4, “Server System Variables”

W

[index top]

wait_timeout

Section C.5.2.9, “MySQL server has gone away”
Section 20.6.7.52, “mysql_real_connect()”
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 2.20.4.1, “FreeBSD Notes”
Section 2.20.2.1, “Mac OS X 10.x (Darwin)”
Section 5.1.4, “Server System Variables”

warning_count

Section 13.7.5.14, “SHOW ERRORS Syntax”
Section 13.7.5.37, “SHOW WARNINGS Syntax”
Section 5.1.4, “Server System Variables”
Section C.1, “Sources of Error Information”
Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices