System Variable Index
   

System Variable Index

--default_storage_engine

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--default_tmp_storage_engine

Section 5.1.7.1, “Installing and Uninstalling Plugins”

AUTOCOMMIT=1

Section 15.4.1.29, “Replication and Transactions”

Rpl_recovery_rank

Section 12.7.5.34, “SHOW SLAVE HOSTS Синтаксис”

authentication_windows_log_level

Section 5.1.3, “Server System Variables”
Section 5.5.6.3.2, “Using the Windows Authentication Plugin”

authentication_windows_use_principal_name

Section 5.1.3, “Server System Variables”
Section 5.5.6.3.2, “Using the Windows Authentication Plugin”

auto_increment_increment

Section 13.3.5.3.1, ““Traditional” InnoDB Auto-Increment Locking”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
Section 15.1.3.2, “Replication Master Options and Variables”
Section 15.4.1.33, “Replication and Variables”
Section 3.6.9, “Using AUTO_INCREMENT”

auto_increment_offset

Section 13.3.5.3.1, ““Traditional” InnoDB Auto-Increment Locking”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
Section 15.1.3.2, “Replication Master Options and Variables”
Section 15.4.1.33, “Replication and Variables”
Section 3.6.9, “Using AUTO_INCREMENT”

autocommit

Section 12.2.2, “DELETE Синтаксис”
Section 13.3.9.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Синтаксис”
Section 16.3.4.3, “MySQL Cluster System Variables”
Section 15.4.1.29, “Replication and Transactions”
Section 5.1.3, “Server System Variables”
Section 7.11.6.2, “Thread Pool Operation”

autocommit = 0

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.9.8, “Deadlock Detection and Rollback”
Section 13.3.9.6, “Locks Set by Different SQL Statements in InnoDB”

autocommit = 1

Section 12.3.5.1, “Interaction of Table Locking and Transactions”
Section 1.8.5.3, “Transaction and Atomic Operation Differences”

autocommit=1

Section 13.3.15, “Limits on InnoDB Tables”
Section 5.1.3, “Server System Variables”

automatic_sp_privileges

Section 12.1.5, “ALTER PROCEDURE Синтаксис”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 5.1.3, “Server System Variables”
Section 18.2.2, “Stored Routines and MySQL Privileges”

back_log

Section 5.1.3, “Server System Variables”

basedir

Section 12.7.3.3, “INSTALL PLUGIN Синтаксис”
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_log_buffer_size

Section 5.1.3, “Server System Variables”

bdb_logdir

Section 5.1.3, “Server System Variables”

bdb_max_lock

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”

big_tables

Section 5.1.3, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

bind_address

Section 5.1.3, “Server System Variables”

binlog_cache_size

Section 15.1.3.4, “Binary Log Options and Variables”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 5.2.4, “The Binary Log”

binlog_checksum

Section 15.1.3.4, “Binary Log Options and Variables”
Section 5.2.4, “The Binary Log”
Section 1.4, “What Is New in MySQL 5.5”

binlog_direct_non_transactional_updates

Section 15.1.3.4, “Binary Log Options and Variables”
Section 15.4.1.29, “Replication and Transactions”

binlog_format

Section 12.2.5.2, “INSERT DELAYED Синтаксис”
Section 15.1.3.4, “Binary Log Options and Variables”
Section 11.7, “Date and Time Functions”
Описание
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 11.14, “Information Functions”
Section 5.2.4.4, “Logging Format for Changes to mysql Database Tables”
Section 11.6.2, “Mathematical Functions”
Section 11.15, “Miscellaneous Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.1.2, “Replication Formats”
Section 15.4.1.29, “Replication and Transactions”
Section 15.4.1.20, “Replication of the mysql System Database”
Section 5.1.2, “Server Command Options”
Section 5.2.4.2, “Setting The Binary Log Format”

binlog_format = STATEMENT

Section 5.2.4.3, “Mixed Binary Logging Format”

binlog_format=ROW

Section 15.4.1.18, “Replication and MEMORY Tables”
Section 13.9, “The BLACKHOLE Storage Engine”

binlog_row_image

Section 15.1.3.4, “Binary Log Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

binlog_rows_query_log_events

Section 15.1.3.4, “Binary Log Options and Variables”

binlog_stmt_cache_size

Section 15.1.3.4, “Binary Log Options and Variables”
Section 5.1.5, “Server Status Variables”

bulk_insert_buffer_size

Section 13.5.1, “MyISAM Startup Options”
Section 5.1.3, “Server System Variables”
Section 7.2.2.1, “Speed of INSERT Statements”

character_set_client

Section 12.2.6, “LOAD DATA INFILE Синтаксис”
Section 12.7.4, “SET Синтаксис”
Section 12.7.5.9, “SHOW CREATE EVENT Синтаксис”
Section 12.7.5.11, “SHOW CREATE PROCEDURE Синтаксис”
Section 12.7.5.14, “SHOW CREATE VIEW Синтаксис”
Section 12.7.5.19, “SHOW EVENTS Синтаксис”
Section 12.7.5.29, “SHOW PROCEDURE STATUS Синтаксис”
Section 12.7.5.39, “SHOW TRIGGERS Синтаксис”
Section 21.9.5.1, “C API Prepared Statement Type Codes”
Section 9.5, “Character Set Configuration”
Section 9.1.4, “Connection Character Sets and Collations”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 19.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 19.18, “The INFORMATION_SCHEMA ROUTINES Table”
Section 19.26, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.28, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”

character_set_connection

Section 9.1.9.2, “CONVERT() and CAST()”
Section 12.7.4, “SET Синтаксис”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 9.1.7.5, “Collation of Expressions”
Section 9.1.4, “Connection Character Sets and Collations”
Section 11.7, “Date and Time Functions”
Section 11.13, “Encryption and Compression Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 9.7, “MySQL Server Locale Support”
Section 15.4.1.33, “Replication and Variables”
Section 9.1.9.1, “Result Strings”
Section 5.1.3, “Server System Variables”
Section 8.1.1, “String Literals”
Section 9.1.8, “String Repertoire”
Section 11.2, “Type Conversion in Expression Evaluation”

character_set_database

Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 12.2.6, “LOAD DATA INFILE Синтаксис”
Section 12.7.4, “SET Синтаксис”
Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”

character_set_filesystem

Section 12.2.6, “LOAD DATA INFILE Синтаксис”
Section 12.2.9.1, “SELECT ... INTO Синтаксис”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 11.5, “String Functions”

character_set_results

Section 12.7.4, “SET Синтаксис”
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 9.1.12, “UTF-8 for Metadata”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

character_set_server

Section 9.5, “Character Set Configuration”
Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.2, “Replication and Character Sets”
Section 15.4.1.33, “Replication and Variables”
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server System Variables”

character_set_system

Section 9.5, “Character Set Configuration”
Section 5.1.3, “Server System Variables”
Section 9.1.12, “UTF-8 for Metadata”

character_sets_dir

Section 9.4.3, “Adding a Simple Collation to an 8-Bit Character Set”
Section 9.4.4.1, “Defining a UCA Collation using LDML Синтаксис”
Section 5.1.3, “Server System Variables”

collation_connection

Section 9.1.9.2, “CONVERT() and CAST()”
Section 12.7.4, “SET Синтаксис”
Section 12.7.5.9, “SHOW CREATE EVENT Синтаксис”
Section 12.7.5.11, “SHOW CREATE PROCEDURE Синтаксис”
Section 12.7.5.14, “SHOW CREATE VIEW Синтаксис”
Section 12.7.5.19, “SHOW EVENTS Синтаксис”
Section 12.7.5.29, “SHOW PROCEDURE STATUS Синтаксис”
Section 12.7.5.39, “SHOW TRIGGERS Синтаксис”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 9.1.7.5, “Collation of Expressions”
Section 9.1.4, “Connection Character Sets and Collations”
Section 11.7, “Date and Time Functions”
Section 11.13, “Encryption and Compression Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 9.1.9.1, “Result Strings”
Section 5.1.3, “Server System Variables”
Section 19.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 19.18, “The INFORMATION_SCHEMA ROUTINES Table”
Section 19.26, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.28, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”
Section 11.2, “Type Conversion in Expression Evaluation”

collation_database

Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 5.2.4, “The Binary Log”

collation_server

Section 9.1.4, “Connection Character Sets and Collations”
Section 9.1.3.2, “Database Character Set and Collation”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.2, “Replication and Character Sets”
Section 15.4.1.33, “Replication and Variables”
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server System Variables”
Section 5.2.4, “The Binary Log”

completion_type

Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Синтаксис”
Section 21.9.3.6, “mysql_commit()”
Section 21.9.3.57, “mysql_rollback()”
Section 5.1.3, “Server System Variables”

concurrent_insert

Section 7.10.3, “Concurrent Inserts”
Section 7.10.1, “Internal Locking Methods”
Section 7.6.1, “Optimizing MyISAM Queries”
Section 7.2.5, “Other Optimization Tips”
Section 5.1.3, “Server System Variables”

connect_timeout

Section C.5.2.3, “Lost connection to MySQL server”
Section 21.9.3.52, “mysql_real_connect()”
Section C.5.2.11, “Communication Ошибки and Aborted Connections”
Section 5.1.3, “Server System Variables”

datadir

Section 2.3, “Installing MySQL on Microsoft Windows”
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”

debug

Section 5.1.3, “Server System Variables”

debug_sync

Section 5.1.3, “Server System Variables”

default_storage_engine

Section 12.1.14, “CREATE LOGFILE GROUP Синтаксис”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 13.1, “Setting the Storage Engine”
Section 15.3.2, “Using Replication with Different Master and Slave Storage Engines”

default_tmp_storage_engine

Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 13.1, “Setting the Storage Engine”

default_week_format

Section 11.7, “Date and Time Functions”
Section 17.5.3, “Partitioning Limitations Relating to Functions”
Section 5.1.3, “Server System Variables”

delay_key_write

Section 12.1.17, “CREATE TABLE Синтаксис”
Section 5.1.3, “Server System Variables”

delayed_insert_limit

Section 12.2.5.2, “INSERT DELAYED Синтаксис”
Section 5.1.3, “Server System Variables”

delayed_insert_timeout

Section 12.2.5.2, “INSERT DELAYED Синтаксис”
Section 5.1.3, “Server System Variables”

delayed_queue_size

Section 12.2.5.2, “INSERT DELAYED Синтаксис”
Section 5.1.3, “Server System Variables”

div_precision_increment

Section 11.6.1, “Arithmetic Operators”
Section 5.1.3, “Server System Variables”

engine_condition_pushdown

Section 7.13.3, “Engine Condition Pushdown Optimization”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

error_count

Section 12.7.5.18, “SHOW ERRORS Синтаксис”
Section 5.1.3, “Server System Variables”
Section C.1, “Sources of Error Information”

event_scheduler

Section 18.4.2, “Event Scheduler Configuration”
Section 21.8.2, “Restrictions When Using the Embedded MySQL Server”
Section 5.1.3, “Server System Variables”
Section 18.4.6, “The Event Scheduler and MySQL Privileges”

expire_logs_days

Section 12.4.1.1, “PURGE BINARY LOGS Синтаксис”
Section 5.2.6, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”

external_user

Section 22.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 5.5.7, “Proxy Users”
Section 5.1.3, “Server System Variables”
Section 22.2.4.9.1, “Writing the Server-Side Authentication Plugin”

flush

Section 5.1.3, “Server System Variables”

flush_time

Section 5.1.3, “Server System Variables”

foreign_key_checks

Section 13.3.5.4, “FOREIGN KEY Constraints”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.6, “Server SQL Modes”
Section 5.1.3, “Server System Variables”
Section 5.2.4, “The Binary Log”

foreign_key_checks = 0

Section 13.3.5.4, “FOREIGN KEY Constraints”
Section 5.1.3, “Server System Variables”

ft_boolean_syntax

Section 11.9.2, “Boolean Full-Text Searches”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.3, “Server System Variables”

ft_max_word_len

Section 11.9.2, “Boolean Full-Text Searches”
Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 22.2.3.2, “Full-Text Parser Plugins”
Section 5.1.3, “Server System Variables”

ft_min_word_len

Section 11.9.2, “Boolean Full-Text Searches”
Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 22.2.3.2, “Full-Text Parser Plugins”
Section 11.9.1, “Natural Language Full-Text Searches”
Section 5.1.3, “Server System Variables”

ft_min_word_len=4

Section 11.9.2, “Boolean Full-Text Searches”

ft_query_expansion_limit

Section 5.1.3, “Server System Variables”

ft_stopword_file

Section 11.9.2, “Boolean Full-Text Searches”
Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.3, “Server System Variables”

general_log

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 5.2.3, “The General Query Log”
Section 1.4, “What Is New in MySQL 5.5”

general_log_file

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server System Variables”
Section 5.2.3, “The General Query Log”

group_concat_max_len

Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 5.1.3, “Server System Variables”

have_archive

Section 5.1.3, “Server System Variables”

have_bdb

Section 5.1.3, “Server System Variables”

have_blackhole_engine

Section 5.1.3, “Server System Variables”

have_community_features

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_dynamic_loading

Section 15.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.3, “Server System Variables”

have_example_engine

Section 5.1.3, “Server System Variables”

have_federated_engine

Section 5.1.3, “Server System Variables”

have_geometry

Section 5.1.3, “Server System Variables”

have_innodb

Section C.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 16.3.4.3, “MySQL Cluster System Variables”

have_openssl

Section 5.1.3, “Server System Variables”
Section 5.5.8.2, “Using SSL Connections”

have_partitioning

Глава 17, Partitioning
Section 5.1.3, “Server System Variables”

have_profiling

Section 5.1.3, “Server System Variables”

have_query_cache

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

have_raid

Section 5.1.3, “Server System Variables”

have_row_based_replication

Section 5.1.3, “Server System Variables”

have_rtree_keys

Section 5.1.3, “Server System Variables”

have_ssl

Section 5.1.3, “Server System Variables”
Section 5.5.8.2, “Using SSL Connections”

have_symlink

Section 5.1.3, “Server System Variables”

hostname

Section 5.1.3, “Server System Variables”

identity

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”

ignore_builtin_innodb

Section 13.3.4, “InnoDB Startup Options and System Variables”

ignore_db_dirs

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

init_connect

Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

init_file

Section 5.1.3, “Server System Variables”

init_slave

Section 15.1.3.3, “Replication Slave Options and Variables”

innodb_adaptive_flushing

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_adaptive_hash_index

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_adaptive_max_sleep_delay

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_additional_mem_pool_size

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_analyze_is_persistent

Section 12.7.2.1, “ANALYZE TABLE Синтаксис”
Section 12.1.13, “CREATE INDEX Синтаксис”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.15, “Limits on InnoDB Tables”

innodb_autoextend_increment

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.6, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 13.3.2, “Configuring InnoDB”

innodb_autoinc_lock_mode

Section 7.5.4, “Bulk Data Loading for InnoDB Tables”
Section 13.3.5.3.2, “Configurable InnoDB Auto-Increment Locking”

innodb_buffer_pool_awe_mem_mb

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.2, “Configuring InnoDB”

innodb_buffer_pool_dump_at_shutdown

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_buffer_pool_dump_now

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_buffer_pool_load_abort

Section 5.1.5, “Server Status Variables”

innodb_buffer_pool_load_at_startup

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 5.1.5, “Server Status Variables”

innodb_buffer_pool_load_now

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 5.1.5, “Server Status Variables”

innodb_buffer_pool_size

Section 13.3.13.1, “InnoDB Error Codes”
Section 13.3.14.1, “InnoDB Performance Tuning Tips”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”
Section 7.9.1, “The InnoDB Buffer Pool”

innodb_change_buffer_max_size

Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_change_buffering

Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_change_buffering=all

Section 7.5.2, “Optimizing InnoDB Transaction Management”

innodb_checksum_algorithm

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_checksums

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_commit_concurrency

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_concurrency_tickets

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.8, “Optimizing InnoDB Configuration Variables”

innodb_data_file_path

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.6, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 13.3.2, “Configuring InnoDB”
Section 13.3.3.3, “Troubleshooting InnoDB I/O Problems”
Section 13.3.3.1, “Using Raw Devices for the Shared Tablespace”

innodb_data_home_dir

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.2, “Configuring InnoDB”
Section 13.3.3.3, “Troubleshooting InnoDB I/O Problems”

innodb_doublewrite

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_fast_shutdown

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.6, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 5.1.10, “The Shutdown Process”

innodb_file_format=barracuda

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_file_format_check

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_file_format_max

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_file_io_threads

Section 13.3.14.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 22.1.1, “MySQL Threads”

innodb_file_per_table

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.14.2.2, “InnoDB Tablespace Monitor Output”
Section 13.3.5.5, “InnoDB and MySQL Replication”
Section 12.1.33, “TRUNCATE TABLE Синтаксис”
Section 13.3.3.2, “Creating the InnoDB Tablespace”
Section 13.3.11.5, “Physical Row Structure”
Section 15.3.4, “Replicating Different Databases to Different Slaves”
Section 17.5, “Restrictions and Limitations on Partitioning”
Section 13.3.14.4, “Troubleshooting InnoDB Data Dictionary Operations”
Section 13.3.3, “Using Per-Table Tablespaces”

innodb_file_per_table=1

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_file_per_table=true

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_flush_log_at_trx_commit

Section 13.3.14.1, “InnoDB Performance Tuning Tips”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.2, “Optimizing InnoDB Transaction Management”

innodb_flush_method

Section 13.3.14.1, “InnoDB Performance Tuning Tips”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_flush_method = O_DIRECT

Section 13.3.14.1, “InnoDB Performance Tuning Tips”
Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_flush_neighbors

Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_force_load_corrupted

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_force_recovery

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.7.2, “Forcing InnoDB Recovery”

innodb_force_recovery=3

Section 7.5.2, “Optimizing InnoDB Transaction Management”

innodb_ft_aux_table

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_ft_cache_size

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_ft_enable_stopword

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 11.9.2, “Boolean Full-Text Searches”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”

innodb_ft_max_token_size

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 11.9.2, “Boolean Full-Text Searches”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”

innodb_ft_min_token_size

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 11.9.2, “Boolean Full-Text Searches”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 11.9.1, “Natural Language Full-Text Searches”

innodb_ft_num_word_optimize

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 12.7.2.4, “OPTIMIZE TABLE Синтаксис”

innodb_ft_server_stopword_table

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 11.9.2, “Boolean Full-Text Searches”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 11.9.4, “Full-Text Stopwords”

innodb_ft_sort_pll_degree

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_ft_user_stopword_table

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 11.9.2, “Boolean Full-Text Searches”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 11.9.4, “Full-Text Stopwords”

innodb_io_capacity

Section 1.4.2, “InnoDB I/O Subsystem Changes”
Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_large_prefix

Section 2.11.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 13.3.15, “Limits on InnoDB Tables”

innodb_lock_wait_timeout

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.9.8, “Deadlock Detection and Rollback”
Section 15.4.1.26, “Replication Retries and Timeouts”
Section 15.1.3.3, “Replication Slave Options and Variables”

innodb_locks_unsafe_for_binlog

Section 13.3.9.4, “InnoDB Record, Gap, and Next-Key Locks”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 12.3.6, “SET TRANSACTION Синтаксис”
Section 13.3.9.2, “Consistent Nonlocking Reads”
Section 13.3.9.6, “Locks Set by Different SQL Statements in InnoDB”

innodb_log_arch_dir

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_log_archive

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_log_buffer_size

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_log_file_size

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_log_files_in_group

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_log_group_home_dir

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_lru_scan_depth

Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_max_dirty_pages_pct

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_max_purge_lag

Section 13.3.10, “InnoDB Multi-Versioning”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_mirrored_log_groups

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_old_blocks_pct

Section 7.9.1, “The InnoDB Buffer Pool”

innodb_old_blocks_time

Section 7.9.1, “The InnoDB Buffer Pool”

innodb_open_files

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_optimize_fulltext_only=1

Section 12.7.2.4, “OPTIMIZE TABLE Синтаксис”

innodb_page_size

Section 2.11.2.1, “Downgrading to MySQL 5.1”
Section 13.3.12.2, “File Space Management”
Section 13.3.15, “Limits on InnoDB Tables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”
Section 13.3.11.2, “Physical Structure of an InnoDB Index”

innodb_print_all_deadlocks

Section 13.3.14.3, “InnoDB General Troubleshooting”

innodb_random_read_ahead

Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_read_ahead_threshold

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_read_io_threads

Section 1.4.2, “InnoDB I/O Subsystem Changes”
Section 13.3.14.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 22.1.1, “MySQL Threads”
Section 7.5.7, “Optimizing InnoDB Disk I/O”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

innodb_rollback_on_timeout

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_rollback_segments

Section 7.5.7, “Optimizing InnoDB Disk I/O”

innodb_stats_method

Section 7.3.7, “InnoDB and MyISAM Index Statistics Collection”

innodb_stats_persistent_sample_pages

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.15, “Limits on InnoDB Tables”

innodb_stats_sample_pages

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.15, “Limits on InnoDB Tables”

innodb_stats_transient_sample_pages

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.15, “Limits on InnoDB Tables”

innodb_support_xa

Section 13.3.14.1, “InnoDB Performance Tuning Tips”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.9.9, “How to Cope with Deadlocks”
Section 7.5.2, “Optimizing InnoDB Transaction Management”

innodb_sync_spin_loops

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_table_locks

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_table_locks = 0

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_table_locks=0

Section 13.3.15, “Limits on InnoDB Tables”

innodb_thread_concurrency

Section 13.3.14.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.5.8, “Optimizing InnoDB Configuration Variables”

innodb_thread_sleep_delay

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_undo_directory

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_undo_logs

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_undo_tablespaces

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_use_legacy_cardinality_algorithm

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_use_native_aio=0

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_use_sys_malloc

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_write_io_threads

Section 1.4.2, “InnoDB I/O Subsystem Changes”
Section 13.3.14.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 22.1.1, “MySQL Threads”
Section 7.5.7, “Optimizing InnoDB Disk I/O”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

insert_id

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 5.1.3, “Server System Variables”

interactive_timeout

Section 21.9.3.52, “mysql_real_connect()”
Section C.5.2.11, “Communication Ошибки and Aborted Connections”
Section 5.1.3, “Server System Variables”

join_buffer_size

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

keep_files_on_create

Section 5.1.3, “Server System Variables”

key_buffer_size

Section 7.6.2, “Bulk Data Loading for MyISAM Tables”
Section 7.8.3, “Estimating Query Performance”
Section 7.11.4.1, “How MySQL Uses Memory”
Section 6.6.3, “How to Repair MyISAM Tables”
Section C.5.8, “Known Issues in MySQL”
Section 7.9.2.2, “Multiple Key Caches”
Section 7.9.2.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.2.2.3, “Speed of DELETE Statements”
Section 7.2.2.1, “Speed of INSERT Statements”
Section 7.6.3, “Speed of REPAIR TABLE Statements”
Section 5.1.4.1, “Structured System Variables”
Section 7.9.2, “The MyISAM Key Cache”
Section 7.11.2, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”

key_cache_age_threshold

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

key_cache_block_size

Section 7.9.2.5, “Key Cache Block Size”
Section 7.9.2.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.9.2.3, “Midpoint Insertion Strategy”
Section 5.1.3, “Server System Variables”
Section 5.1.4.1, “Structured System Variables”

language

Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

large_files_support

Section 17.5, “Restrictions and Limitations on Partitioning”
Section 5.1.3, “Server System Variables”

large_page_size

Section 5.1.3, “Server System Variables”

large_pages

Section 5.1.3, “Server System Variables”

last_insert_id

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”

lc_messages

Section 5.1.3, “Server System Variables”
Section 9.2, “Setting the Error Message Language”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
Section 1.4, “What Is New in MySQL 5.5”

lc_messages_dir

Section 5.1.3, “Server System Variables”
Section 9.2, “Setting the Error Message Language”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
Section 1.4, “What Is New in MySQL 5.5”

lc_time_names

Section 11.7, “Date and Time Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 9.7, “MySQL Server Locale Support”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 11.5, “String Functions”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

license

Section 5.1.3, “Server System Variables”

local_infile

Section 5.1.3, “Server System Variables”

lock_wait_timeout

Section 5.1.3, “Server System Variables”

locked_in_memory

Section 5.1.3, “Server System Variables”

log

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

log_bin

Section 15.1.3.4, “Binary Log Options and Variables”
Section 16.3.4.3, “MySQL Cluster System Variables”
Section 5.1.3, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

log_bin_basename

Section 15.1.3.4, “Binary Log Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

log_bin_trust_function_creators

Section 15.1.3.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”
Section 5.1.3, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

log_bin_use_v1_row_events

Section 15.1.3.4, “Binary Log Options and Variables”

log_error

Section 5.1.3, “Server System Variables”

log_output

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server System Variables”
Section 5.2.3, “The General Query Log”
Section 5.2.5, “The Slow Query Log”

log_queries_not_using_indexes

Section 5.1.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

log_slave_updates

Section 15.1.3.4, “Binary Log Options and Variables”
Section 5.1.3, “Server System Variables”

log_slow_admin_statements

Section 5.1.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

log_slow_queries

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

log_slow_slave_statements

Section 5.1.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

log_throttle_queries_not_using_indexes

Section 5.1.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

log_warnings

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

long_query_time

Описание
Section 5.2, “MySQL Server Logs”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

low_priority_updates

Section 5.1.3, “Server System Variables”
Section 7.10.2, “Table Locking Issues”
Section 1.4, “What Is New in MySQL 5.5”

lower_case_file_system

Section 5.1.3, “Server System Variables”

lower_case_table_names

Section 13.3.5.4, “FOREIGN KEY Constraints”
Section 12.7.1.3, “GRANT Синтаксис”
Section 12.7.1.5, “REVOKE Синтаксис”
Section 9.1.7.9, “Collation and INFORMATION_SCHEMA Searches”
Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 1.7, “How to Report Bugs or Problems”
Section 8.2.2, “Identifier Case Sensitivity”
Section 20.1, “Performance Schema Quick Start”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”

master_info_repository

Section 15.1.3.4, “Binary Log Options and Variables”

master_verify_checksum

Section 15.1.3.4, “Binary Log Options and Variables”
Section 5.2.4, “The Binary Log”

max_allowed_packet

Section 11.16.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 C.5.2.10, “Packet too large”
Section 12.7.5.35, “SHOW SLAVE STATUS Синтаксис”
Section 21.9.7.26, “mysql_stmt_send_long_data()”
Section 21.9.3.71, “mysql_use_result()”
Section C.5.2.11, “Communication Ошибки and Aborted Connections”
Section 11.3.2, “Comparison Functions and Operators”
Section C.5.5.6, “Deleting Rows from Related Tables”
Section 7.11.4.1, “How MySQL Uses Memory”
Section 21.9, “MySQL C API”
Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 15.4.1.17, “Replication and max_allowed_packet”
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”
Section 1.4, “What Is New in MySQL 5.5”

max_binlog_cache_size

Section 15.1.3.4, “Binary Log Options and Variables”
Section 5.2.4, “The Binary Log”

max_binlog_size

Section 15.1.3.4, “Binary Log Options and Variables”
Section 5.2, “MySQL Server Logs”
Section 5.2.6, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 5.2.4, “The Binary Log”
Section 15.2.2.1, “The Slave Relay Log”

max_binlog_stmt_cache_size

Section 15.1.3.4, “Binary Log Options and Variables”

max_connect_errors

Section 12.7.6.3, “FLUSH Синтаксис”
Section C.5.2.6, “Host 'host_name' is blocked”
Section 5.1.3, “Server System Variables”

max_connections

Section C.5.2.18, “'File' Not Found and Similar Ошибки”
Section C.5.2.7, “Too many connections”
Section 22.5.1.4, “Debugging mysqld under gdb”
Section 7.4.3.1, “How MySQL Opens and Closes Tables”
Section 7.11.5.1, “How MySQL Uses Threads for Client Connections”
Section 20.8, “Performance Schema System Variables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 7.11.6.2, “Thread Pool Operation”

max_connections+1

Section C.5.2.7, “Too many connections”

max_delayed_threads

Section 20.8, “Performance Schema System Variables”
Section 5.1.3, “Server System Variables”

max_error_count

Section 12.2.6, “LOAD DATA INFILE Синтаксис”
Section 12.6.7.3, “RESIGNAL Синтаксис”
Section 12.7.5.18, “SHOW ERRORS Синтаксис”
Section 12.7.5.41, “SHOW WARNINGS Синтаксис”
Section 5.1.3, “Server System Variables”

max_heap_table_size

Section 7.4.3.3, “How MySQL Uses Internal Temporary Tables”
Section E.10.3, “Limits on Table Size”
Section E.3, “Restrictions on Server-Side Cursors”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 13.6, “The MEMORY Storage Engine”

max_insert_delayed_threads

Section 5.1.3, “Server System Variables”

max_join_size

Section 4.5.1.1, “mysql Options”
Section 7.8.2, “EXPLAIN Output Format”
Section 12.7.4, “SET Синтаксис”
Section 5.1.3, “Server System Variables”
Section 5.1.4, “Using System Variables”
Section 1.4, “What Is New in MySQL 5.5”

max_length_for_sort_data

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

max_long_data_size

Section 21.9.7.26, “mysql_stmt_send_long_data()”
Section 5.1.3, “Server System Variables”

max_prepared_stmt_count

Section 12.5, “SQL Синтаксис for Prepared Statements”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

max_relay_log_size

Section 15.1.3.4, “Binary Log Options and Variables”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”
Section 15.2.2.1, “The Slave Relay Log”

max_seeks_for_key

Section 13.3.15, “Limits on InnoDB Tables”
Section 5.1.3, “Server System Variables”

max_sort_length

Section 12.1.17, “CREATE TABLE Синтаксис”
Section C.5.8, “Known Issues in MySQL”
Section 5.1.3, “Server System Variables”
Section 10.4.3, “The BLOB and TEXT Types”

max_sp_recursion_depth

Section 5.1.3, “Server System Variables”
Section 18.2.1, “Stored Routine Синтаксис”

max_tmp_tables

Section 5.1.3, “Server System Variables”

max_user_connections

Section 12.7.1.3, “GRANT Синтаксис”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.1.3, “Server System Variables”
Section 5.5.4, “Setting Account Resource Limits”

max_write_lock_count

Section 5.1.3, “Server System Variables”
Section 7.10.2, “Table Locking Issues”

metadata_locks_cache_size

Section 5.1.3, “Server System Variables”

min_examined_row_limit

Section 5.1.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

myisam_data_pointer_size

Section 12.1.17, “CREATE TABLE Синтаксис”
Section E.10.3, “Limits on Table Size”
Section 5.1.3, “Server System Variables”

myisam_max_extra_sort_file_size

Section 5.1.3, “Server System Variables”

myisam_max_sort_file_size

Section 13.5.1, “MyISAM Startup Options”
Section 17.5, “Restrictions and Limitations on Partitioning”
Section 5.1.3, “Server System Variables”
Section 7.6.3, “Speed of REPAIR TABLE Statements”

myisam_mmap_size

Section 5.1.3, “Server System Variables”

myisam_recover_options

Section 5.1.3, “Server System Variables”

myisam_repair_threads

Section 5.1.3, “Server System Variables”

myisam_sort_buffer_size

Section 12.1.7, “ALTER TABLE Синтаксис”
Section 13.5.1, “MyISAM Startup Options”
Section 5.1.3, “Server System Variables”
Section 7.6.3, “Speed of REPAIR TABLE Statements”

myisam_stats_method

Section 7.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section 5.1.3, “Server System Variables”

myisam_use_mmap

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

named_pipe

Section 5.1.3, “Server System Variables”

ndb_autoincrement_prefetch_sz

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_cache_check_time

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_deferred_constraints

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_distribution

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_extra_logging

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_force_send

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_index_stat_cache_entries

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_index_stat_enable

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_index_stat_update_freq

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_join_pushdown

Section 7.8.2, “EXPLAIN Output Format”
Section 16.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”
Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_log_apply_status

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_log_bin

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_log_binlog_index

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_log_empty_epochs

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_log_transaction_id

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_optimized_node_selection

Section 16.3.4.3, “MySQL Cluster System Variables”
Section 16.5.5.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”

ndb_report_thresh_binlog_epoch_slip

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_report_thresh_binlog_mem_usage

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_table_no_logging

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_table_temporary

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_use_copying_alter_table

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_use_exact_count

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_use_transactions

Section 16.3.4.3, “MySQL Cluster System Variables”

ndbinfo_database

Section 16.3.4.3, “MySQL Cluster System Variables”

ndbinfo_max_bytes

Section 16.3.4.3, “MySQL Cluster System Variables”

ndbinfo_max_rows

Section 16.3.4.3, “MySQL Cluster System Variables”

ndbinfo_show_hidden

Section 16.3.4.3, “MySQL Cluster System Variables”

ndbinfo_table_prefix

Section 16.3.4.3, “MySQL Cluster System Variables”

ndbinfo_version

Section 16.3.4.3, “MySQL Cluster System Variables”

net_buffer_length

Section 4.5.1.1, “mysql Options”
Описание
Section 7.11.4.1, “How MySQL Uses Memory”
Section 21.9, “MySQL C API”
Section 5.1.3, “Server System Variables”

net_read_timeout

Section C.5.2.3, “Lost connection to MySQL server”
Section 5.1.3, “Server System Variables”

net_retry_count

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

net_write_timeout

Section 5.1.3, “Server System Variables”

new

Section 5.1.3, “Server System Variables”

old

Section 12.2.9.3, “Index Hint Синтаксис”
Section 5.1.3, “Server System Variables”

old_alter_table

Section 12.1.7, “ALTER TABLE Синтаксис”
Section 5.1.3, “Server System Variables”

old_passwords

Section 5.1.3, “Server System Variables”

one_shot

Section 5.1.3, “Server System Variables”

open_files_limit

Section C.5.2.18, “'File' Not Found and Similar Ошибки”
Section 20.8, “Performance Schema System Variables”
Section 17.5, “Restrictions and Limitations on Partitioning”
Section 5.1.3, “Server System Variables”

optimizer_join_cache_level

Section 5.1.3, “Server System Variables”

optimizer_prune_level

Section 7.8.4.1, “Controlling Query Plan Evaluation”
Section 7.8.4, “Controlling the Query Optimizer”
Section 5.1.3, “Server System Variables”

optimizer_search_depth

Section 7.8.4.1, “Controlling Query Plan Evaluation”
Section 7.8.4, “Controlling the Query Optimizer”
Section 5.1.3, “Server System Variables”

optimizer_switch

Section 7.8.4.2, “Controlling Switchable Optimizations”
Section 7.13.3, “Engine Condition Pushdown Optimization”
Section 5.1.3, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

optimizer_trace

Section 5.1.3, “Server System Variables”

optimizer_trace_features

Section 5.1.3, “Server System Variables”

optimizer_trace_limit

Section 5.1.3, “Server System Variables”

optimizer_trace_max_mem_size

Section 5.1.3, “Server System Variables”

optimizer_trace_offset

Section 5.1.3, “Server System Variables”

performance_schema

Section 20.1, “Performance Schema Quick Start”
Section 20.2.2, “Performance Schema Startup Configuration”
Section 20.8, “Performance Schema System Variables”

performance_schema_accounts_size

Section 20.8, “Performance Schema System Variables”

performance_schema_events_stages_history_long_size

Section 20.8, “Performance Schema System Variables”

performance_schema_events_stages_history_size

Section 20.8, “Performance Schema System Variables”

performance_schema_events_statements_history_long_size

Section 20.8, “Performance Schema System Variables”

performance_schema_events_statements_history_size

Section 20.8, “Performance Schema System Variables”

performance_schema_events_waits_history_long_size

Section 12.7.5.16, “SHOW ENGINE Синтаксис”
Section 20.8, “Performance Schema System Variables”
Section 20.7, “Performance Schema Table Описаниеs”
Section 20.7.3.3, “The events_waits_history_long Table”

performance_schema_events_waits_history_size

Section 12.7.5.16, “SHOW ENGINE Синтаксис”
Section 20.8, “Performance Schema System Variables”
Section 20.7, “Performance Schema Table Описаниеs”
Section 20.7.3.2, “The events_waits_history Table”

performance_schema_hosts_size

Section 20.8, “Performance Schema System Variables”

performance_schema_max_cond_classes

Section 20.8, “Performance Schema System Variables”

performance_schema_max_cond_instances

Section 20.8, “Performance Schema System Variables”

performance_schema_max_file_classes

Section 20.8, “Performance Schema System Variables”

performance_schema_max_file_handles

Section 20.8, “Performance Schema System Variables”

performance_schema_max_file_instances

Section 20.8, “Performance Schema System Variables”

performance_schema_max_mutex_classes

Section 20.5, “Performance Schema Status Monitoring”
Section 20.8, “Performance Schema System Variables”

performance_schema_max_mutex_instances

Section 20.8, “Performance Schema System Variables”

performance_schema_max_rwlock_classes

Section 20.8, “Performance Schema System Variables”

performance_schema_max_rwlock_instances

Section 20.8, “Performance Schema System Variables”

performance_schema_max_socket_classes

Section 20.8, “Performance Schema System Variables”

performance_schema_max_socket_instances

Section 20.8, “Performance Schema System Variables”

performance_schema_max_stage_classes

Section 20.8, “Performance Schema System Variables”

performance_schema_max_statement_classes

Section 20.8, “Performance Schema System Variables”

performance_schema_max_table_handles

Section 20.8, “Performance Schema System Variables”

performance_schema_max_table_instances

Section 20.8, “Performance Schema System Variables”

performance_schema_max_thread_classes

Section 20.8, “Performance Schema System Variables”

performance_schema_max_thread_instances

Section 12.7.5.16, “SHOW ENGINE Синтаксис”
Section 20.8, “Performance Schema System Variables”

performance_schema_setup_actors_size

Section 20.8, “Performance Schema System Variables”

performance_schema_setup_objects_size

Section 20.8, “Performance Schema System Variables”

performance_schema_users_size

Section 20.8, “Performance Schema System Variables”

pid_file

Section 5.1.3, “Server System Variables”

plugin_dir

Section 12.7.3.1, “CREATE FUNCTION Синтаксис for User-Defined Functions”
Section 12.7.3.3, “INSTALL PLUGIN Синтаксис”
Section 12.7.5.26, “SHOW PLUGINS Синтаксис”
Section 5.3.2.1, “Administrator Guidelines for Password Security”
Section 22.2.4.3, “Compiling and Installing Plugin Libraries”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 2.9.2, “Installing MySQL from a Standard Source Distribution”
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 5.5.6.2.1, “Installing the PAM Authentication Plugin”
Section 5.5.6.3.1, “Installing the Windows Authentication Plugin”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 5.5.6, “Pluggable Authentication”
Section 13.2.1, “Pluggable Storage Engine Architecture”
Section 22.2.2, “Plugin API Components”
Section E.9, “Restrictions on Pluggable Authentication”
Section 15.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 19.14, “The INFORMATION_SCHEMA PLUGINS Table”
Section 5.5.6.2, “The PAM Authentication Plugin”
Section 5.5.6.5, “The Socket Peer-Credential Authentication Plugin”
Section 5.5.6.6, “The Test Authentication Plugin”
Section 5.5.6.3, “The Windows Native Authentication Plugin”
Section 7.11.6.1, “Thread Pool Components and Installation”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 22.3.2.6, “User-Defined Function Security Precautions”
Section 22.2.4.9.3, “Using the Authentication Plugins”
Section 22.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
Section 22.2.4.8, “Writing Audit Plugins”
Section 22.2.4.5, “Writing Daemon Plugins”
Section 22.2.4.4, “Writing Full-Text Parser Plugins”
Section 22.2.4.7, “Writing Semisynchronous Replication Plugins”

port

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

preload_buffer_size

Section 5.1.3, “Server System Variables”

prepared_stmt_count

Section 5.1.3, “Server System Variables”

profiling

Section 12.7.5.32, “SHOW PROFILES Синтаксис”
Section 5.1.3, “Server System Variables”
Section 19.16, “The INFORMATION_SCHEMA PROFILING Table”

profiling_history_size

Section 12.7.5.32, “SHOW PROFILES Синтаксис”
Section 5.1.3, “Server System Variables”

protocol_version

Section 5.1.3, “Server System Variables”

proxy_user

Section 5.5.7, “Proxy Users”
Section 5.1.3, “Server System Variables”

pseudo_thread_id

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”

query_alloc_block_size

Section 5.1.3, “Server System Variables”

query_cache_limit

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

query_cache_min_res_unit

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

query_cache_size

Section 7.9.3.3, “Query Cache Configuration”
Section 5.1.3, “Server System Variables”
Section 7.9.3, “The MySQL Query Cache”
Section 5.1.4, “Using System Variables”

query_cache_type

Section 12.2.9, “SELECT Синтаксис”
Section 7.9.3.2, “Query Cache SELECT Options”
Section 7.9.3.3, “Query Cache Configuration”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

query_cache_type=0

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

query_cache_wlock_invalidate

Section 5.1.3, “Server System Variables”

query_prealloc_size

Section 5.1.3, “Server System Variables”

rand_seed1

Section 5.1.3, “Server System Variables”

rand_seed2

Section 5.1.3, “Server System Variables”

range_alloc_block_size

Section 5.1.3, “Server System Variables”

read_buffer_size

Section 7.11.4.1, “How MySQL Uses Memory”
Section 5.1.3, “Server System Variables”
Section 7.6.3, “Speed of REPAIR TABLE Statements”
Section 1.4, “What Is New in MySQL 5.5”

read_only

Section 12.7.1.6, “SET PASSWORD Синтаксис”
Section 5.5.5, “Assigning Account Passwords”
Section 15.3.1.3, “Backing Up a Master or Slave by Making It Read Only”
Section 5.4.1, “Privileges Provided by MySQL”
Section 15.4.1.33, “Replication and Variables”
Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

read_rnd_buffer_size

Section 7.13.9, “ORDER BY Optimization”
Section 7.11.4.1, “How MySQL Uses Memory”
Section 5.1.3, “Server System Variables”
Section 7.11.2, “Tuning Server Parameters”

relay_log_basename

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

relay_log_index

Section 15.1.3.3, “Replication Slave Options and Variables”

relay_log_info_file

Section 15.1.3.3, “Replication Slave Options and Variables”

relay_log_info_repository

Section 15.1.3.4, “Binary Log Options and Variables”

relay_log_purge

Section 12.4.2.1, “CHANGE MASTER TO Синтаксис”
Section 5.1.3, “Server System Variables”

relay_log_recovery

Section 15.1.3.3, “Replication Slave Options and Variables”

relay_log_space_limit

Section 7.12.5.6, “Replication Slave I/O Thread States”
Section 5.1.3, “Server System Variables”

report_host

Section 5.1.3, “Server System Variables”

report_password

Section 5.1.3, “Server System Variables”

report_port

Section 5.1.3, “Server System Variables”

report_user

Section 5.1.3, “Server System Variables”

rpl_recovery_rank

Section 15.1.3.3, “Replication Slave Options and Variables”

rpl_semi_sync_master_enabled

Section 15.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 15.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 15.3.8.3, “Semisynchronous Replication Monitoring”
Section 5.1.3, “Server System Variables”

rpl_semi_sync_master_timeout

Section 15.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 15.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.3, “Server System Variables”

rpl_semi_sync_master_trace_level

Section 5.1.3, “Server System Variables”

rpl_semi_sync_master_wait_no_slave

Section 5.1.3, “Server System Variables”

rpl_semi_sync_slave_enabled

Section 15.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 15.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.3, “Server System Variables”

rpl_semi_sync_slave_trace_level

Section 5.1.3, “Server System Variables”

secure_auth

Section 5.1.3, “Server System Variables”

secure_file_priv

Section 12.2.6, “LOAD DATA INFILE Синтаксис”
Section 12.2.9.1, “SELECT ... INTO Синтаксис”
Section 5.1.3, “Server System Variables”
Section 11.5, “String Functions”

server_id

Section 12.7.5.35, “SHOW SLAVE STATUS Синтаксис”
Описание
Section 11.15, “Miscellaneous Functions”
Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 16.3.4.3, “MySQL Cluster System Variables”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 5.1.3, “Server System Variables”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”

server_id_bits

Section 16.3.4.3, “MySQL Cluster System Variables”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

server_uuid

Section 12.7.5.35, “SHOW SLAVE STATUS Синтаксис”
Section 15.1.3, “Replication and Binary Logging Options and 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.10.5, “External Locking”
Section 5.1.3, “Server System Variables”

skip_name_resolve

Section 5.1.3, “Server System Variables”

skip_networking

Section 5.1.3, “Server System Variables”

skip_show_database

Section 5.1.3, “Server System Variables”

slave_allow_batching

Section 16.3.4.3, “MySQL Cluster System Variables”
Section 16.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”

slave_compressed_protocol

Section 15.1.3.3, “Replication Slave Options and Variables”

slave_exec_mode

Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 16.6.10, “MySQL Cluster Replication: Multi-Master and Circular Replication”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”

slave_exec_mode=IDEMPOTENT

Section 15.4.1.18, “Replication and MEMORY Tables”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”

slave_load_tmpdir

Section 12.2.6, “LOAD DATA INFILE Синтаксис”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

slave_net_timeout

Section 12.4.2.1, “CHANGE MASTER TO Синтаксис”
Section 15.1.4.1, “Checking Replication Status”
Section 7.12.5.6, “Replication Slave I/O Thread States”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.4.1.16, “Replication and Master or Slave Shutdowns”
Section 5.1.3, “Server System Variables”

slave_parallel_workers

Section 12.7.5.35, “SHOW SLAVE STATUS Синтаксис”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

slave_skip_errors

Section 15.1.3.3, “Replication Slave Options and Variables”

slave_sql_verify_checksum

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

slave_transaction_retries

Section 15.4.1.26, “Replication Retries and Timeouts”
Section 15.1.3.3, “Replication Slave Options and Variables”

slave_type_conversions

Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 15.1.3.3, “Replication Slave Options and Variables”

slow_launch_time

Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

slow_query_log

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

slow_query_log_file

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

socket

Section 5.1.3, “Server System Variables”

sort_buffer_size

Section 7.13.9, “ORDER BY Optimization”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 7.2.1.3, “Optimizing LIMIT Queries”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

sql_auto_is_null

Section 11.3.2, “Comparison Functions and Operators”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 5.2.4, “The Binary Log”

sql_auto_is_null = 0

Section 11.3.2, “Comparison Functions and Operators”

sql_big_selects

Section 5.1.3, “Server System Variables”

sql_buffer_result

Section 5.1.3, “Server System Variables”

sql_log_bin

Section 12.4.1.3, “SET sql_log_bin Синтаксис”
Section 16.1.6.8, “Issues Exclusive to MySQL Cluster”
Section 16.1.6.1, “Noncompliance with SQL Синтаксис in MySQL Cluster”
Section 5.1.3, “Server System Variables”
Section 15.4.3, “Upgrading a Replication Setup”

sql_log_bin = 0

Section 16.6.3, “Known Issues in MySQL Cluster Replication”

sql_log_off

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.2.6, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 5.2.3, “The General Query Log”

sql_log_update

Section 5.1.3, “Server System Variables”

sql_mode

Section 12.1.11, “CREATE EVENT Синтаксис”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 12.1.19, “CREATE TRIGGER Синтаксис”
Section 12.7.5.14, “SHOW CREATE VIEW Синтаксис”
Section 12.7.5.39, “SHOW TRIGGERS Синтаксис”
Section 12.6.7.4.2, “Effect of Signals on Handlers, Cursors, and Statements”
Section 11.18.3, “Expression Handling”
Section 1.7, “How to Report Bugs or Problems”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section C.5.5.2, “Problems Using DATE Columns”
Section 15.4.1.33, “Replication and Variables”
Section 1.8.3, “Running MySQL in ANSI Mode”
Section 1.8.2, “Selecting SQL Modes”
Section 5.1.6, “Server SQL Modes”
Section 5.1.3, “Server System Variables”
Section 19.18, “The INFORMATION_SCHEMA ROUTINES Table”
Section 19.26, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.28, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”
Section 5.1.4, “Using System Variables”

sql_notes

Section 12.7.5.41, “SHOW WARNINGS Синтаксис”
Section 5.1.3, “Server System Variables”

sql_quote_show_create

Section 12.7.5.8, “SHOW CREATE DATABASE Синтаксис”
Section 12.7.5.12, “SHOW CREATE TABLE Синтаксис”
Section 5.1.3, “Server System Variables”

sql_safe_updates

Section 5.1.3, “Server System Variables”

sql_select_limit

Section 5.1.3, “Server System Variables”

sql_slave_skip_counter

Section 12.4.2.4, “SET GLOBAL sql_slave_skip_counter Синтаксис”
Section 12.7.5.35, “SHOW SLAVE STATUS Синтаксис”
Section 15.1.3.3, “Replication Slave Options and Variables”

sql_warnings

Section 5.1.3, “Server System Variables”

ssl_ca

Section 5.1.3, “Server System Variables”

ssl_capath

Section 5.1.3, “Server System Variables”

ssl_cert

Section 5.1.3, “Server System Variables”

ssl_cipher

Section 5.1.3, “Server System Variables”

ssl_crl

Section 5.1.3, “Server System Variables”

ssl_crlpath

Section 5.1.3, “Server System Variables”

ssl_key

Section 5.1.3, “Server System Variables”

storage_engine

Section 12.1.14, “CREATE LOGFILE GROUP Синтаксис”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 13.1, “Setting the Storage Engine”
Глава 13, Storage Engines
Section 15.3.2, “Using Replication with Different Master and Slave Storage Engines”
Section 1.4, “What Is New in MySQL 5.5”

sync_binlog

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 15.1.3.4, “Binary Log Options and Variables”
Section 7.5.7, “Optimizing InnoDB Disk I/O”
Section 5.2.4, “The Binary Log”

sync_binlog=1

Section 15.4.1.16, “Replication and Master or Slave Shutdowns”

sync_frm

Section 5.1.3, “Server System Variables”

sync_master_info

Section 15.1.3.3, “Replication Slave Options and Variables”

sync_relay_log

Section 15.1.3.3, “Replication Slave Options and Variables”

sync_relay_log_info

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.4.1.16, “Replication and Master or Slave Shutdowns”

sync_relay_log_info=1

Section 15.4.1.16, “Replication and Master or Slave Shutdowns”

system_time_zone

Section 9.6, “MySQL Server Time Zone Support”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

table_cache

Section C.5.2.18, “'File' Not Found and Similar Ошибки”
Section 7.12.5.2, “General Thread States”
Section 7.4.3.1, “How MySQL Opens and Closes Tables”
Section 7.11.4.1, “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.11.2, “Tuning Server Parameters”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

table_definition_cache

Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

table_lock_wait_timeout

Section 5.1.3, “Server System Variables”

table_open_cache

Section C.5.2.18, “'File' Not Found and Similar Ошибки”
Section 7.12.5.2, “General Thread States”
Section 7.4.3.1, “How MySQL Opens and Closes Tables”
Section 7.11.4.1, “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.11.2, “Tuning Server Parameters”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

table_type

Section 5.1.3, “Server System Variables”
Глава 13, Storage Engines
Section 15.3.2, “Using Replication with Different Master and Slave Storage Engines”
Section 1.4, “What Is New in MySQL 5.5”

thread_cache_size

Section 22.5.1.4, “Debugging mysqld under gdb”
Section 7.11.5.1, “How MySQL Uses Threads for Client Connections”
Section 7.2.5, “Other Optimization Tips”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

thread_concurrency

Section 5.1.3, “Server System Variables”

thread_handling

Section 5.1.3, “Server System Variables”
Section 7.11.6.1, “Thread Pool Components and Installation”

thread_pool_algorithm

Section 5.1.3, “Server System Variables”
Section 19.30.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 7.11.6.1, “Thread Pool Components and Installation”

thread_pool_high_priority_connection

Section 5.1.3, “Server System Variables”
Section 7.11.6.1, “Thread Pool Components and Installation”
Section 7.11.6.2, “Thread Pool Operation”

thread_pool_max_unused_threads

Section 5.1.3, “Server System Variables”
Section 7.11.6.1, “Thread Pool Components and Installation”

thread_pool_prio_kickup_timer

Section 5.1.3, “Server System Variables”
Section 19.30.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 19.30.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
Section 7.11.6.1, “Thread Pool Components and Installation”
Section 7.11.6.2, “Thread Pool Operation”
Section 7.11.6.3, “Thread Pool Tuning”

thread_pool_size

Section 5.1.3, “Server System Variables”
Section 7.11.6.1, “Thread Pool Components and Installation”
Section 7.11.6.2, “Thread Pool Operation”
Section 7.11.6.3, “Thread Pool Tuning”

thread_pool_stall_limit

Section 5.1.3, “Server System Variables”
Section 19.30.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 19.30.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
Section 7.11.6.1, “Thread Pool Components and Installation”
Section 7.11.6.2, “Thread Pool Operation”
Section 7.11.6.3, “Thread Pool Tuning”

thread_stack

Section 7.11.4.1, “How MySQL Uses Memory”
Section 5.1.3, “Server System Variables”
Section 18.2.1, “Stored Routine Синтаксис”

time_format

Section 5.1.3, “Server System Variables”

time_zone

Section 12.1.11, “CREATE EVENT Синтаксис”
Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.7, “Date and Time Functions”
Section 18.4.4, “Event Metadata”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 9.6, “MySQL Server Time Zone Support”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

timed_mutexes

Section 12.7.5.16, “SHOW ENGINE Синтаксис”
Section 5.1.3, “Server System Variables”

timestamp

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”

timestamp = {timestamp_value | DEFAULT}

Section 5.1.3, “Server System Variables”

tmp_table_size

Section 7.4.3.3, “How MySQL Uses Internal Temporary Tables”
Section E.3, “Restrictions on Server-Side Cursors”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

tmpdir

Section C.5.2.13, “Can't create/write to file”
Section 12.2.6, “LOAD DATA INFILE Синтаксис”
Section 7.13.9, “ORDER BY Optimization”
Section 15.3.1.2, “Backing Up Raw Data from a Slave”
Section 6.2, “Database Backup Methods”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

transaction_alloc_block_size

Section 5.1.3, “Server System Variables”

transaction_allow_batching

Section 16.3.4.3, “MySQL Cluster System Variables”

transaction_prealloc_size

Section 5.1.3, “Server System Variables”

tx_isolation

Section 12.3.6, “SET TRANSACTION Синтаксис”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

unique_checks

Section 13.3.5.2, “Converting Tables from Other Storage Engines to InnoDB”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 5.2.4, “The Binary Log”

updatable_views_with_limit

Section 5.1.3, “Server System Variables”
Section 18.5.3, “Updatable and Insertable Views”

version

Section 11.14, “Information Functions”
Section 5.1.3, “Server System Variables”

version_bdb

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”

wait_timeout

Section C.5.2.9, “MySQL server has gone away”
Section 21.9.3.52, “mysql_real_connect()”
Section C.5.2.11, “Communication Ошибки and Aborted Connections”
Section 5.1.3, “Server System Variables”

warning_count

Section 12.7.5.18, “SHOW ERRORS Синтаксис”
Section 12.7.5.41, “SHOW WARNINGS Синтаксис”
Section 12.6.7.4.2, “Effect of Signals on Handlers, Cursors, and Statements”
Section 5.1.3, “Server System Variables”
Section C.1, “Sources of Error Information”
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices
   
Statement/Syntax Index Начало 
    Поддержать сайт на родительском проекте КГБ