MySQL 5.0 Reference Manual  /  Command Index

Command Index

Symbols | A | B | C | D | E | F | G | H | I | K | L | M | N | O | P | R | S | T | U | V | W | X | Y | Z

Symbols

[index top]

A

[index top]

B

[index top]

C

[index top]

configure

Section 10.3, “Adding a Character Set”
Section 2.20.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 2.20.4.4, “BSD/OS Version 2.x Notes”
Section 2.20.4.6, “BSD/OS Version 4.x Notes”
Section 17.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 6.3.6.2, “Building MySQL with Support for Secure Connections”
Section B.5.2.17, “Can't initialize character set”
Section 2.17.5, “Compiling and Linking an Optimized mysqld Server”
Section 21.3.1.1, “Compiling MySQL for Debugging”
Section 2.17.4, “Dealing with Problems Compiling MySQL”
Section 21.3, “Debugging and Porting MySQL”
Section 2.21, “Environment Variables”
Section B.5.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 1.7, “How to Report Bugs or Problems”
Section 2.20.5.1, “HP-UX Version 10.20 Notes”
Section 2.20.5.2, “HP-UX Version 11.x Notes”
Section 2.20.5.3, “IBM-AIX notes”
Section 14.5.2, “Installing BDB”
Section 15.3.1, “Installing memcached
Section 2.17, “Installing MySQL from Source”
Section 2.17.2, “Installing MySQL Using a Development Source Tree”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section 20.5, “libmysqld, the Embedded MySQL Server Library”
Section 2.20.1.7, “Linux Alpha Notes”
Section 2.20.1.10, “Linux IA-64 Notes”
Section 2.20.1.3, “Linux Source Distribution Notes”
Section 2.20.1.5, “Linux x86 Notes”
Section 17.5.4, “MySQL Server Usage for MySQL Cluster”
Section 2.17.3, “MySQL Source-Configuration Options”
Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 2.20.2.1, “OS X 10.x (Darwin)”
Section 5.5.3, “Running Multiple MySQL Instances on Unix”
Section 2.20.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.20.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.4, “Server System Variables”
Section 2.20.5.7, “SGI Irix Notes”
Section 2.20.3.1, “Solaris 2.7/2.8 Notes”
Section 2.20.3, “Solaris Notes”
Section 2.20.3.2, “Solaris x86 Notes”
Section 2.20.5.4, “SunOS 4 Notes”
Section 14.8, “The ARCHIVE Storage Engine”
Section 14.10, “The BLACKHOLE Storage Engine”
Section 14.9, “The CSV Storage Engine”
Section 14.6, “The EXAMPLE Storage Engine”
Section 14.7, “The FEDERATED Storage Engine”
Section 14.1, “The MyISAM Storage Engine”
Section 8.10.3, “The MySQL Query Cache”
Section 1.2, “Typographical and Syntax Conventions”
Section 21.2.2.5, “UDF Compiling and Installing”
Section 15.3.3.3, “Using libmemcached with C and C++”
Section 15.3.3.6, “Using MySQL and memcached with PHP”
Section 4.2.6, “Using Option Files”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

D

[index top]

E

[index top]

F

[index top]

G

[index top]

H

[index top]

I

[index top]

K

[index top]

L

[index top]

M

[index top]

memcached

Section 15.3.3.1, “Basic memcached Operations”
Section 15.3.2.3, “Data Expiry”
Section 15.1.3, “Deploying a MySQL Database Using EC2”
Section 15.3.3, “Developing a memcached Application”
Section 15.3.4, “Getting memcached Statistics”
Section 15.3.1, “Installing memcached
Section 15.3.3.3.6, “libmemcached Command-Line Utilities”
Section 15.3.3.3.3, “libmemcached Set Functions”
Section 15.3.2.1, “memcached Deployment”
Section 15.3.4.5, “memcached Detail Statistics”
Section 15.3.5, “memcached FAQ”
Section 15.3.4.1, “memcached General Statistics”
Section 15.3.2.4, “memcached Hashing/Distribution Types”
Section 15.3.4.3, “memcached Item Statistics”
Section 15.3.2.8, “memcached Logs”
Section 15.3.4.4, “memcached Size Statistics”
Section 15.3.4.2, “memcached Slabs Statistics”
Section 15.3.2.7, “memcached Thread Support”
Section 15.3.2.6, “Memory Allocation within memcached
Section 15.1.1, “Setting Up MySQL on an EC2 AMI”
Section 15.3.3.3, “Using libmemcached with C and C++”
Section 15.3.2, “Using memcached
Section 15.3.2.5, “Using memcached and DTrace”
Section 15.3.3.2, “Using memcached as a MySQL Caching Layer”
Section 15.3.4.6, “Using memcached-tool
Section 15.3.3.8, “Using MySQL and memcached with Java”
Section 15.3.3.4, “Using MySQL and memcached with Perl”
Section 15.3.3.6, “Using MySQL and memcached with PHP”
Section 15.3.3.5, “Using MySQL and memcached with Python”
Section 15.3.3.7, “Using MySQL and memcached with Ruby”
Section 15.3, “Using MySQL with memcached
Section 15.3.2.2, “Using Namespaces”
Section 15.3.3.9, “Using the memcached TCP Text Protocol”

memcached-1.2.5 directory:

Section 15.3.1, “Installing memcached

myisamchk

Section 13.7.2.1, “ANALYZE TABLE Syntax”
Section 8.5.2, “Bulk Data Loading for MyISAM Tables”
Section 10.5, “Character Set Configuration”
Section 13.7.2.3, “CHECK TABLE Syntax”
Section 2.10.2.1.2, “Choosing an Installation Type”
Section 14.1.3.3, “Compressed Table Characteristics”
Section 14.1.4.1, “Corrupted MyISAM Tables”
Section 7.2, “Database Backup Methods”
Section 21.3.1, “Debugging a MySQL Server”
Section 13.2.2, “DELETE Syntax”
Section 14.1.3.2, “Dynamic Table Characteristics”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.11.4, “External Locking”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 2.15, “Installing MySQL on NetWare”
Section C.7.3, “Limits on Table Size”
Section 13.7.6.4, “LOAD INDEX INTO CACHE Syntax”
Section 21.3.1.7, “Making a Test Case If You Experience Table Corruption”
Section 8.3.7, “MyISAM Index Statistics Collection”
Section 14.1.1, “MyISAM Startup Options”
Section 7.6, “MyISAM Table Maintenance and Crash Recovery”
Section 7.6.4, “MyISAM Table Optimization”
Section 14.1.3, “MyISAM Table Storage Formats”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 8.5.1, “Optimizing MyISAM Queries”
Section 4.6.3.4, “Other myisamchk Options”
Section 4.1, “Overview of MySQL Programs”
Section 14.1.4.2, “Problems from Tables Not Being Closed Properly”
Section 13.7.2.6, “REPAIR TABLE Syntax”
Section 5.1.3, “Server Command Options”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 13.7.5.18, “SHOW INDEX Syntax”
Section 13.7.5.33, “SHOW TABLE STATUS Syntax”
Section 8.5.3, “Speed of REPAIR TABLE Statements”
Section 14.1.3.1, “Static (Fixed-Length) Table Characteristics”
Section 8.12.1, “System Factors and Startup Parameter Tuning”
Section 1.3.2, “The Main Features of MySQL”
Section 14.1, “The MyISAM Storage Engine”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 21.3.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 8.12.4.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

mysql

Section 1.8.2.5, “'--' as the Start of a Comment”
Section 6.3.2, “Adding User Accounts”
Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 14.2.6, “Backing Up and Recovering an InnoDB Database”
Section 7.1, “Backup and Recovery Types”
Section 13.6.1, “BEGIN ... END Compound-Statement Syntax”
Section 2.10.2.1.5, “Changes Made by MySQL Installation Wizard”
Section 2.10.2.1.2, “Choosing an Installation Type”
Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 9.6, “Comment Syntax”
Section 6.3.6.4, “Configuring MySQL to Use Secure Connections”
Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 4.6.10.6, “Connecting to MySQL Instance Manager”
Section 4.2.2, “Connecting to the MySQL Server”
Section 10.1.4, “Connection Character Sets and Collations”
Section 1.9.1, “Contributors to MySQL”
Section 20.6.15, “Controlling Automatic Reconnection Behavior”
Section 2.19.5, “Copying MySQL Databases to Another Machine”
Section 13.1.9, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 3.3.1, “Creating and Selecting a Database”
Section 2.10.4.6, “Customizing the PATH for MySQL Tools”
Section 21.3.2, “Debugging a MySQL Client”
Section 18.1, “Defining Stored Programs”
Section 2.2, “Determining Your Current MySQL Version”
Section 4.5.1.6.4, “Disabling mysql Auto-Reconnect”
Section 2.19.2, “Downgrading MySQL”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 3.2, “Entering Queries”
Section 2.21, “Environment Variables”
Section 7.3, “Example Backup and Recovery Strategy”
Section 20.6.3, “Example C API Client Programs”
Section 3.6, “Examples of Common Queries”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Chapter 12, Functions and Operators
Section 13.7.1.3, “GRANT Syntax”
Section 13.8.3, “HELP Syntax”
Section 14.2.8.9, “How to Cope with Deadlocks”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 1.7, “How to Report Bugs or Problems”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section B.5.2.15, “Ignoring user”
Section 12.13, “Information Functions”
Section 14.2.1.1, “Initializing InnoDB”
Section 4.5.1.6.1, “Input-Line Editing”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 2.11, “Installing MySQL on OS X”
Section 4.2.1, “Invoking MySQL Programs”
Section 17.1.5.8, “Issues Exclusive to MySQL Cluster”
Section B.5.7, “Known Issues in MySQL”
Section 8.2.1.15, “LIMIT Query Optimization”
Section 13.4.2.2, “LOAD DATA FROM MASTER Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.4.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 4.4.2, “make_win_bin_dist — Package MySQL Distribution as Zip Archive”
Section 7.4.5.1, “Making a Copy of a Database”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 8.13.1, “Measuring the Speed of Expressions and Functions”
Section A.11, “MySQL 5.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section A.10, “MySQL 5.0 FAQ: MySQL Cluster”
Section 17.3, “MySQL Cluster Configuration”
Section 17.2.4, “MySQL Cluster Example with Tables and Data”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 10.6, “MySQL Server Time Zone Support”
Section 17.5.4, “MySQL Server Usage for MySQL Cluster”
Section 4.5.1.4, “mysql Server-Side Help”
Section 2.17.3, “MySQL Source-Configuration Options”
Section 4.5.1.6, “mysql Tips”
Section 4.5.1, “mysql — The MySQL Command-Line Tool”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 20.6.7.14, “mysql_errno()”
Section 4.4.5, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”
Section 20.6.7.66, “mysql_sqlstate()”
Section 4.4.8, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 17.4.3, “ndb_mgm — The MySQL Cluster Management Client”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.5.2.8, “Out of memory”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.10, “Packet Too Large”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 4.2.5, “Program Option Modifiers”
Section 2.19.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.4, “Reloading Delimited-Text Format Backups”
Section 7.4.2, “Reloading SQL-Format Backups”
Section B.5.3.2.3, “Resetting the Root Password: Generic Instructions”
Section 13.7.1.5, “REVOKE Syntax”
Section 2.18.4, “Securing the Initial MySQL Accounts”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 13.2.8.1, “SELECT ... INTO Syntax”
Section 5.1.3, “Server Command Options”
Section B.3, “Server Error Codes and Messages”
Section 5.1.4, “Server System Variables”
Section 5.1.8, “Server-Side Help”
Section 14.2.13.1, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 13.7.5.31, “SHOW SLAVE STATUS Syntax”
Section 13.7.5.37, “SHOW WARNINGS Syntax”
Section 4.2.3, “Specifying Program Options”
Section 13.5, “SQL Syntax for Prepared Statements”
Section 2.10.4.7, “Starting MySQL as a Windows Service”
Section 2.10.3.1, “Starting the MySQL Server Instance Configuration Wizard”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 2.18.2, “Starting the Server”
Section 9.1.1, “String Literals”
Section 2.10.8.4, “Testing a Windows Source Build”
Section 2.18.3, “Testing the Server”
Section 11.4.3, “The BLOB and TEXT Types”
Section 18.3.1, “Trigger Syntax and Examples”
Section 14.2.13.3, “Troubleshooting InnoDB Data Dictionary Operations”
Section 6.2.7, “Troubleshooting Problems Connecting to MySQL”
Chapter 3, Tutorial
Section 1.2, “Typographical and Syntax Conventions”
Section 7.3.2, “Using Backups for Recovery”
Section 3.5, “Using mysql in Batch Mode”
Section 7.4, “Using mysqldump for Backups”
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”
Section 4.2.8, “Using Options to Set Program Variables”
Section 21.3.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 4.5.1.6.3, “Using the --safe-updates Option”
Section 2.10.6, “Windows Postinstallation Procedures”

mysql-test-run.pl test_name

Section 21.1.2, “The MySQL Test Suite”

mysqladmin

Section 6.3.5, “Assigning Account Passwords”
Section 16.3.1.1, “Backing Up a Slave Using mysqldump”
Section 2.20.4.6, “BSD/OS Version 4.x Notes”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 1.9.1, “Contributors to MySQL”
Section 13.1.6, “CREATE DATABASE Syntax”
Section 2.10.4.6, “Customizing the PATH for MySQL Tools”
Section 21.3.1, “Debugging a MySQL Server”
Section 13.1.13, “DROP DATABASE Syntax”
Section 20.6.3, “Example C API Client Programs”
Section 13.7.6.2, “FLUSH Syntax”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 2.14, “Installing MySQL on i5/OS”
Section 2.15, “Installing MySQL on NetWare”
Section 2.11, “Installing MySQL on OS X”
Section A.11, “MySQL 5.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.4, “MySQL Server Logs”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.1, “Overview of MySQL Programs”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.5.3, “Running Multiple MySQL Instances on Unix”
Section 2.18.4, “Securing the Initial MySQL Accounts”
Section 2.10.4.7, “Starting MySQL as a Windows Service”
Section 2.10.4.5, “Starting MySQL from the Windows Command Line”
Section 2.18.3, “Testing the Server”
Section 1.3.2, “The Main Features of MySQL”
Section 5.1.10, “The Server Shutdown Process”
Section 8.12.2, “Tuning Server Parameters”
Section 2.10.7, “Upgrading MySQL on Windows”
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

mysqladmin processlist status

Section 21.3.1, “Debugging a MySQL Server”

mysqladmin variables extended-status processlist

Section 1.7, “How to Report Bugs or Problems”

mysqld

Section 21.2.2, “Adding a New User-Defined Function”
Section 21.2, “Adding New Functions to MySQL”
Section 2.20.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 14.2.6, “Backing Up and Recovering an InnoDB Database”
Section 14.5.3, “BDB Startup Options”
Section 16.1.2.4, “Binary Log Options and Variables”
Section 2.20.4.5, “BSD/OS Version 3.x Notes”
Section 2.20.4.6, “BSD/OS Version 4.x Notes”
Section 17.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 2.10.8.1, “Building MySQL from the Standard Source Distribution”
Section 6.3.6.2, “Building MySQL with Support for Secure Connections”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section B.5.2.13, “Can't create/write to file”
Section B.5.2.17, “Can't initialize character set”
Section 2.19.1.1, “Changes Affecting Upgrades to 5.0”
Section 14.2.4, “Changing the Number or Size of InnoDB Redo Log Files”
Section 14.5.4, “Characteristics of BDB Tables”
Section 2.4.2.2, “Choosing a Distribution Format”
Section B.5.2.4, “Client does not support authentication protocol”
Section 17.5.2, “Commands in the MySQL Cluster Management Client”
Section 9.6, “Comment Syntax”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 2.17.5, “Compiling and Linking an Optimized mysqld Server”
Section 21.3.1.1, “Compiling MySQL for Debugging”
Section 14.2.1, “Configuring InnoDB”
Section 14.1.4.1, “Corrupted MyISAM Tables”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-defined Functions”
Section 13.1.12, “CREATE VIEW Syntax”
Section 21.3.1.2, “Creating Trace Files”
Section 14.2.1.2, “Dealing with InnoDB Initialization Problems”
Section 2.17.4, “Dealing with Problems Compiling MySQL”
Section 21.3.1, “Debugging a MySQL Server”
Section 21.3, “Debugging and Porting MySQL”
Section 21.3.1.4, “Debugging mysqld under gdb”
Section 17.3.3.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 2.3.1, “Enterprise Server Distribution Types”
Section 2.21, “Environment Variables”
Section 14.5.6, “Errors That May Occur When Using BDB Tables”
Section 8.11.4, “External Locking”
Section B.5.2.18, “File Not Found and Similar Errors”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 13.7.6.2, “FLUSH Syntax”
Section 14.2.6.2, “Forcing InnoDB Recovery”
Section 2.20.4.1, “FreeBSD Notes”
Section 8.14.2, “General Thread States”
Section 15.2.3, “Handling MySQL Recovery with ZFS”
Section B.5.2.6, “Host 'host_name' is blocked”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.12.5.1, “How MySQL Uses Memory”
Section 8.2.1.17, “How to Avoid Full Table Scans”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 2.20.5.3, “IBM-AIX notes”
Section 9.2.2, “Identifier Case Sensitivity”
Section B.5.2.15, “Ignoring user”
Section 12.13, “Information Functions”
Section 17.2.2, “Initial Configuration of MySQL Cluster”
Section 17.2.3, “Initial Startup of MySQL Cluster”
Section 14.2.1.1, “Initializing InnoDB”
Section 2.18.1, “Initializing the Data Directory”
Section 14.2.11.1, “InnoDB Disk I/O”
Section 14.2.1.4, “InnoDB File-Per-Table Tablespaces”
Section 14.2.13.2, “InnoDB General Troubleshooting”
Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 2.7, “Installation Layouts”
Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 17.2.1, “Installing MySQL Cluster on Linux”
Section 2.14, “Installing MySQL on i5/OS”
Section 2.12, “Installing MySQL on Linux Using RPM Packages”
Section 2.11, “Installing MySQL on OS X”
Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section 17.1.5.8, “Issues Exclusive to MySQL Cluster”
Section 13.7.6.3, “KILL Syntax”
Section B.5.7, “Known Issues in MySQL”
Section 2.20.1.7, “Linux Alpha Notes”
Section 2.20.1.2, “Linux Binary Distribution Notes”
Section 2.20.1.1, “Linux Operating System Notes”
Section 2.20.1.4, “Linux Postinstallation Notes”
Section 2.20.1.3, “Linux Source Distribution Notes”
Section 2.20.1.5, “Linux x86 Notes”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 21.3.1.7, “Making a Test Case If You Experience Table Corruption”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 14.1.1, “MyISAM Startup Options”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section A.1, “MySQL 5.0 FAQ: General”
Section A.11, “MySQL 5.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section A.10, “MySQL 5.0 FAQ: MySQL Cluster”
Section A.3, “MySQL 5.0 FAQ: Server SQL Mode”
Section 17.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 17.3, “MySQL Cluster Configuration”
Section 17.3.3.1, “MySQL Cluster Configuration: Basic Example”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.2, “MySQL Cluster Installation and Upgrades”
Section 17.3.2.5, “MySQL Cluster mysqld Option and Variable Reference”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.4, “MySQL Cluster Programs”
Section 17.3.3.7.2, “MySQL Cluster System Variables”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
Chapter 5, MySQL Server Administration
Section 4.3, “MySQL Server and Server-Startup Programs”
Section B.5.2.9, “MySQL server has gone away”
Section 5.4, “MySQL Server Logs”
Section 10.6, “MySQL Server Time Zone Support”
Section 17.5.4, “MySQL Server Usage for MySQL Cluster”
Section 2.17.3, “MySQL Source-Configuration Options”
Section 1.8, “MySQL Standards Compliance”
Section 21.1.1, “MySQL Threads”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 20.6.7.1, “mysql_affected_rows()”
Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”
Section 20.6.7.49, “mysql_options()”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 17.3.3.7.1, “mysqld Command Options for MySQL Cluster”
Section 4.3.1, “mysqld — The MySQL Server”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 17.4.17, “ndb_show_tables — Display List of NDB Tables”
Section 14.5.1, “Operating Systems Supported by BDB”
Section 13.7.2.5, “OPTIMIZE TABLE Syntax”
Section B.5.5, “Optimizer-Related Issues”
Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 2.20.2.1, “OS X 10.x (Darwin)”
Section 17.3.2, “Overview of MySQL Cluster Configuration Parameters, Options, and Variables”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.10, “Packet Too Large”
Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”
Section 14.1.4.2, “Problems from Tables Not Being Closed Properly”
Section 2.18.1.1, “Problems Running mysql_install_db”
Section B.5.3.1, “Problems with File Permissions”
Section 4.2.5, “Program Option Modifiers”
Section 8.10.3.3, “Query Cache Configuration”
Section 16.1.2.1, “Replication and Binary Logging Option and Variable Reference”
Section 16.1.2, “Replication and Binary Logging Options and Variables”
Section 16.1.2.2, “Replication Master Options and Variables”
Section B.5.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section B.5.3.2.1, “Resetting the Root Password: Windows Systems”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 14.5.5, “Restrictions on BDB Tables”
Section B.5.4.5, “Rollback Failure for Nontransactional Tables”
Section 5.5, “Running Multiple MySQL Instances on One Machine”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 6.1.4, “Security-Related mysqld Options and Variables”
Section 13.2.8.1, “SELECT ... INTO Syntax”
Section 2.10.4.3, “Selecting a MySQL Server Type”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server Command Options”
Section 5.1.9, “Server Response to Signals”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 10.2, “Setting the Error Message Language”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 2.20.5.7, “SGI Irix Notes”
Section 14.2.13.1, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 20.6.2, “Simultaneous MySQL Server and Connector/C Installations”
Section 2.20.3, “Solaris Notes”
Section 2.20.3.2, “Solaris x86 Notes”
Section 2.18.5, “Starting and Stopping MySQL Automatically”
Section 5.5.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.5.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.10.4.7, “Starting MySQL as a Windows Service”
Section 2.10.4.5, “Starting MySQL from the Windows Command Line”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 10.6.1, “Staying Current with Time Zone Changes”
Section 2.20.5.4, “SunOS 4 Notes”
Section 1.9.5, “Supporters of MySQL”
Section 16.3.6, “Switching Masters During Failover”
Section 8.11.2, “Table Locking Issues”
Section B.5.2.19, “Table-Corruption Issues”
Section 2.10.8.4, “Testing a Windows Source Build”
Section 2.10.4.8, “Testing The MySQL Installation”
Section 2.18.3, “Testing the Server”
Section 5.4.3, “The Binary Log”
Section 14.10, “The BLACKHOLE Storage Engine”
Section 5.4.1, “The Error Log”
Section 5.4.2, “The General Query Log”
Section 14.1, “The MyISAM Storage Engine”
Section 8.10.3, “The MySQL Query Cache”
Section 5.1, “The MySQL Server”
Section 21.1.2, “The MySQL Test Suite”
Section 5.4.4, “The Slow Query Log”
Section B.5.3.7, “Time Zone Problems”
Section B.5.2.7, “Too many connections”
Section 2.10.5, “Troubleshooting a MySQL Installation Under Windows”
Section 6.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 2.18.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 8.12.2, “Tuning Server Parameters”
Section 1.2, “Typographical and Syntax Conventions”
Section 21.2.2.5, “UDF Compiling and Installing”
Section 21.2.2.6, “UDF Security Precautions”
Section 2.19.1, “Upgrading MySQL”
Section 2.10.7, “Upgrading MySQL on Windows”
Section 21.3.1.5, “Using a Stack Trace”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 4.2.6, “Using Option Files”
Section 21.3.1.3, “Using pdb to create a Windows crashdump”
Section 21.3.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 8.12.4.3, “Using Symbolic Links for Databases on Windows”
Section 8.12.4.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section 17.1.4, “What is New in MySQL Cluster”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”
Section 6.2.6, “When Privilege Changes Take Effect”
Section B.5.3.5, “Where MySQL Stores Temporary Files”

mysqld_safe

Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 2.19.1.1, “Changes Affecting Upgrades to 5.0”
Section 21.3.1.1, “Compiling MySQL for Debugging”
Section 8.12.5.2, “Enabling Large Page Support”
Section B.5.2.18, “File Not Found and Similar Errors”
Section 2.20.4.1, “FreeBSD Notes”
Section B.5.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 2.20.5.3, “IBM-AIX notes”
Section 14.2.1.1, “Initializing InnoDB”
Section 14.2.13.2, “InnoDB General Troubleshooting”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 2.14, “Installing MySQL on i5/OS”
Section 2.15, “Installing MySQL on NetWare”
Section 2.11, “Installing MySQL on OS X”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section B.5.7, “Known Issues in MySQL”
Section 2.20.1.4, “Linux Postinstallation Notes”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section A.10, “MySQL 5.0 FAQ: MySQL Cluster”
Section 17.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 10.6, “MySQL Server Time Zone Support”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.10, “Packet Too Large”
Section B.5.3.1, “Problems with File Permissions”
Section 5.5, “Running Multiple MySQL Instances on One Machine”
Section 5.5.3, “Running Multiple MySQL Instances on Unix”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.18.5, “Starting and Stopping MySQL Automatically”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 2.18.2, “Starting the Server”
Section 2.18.3, “Testing the Server”
Section 5.4.1, “The Error Log”
Section B.5.3.7, “Time Zone Problems”
Section 2.18.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 8.12.2, “Tuning Server Parameters”
Section 21.2.2.5, “UDF Compiling and Installing”
Section 4.2.6, “Using Option Files”

mysqldump

Section 16.3.1.1, “Backing Up a Slave Using mysqldump”
Section 14.2.6, “Backing Up and Recovering an InnoDB Database”
Chapter 7, Backup and Recovery
Section 7.1, “Backup and Recovery Types”
Section 7.3.3, “Backup Strategy Summary”
Section 13.7.2.2, “BACKUP TABLE Syntax”
Section 8.6.4, “Bulk Data Loading for InnoDB Tables”
Section 2.19.2.1, “Changes Affecting Downgrades from MySQL 5.0”
Section 2.19.1.1, “Changes Affecting Upgrades to 5.0”
Section 2.19.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 2.10.2.1.2, “Choosing an Installation Type”
Section 4.2.2, “Connecting to the MySQL Server”
Section 1.9.1, “Contributors to MySQL”
Section 7.4.5.2, “Copy a Database from one Server to Another”
Section 2.19.5, “Copying MySQL Databases to Another Machine”
Section 13.1.8, “CREATE INDEX Syntax”
Section 13.1.12, “CREATE VIEW Syntax”
Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 2.10.4.6, “Customizing the PATH for MySQL Tools”
Section 7.2, “Database Backup Methods”
Section 12.17.2, “DECIMAL Data Type Characteristics”
Section 14.2.11.3, “Defragmenting a Table”
Section 2.19.2, “Downgrading MySQL”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 7.4.5.3, “Dumping Stored Programs”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 15.1.2, “EC2 Instance Limitations”
Section 14.5.6, “Errors That May Occur When Using BDB Tables”
Section 7.3.1, “Establishing a Backup Policy”
Section 7.3, “Example Backup and Recovery Strategy”
Section 1.7, “How to Report Bugs or Problems”
Section 16.1.1, “How to Set Up Replication”
Section 9.2.2, “Identifier Case Sensitivity”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 13.4.2.2, “LOAD DATA FROM MASTER Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.4.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 7.4.5.1, “Making a Copy of a Database”
Section 14.2.7, “Moving an InnoDB Database to Another Machine”
Section A.10, “MySQL 5.0 FAQ: MySQL Cluster”
Section 17.2.4, “MySQL Cluster Example with Tables and Data”
Section 17.1, “MySQL Cluster Overview”
Section 4.5.1.1, “mysql Options”
Section 5.4, “MySQL Server Logs”
Section 7.4.5, “mysqldump Tips”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 17.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 11.1.1, “Numeric Type Overview”
Section 16.1.1.4, “Obtaining the Replication Master Binary Log Coordinates”
Section 17.5.3, “Online Backup of MySQL Cluster”
Section 4.1, “Overview of MySQL Programs”
Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”
Section B.5.4.8, “Problems with Floating-Point Values”
Section 2.19.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.4, “Reloading Delimited-Text Format Backups”
Section 7.4.2, “Reloading SQL-Format Backups”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 14.2.5, “Resizing the InnoDB System Tablespace”
Section 14.5.5, “Restrictions on BDB Tables”
Section C.4, “Restrictions on Views”
Section 5.4.5, “Server Log Maintenance”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 16.1.1.8, “Setting Up Replication with Existing Data”
Section B.5.4.7, “Solving Problems with No Matching Rows”
Section 4.2.3, “Specifying Program Options”
Section 2.10.4.7, “Starting MySQL as a Windows Service”
Section 2.10.3.1, “Starting the MySQL Server Instance Configuration Wizard”
Section 11.4.3, “The BLOB and TEXT Types”
Section 8.10.2, “The InnoDB Buffer Pool”
Section 1.3.2, “The Main Features of MySQL”
Section 10.6.2, “Time Zone Leap Second Support”
Section 6.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 17.2.6, “Upgrading and Downgrading MySQL Cluster”
Section 2.19.1, “Upgrading MySQL”
Section 13.1.10.3, “Using FOREIGN KEY Constraints”
Section 7.4, “Using mysqldump for Backups”
Section 16.3.1, “Using Replication for Backups”
Section 16.3.2, “Using Replication with Different Master and Slave Storage Engines”
Section 11.3.4, “YEAR(2) Limitations and Migrating to YEAR(4)”

N

[index top]

ndbd

Section 17.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 17.5.2, “Commands in the MySQL Cluster Management Client”
Section 17.3.3.5, “Defining MySQL Cluster Data Nodes”
Section 17.2.3, “Initial Startup of MySQL Cluster”
Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 17.2.1, “Installing MySQL Cluster on Linux”
Section 17.1.5.9, “Limitations Relating to Multiple MySQL Cluster Nodes”
Section 17.5, “Management of MySQL Cluster”
Section A.10, “MySQL 5.0 FAQ: MySQL Cluster”
Section 17.3.3.1, “MySQL Cluster Configuration: Basic Example”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.2, “MySQL Cluster Installation and Upgrades”
Section 17.3.4.2, “MySQL Cluster Interconnects and Performance”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.4, “MySQL Cluster Programs”
Section 17.3.3.7.1, “mysqld Command Options for MySQL Cluster”
Section 17.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 17.4.19, “ndb_waiter — Wait for MySQL Cluster to Reach a Given Status”
Section 17.4.1, “ndbd — The MySQL Cluster Data Node Daemon”
Section 17.3.2, “Overview of MySQL Cluster Configuration Parameters, Options, and Variables”
Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”
Section 17.1.5.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”
Section 17.3.1, “Quick Test Setup of MySQL Cluster”
Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
Section 17.3.3.11, “SCI Transport Connections in MySQL Cluster”
Section 17.5.1, “Summary of MySQL Cluster Start Phases”
Section 17.5.6.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
Section 17.3.4, “Using High-Speed Interconnects with MySQL Cluster”

O

[index top]

P

[index top]

R

[index top]

S

[index top]

T

[index top]

U

[index top]

V

[index top]

W

[index top]

X

[index top]

Y

[index top]

Z

[index top]


User Comments
Sign Up Login You must be logged in to post a comment.