A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W
autocommit
- Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
- Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
- Section C.4.32, “Changes in MySQL/InnoDB-3.23.52, August 16, 2002”
- Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
- Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
- Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
- Section C.4.26, “Changes in MySQL/InnoDB-4.0.6, December 19, 2002”
- Section C.4.10, “Changes in MySQL/InnoDB-4.1.1, December 4, 2003”
- Section C.3.44, “Changes in Release 3.23.17 (07 June 2000)”
- Section C.3.40, “Changes in Release 3.23.21 (04 July 2000)”
- Section C.3.5, “Changes in Release 3.23.55 (23 January 2003)”
- Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
- Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
- Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
- Section 13.2.9.8, “Deadlock Detection and Rollback”
- Section 12.2.1, “DELETE Syntax”
- Section 13.2.9.9, “How to Cope with Deadlocks”
- Section 13.2.4, “InnoDB Startup Options and System Variables”
- Section 12.3.5.1, “Interaction of Table Locking and Transactions”
- Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
- Section 13.2.15, “Restrictions on InnoDB Tables”
- Section 13.2.9.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”
- Section 5.1.3, “Server System Variables”
- Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
- Section 1.9.5.4, “Transactions and Atomic Operations”
- Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
character_set_connection
- Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
- Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
- Section 9.1.3.5, “Character String Literal Character Set and Collation”
- Section 9.1.7.4, “Collations Must Be for the Right Character Set”
- Section 9.1.4, “Connection Character Sets and Collations”
- Section 9.1.8.2, “CONVERT() and CAST()”
- Section 11.7, “Date and Time Functions”
- Section 9.8, “MySQL Server Locale Support”
- Section 9.1.8.1, “Result Strings”
- Section 5.1.3, “Server System Variables”
- Section 12.4.4, “SET Syntax”
- Section 8.1.1, “String Literals”
collation_connection
- Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
- Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
- Section 9.1.3.5, “Character String Literal Character Set and Collation”
- Section 9.1.7.4, “Collations Must Be for the Right Character Set”
- Section 9.1.4, “Connection Character Sets and Collations”
- Section 9.1.8.2, “CONVERT() and CAST()”
- Section 11.7, “Date and Time Functions”
- Section 9.1.8.1, “Result Strings”
- Section 5.1.3, “Server System Variables”
- Section 12.4.4, “SET Syntax”
innodb_additional_mem_pool_size
- Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
- Section C.4.4, “Changes in MySQL/InnoDB-4.1.2, May 30, 2004”
- Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”
- Section 13.2.4, “InnoDB Startup Options and System Variables”
innodb_data_file_path
- Section 13.2.6, “Adding, Removing, or Resizing InnoDB Data and Log Files”
- Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
- Section 13.2.3.4, “Dealing with InnoDB Initialization Problems”
- Section 13.2.3, “InnoDB Configuration”
- Section 13.2.2, “InnoDB in MySQL 3.23”
- Section 13.2.4, “InnoDB Startup Options and System Variables”
- Chapter 13, Storage Engines
- Section 5.2, “The mysqld-max Extended MySQL Server”
- Section 13.2.3.2, “Using Raw Devices for the Shared Tablespace”
innodb_file_per_table
- Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
- Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
- Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
- Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
- Section C.4.4, “Changes in MySQL/InnoDB-4.1.2, May 30, 2004”
- Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”
- Section 13.2.3.3, “Creating the InnoDB Tablespace”
- Section 13.2.5.5, “InnoDB and MySQL Replication”
- Section 13.2.4, “InnoDB Startup Options and System Variables”
- Section 13.2.14.2.2, “InnoDB Tablespace Monitor Output”
- Section 13.2.13.2, “Operating System Error Codes”
- Section 13.2.14.4, “Troubleshooting InnoDB Data Dictionary Operations”
- Section 13.2.3.1, “Using Per-Table Tablespaces”
innodb_flush_log_at_trx_commit
- Section C.4.15, “Changes in MySQL/InnoDB-3.23.57, June 20, 2003”
- Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”
- Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
- Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
- Section 13.2.14.1, “InnoDB Performance Tuning Tips”
- Section 13.2.4, “InnoDB Startup Options and System Variables”
innodb_force_recovery
- Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
- Section C.4.29, “Changes in MySQL/InnoDB-3.23.53, October 9, 2002”
- Section C.4.30, “Changes in MySQL/InnoDB-4.0.4, October 2, 2002”
- Section C.4.28, “Changes in MySQL/InnoDB-4.0.5, November 18, 2002”
- Section C.3.16, “Changes in Release 3.23.44 (31 October 2001)”
- Section 13.2.7.2, “Forcing InnoDB Recovery”
- Section 1.8, “How to Report Bugs or Problems”
- Section 13.2.4, “InnoDB Startup Options and System Variables”
innodb_locks_unsafe_for_binlog
- Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
- Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
- Section C.1.1, “Changes in MySQL 4.1.25 (2008-12-01)”
- Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
- Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”
- Section 13.2.9.4, “InnoDB Record, Gap, and Next-Key Locks”
- Section 13.2.4, “InnoDB Startup Options and System Variables”
key_buffer_size
- Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
- Section 7.2.3, “Estimating Query Performance”
- Section 7.8.4, “How MySQL Uses Memory”
- Section 6.6.3, “How to Repair MyISAM Tables”
- Section 7.5.1.2, “Multiple Key Caches”
- Section B.5.8.4, “Open Issues in MySQL”
- Section 7.5.1.6, “Restructuring a Key Cache”
- Section 5.1.2, “Server Command Options”
- Section 5.1.5, “Server Status Variables”
- Section 5.1.3, “Server System Variables”
- Section 7.3.2.3, “Speed of DELETE Statements”
- Section 7.3.2.1, “Speed of INSERT Statements”
- Section 7.3.2.4, “Speed of REPAIR TABLE Statements”
- Section 5.1.4.1, “Structured System Variables”
- Section 7.5.1, “The MyISAM Key Cache”
- Section 7.8.2, “Tuning Server Parameters”
- Section 4.2.3.3, “Using Option Files”
lower_case_table_names
- Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
- Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
- Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
- Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
- Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
- Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
- Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
- Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
- Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
- Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
- Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
- Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
- Section 13.2.5.4, “FOREIGN KEY Constraints”
- Section 12.4.1.2, “GRANT Syntax”
- Section 14.9, “How Servers Evaluate Replication Filtering Rules”
- Section 1.8, “How to Report Bugs or Problems”
- Section 8.2.2, “Identifier Case Sensitivity”
- Section 14.7.20, “Replication and Variables”
- Section 12.4.1.3, “REVOKE Syntax”
- Section 5.1.3, “Server System Variables”
max_allowed_packet
- Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
- Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
- Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
- Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
- Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
- Section C.2.24, “Changes in Release 4.0.8 (07 January 2003)”
- Section B.5.2.11, “Communication Errors and Aborted Connections”
- Section 11.3.2, “Comparison Functions and Operators”
- Section B.5.5.6, “Deleting Rows from Related Tables”
- Section 11.15.1, “GROUP BY (Aggregate) Functions”
- Section 7.8.4, “How MySQL Uses Memory”
- Section B.5.2.3, “Lost connection to MySQL server”
- Section 17.6, “MySQL C API”
- Section B.5.2.9, “MySQL server has gone away”
- Section 17.6.6.69, “mysql_use_result()”
- Section B.5.2.10, “Packet Too Large”
- Section 5.1.3, “Server System Variables”
- Section 11.5, “String Functions”
- Section 10.4.3, “The BLOB and TEXT Types”
- Section 4.2.3.3, “Using Option Files”
max_connections
- Section B.5.2.18, “'File' Not Found and Similar Errors”
- Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
- Section 18.4.1.3, “Debugging mysqld under gdb”
- Section 7.7.2, “How MySQL Opens and Closes Tables”
- Section 7.8.3, “How MySQL Uses Threads for Client Connections”
- Section 2.12.1.4, “Linux Postinstallation Notes”
- Section 5.5.1, “Privileges Provided by MySQL”
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- Section B.5.2.7, “Too many connections”
sql_mode
- Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
- Section C.1.21, “Changes in MySQL 4.1.5 (2004-09-16)”
- Section 1.8, “How to Report Bugs or Problems”
- Section 14.7.3, “Replication and DIRECTORY Table Options”
- Section 14.7.20, “Replication and Variables”
- Section 1.9.3, “Running MySQL in ANSI Mode”
- Section 1.9.2, “Selecting SQL Modes”
- Section 5.1.6, “Server SQL Modes”
- Section 5.1.3, “Server System Variables”
- Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”
- Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
- Section 5.1.4, “Using System Variables”