| Index Entry | Section |
|---|
|
| Q | | |
|---|
| queries, entering | 3.2 Entering Queries |
| queries, estimating performance | 5.2.2 Estimating Query Performance |
| queries, examples | 3.6 Examples of Common Queries |
| queries, speed of | 5.2 Optimising SELECTs and Other Queries |
| queries, Twin Studies project | 3.7 Queries from the Twin Project |
| Query Cache | 6.9 MySQL Query Cache |
| query log | 4.9.2 The General Query Log |
| questions | 4.8.3 mysqladmin, Administrating a MySQL Server |
| questions, answering | 1.6.1.4 Guidelines for Answering Questions on the Mailing List |
| quick, mysql option | 4.8.2 mysql, The Command-line Tool |
| quotes, in strings | 6.1.1.1 Strings |
| quoting | 6.1.1.1 Strings |
| quoting binary data | 6.1.1.1 Strings |
| quoting strings | 9.5.2 The DBI Interface |
|
| R | | |
|---|
| RAID, compile errors | 2.3.5 Problems Compiling MySQL? |
| RAID, table type | 6.5.3 CREATE TABLE Syntax |
| raw, mysql option | 4.8.2 mysql, The Command-line Tool |
| re-creating, grant tables | 4.3.4 Setting Up the Initial MySQL Privileges |
| reconfiguring | 2.3.5 Problems Compiling MySQL? |
| reconfiguring | 2.3.5 Problems Compiling MySQL? |
| reconnect, mysql option | 4.8.2 mysql, The Command-line Tool |
| recovery, from crash | 4.4.6.7 Using myisamchk for Crash Recovery |
| reducing, data size | 5.4.2 Get Your Data as Small as Possible |
| references | 6.5.4 ALTER TABLE Syntax |
| regex | G. MySQL Regular Expressions |
| regular expression syntax, described | G. MySQL Regular Expressions |
| relational databases, defined | 1.2 What Is MySQL? |
| release numbers | 2.2.4 Which MySQL Version to Use |
| releases, naming scheme | 2.2.4 Which MySQL Version to Use |
| releases, testing | 2.2.4 Which MySQL Version to Use |
| releases, updating | 2.2.6 How and When Updates Are Released |
| reordering, columns | A.7.2 How To Change the Order of Columns in a Table |
| repair options, myisamchk | 4.4.6.4 Repair Options for myisamchk |
| repairing, tables | 4.4.6.9 How to Repair Tables |
| replace | 4.8.1 Overview of the Client-Side Scripts and Utilities |
| replication | 4.10 Replication in MySQL |
| replication, commands | 4.10.7 SQL Commands Related to Replication |
| reporting, bugs | 1.6.1.3 How to Report Bugs or Problems |
| reporting, errors | 1. General Information |
| reporting, errors | 1.6.1 MySQL Mailing Lists |
| reporting, MyODBC problems | 9.2.7 Reporting Problems with MyODBC |
| reserved words, exceptions | 6.1.7 Is MySQL Picky About Reserved Words? |
| restarting, the server | 2.4 Post-installation Setup and Testing |
| retrieving, data from tables | 3.3.4 Retrieving Information from a Table |
| return values, UDFs | 12.2.2.4 Return Values and Error Handling |
| revoking, privileges | 4.3.1 GRANT and REVOKE Syntax |
| root password | 4.3.4 Setting Up the Initial MySQL Privileges |
| root user, password resetting | A.4.2 How to Reset a Forgotten Root Password |
| rounding errors | 6.2 Column Types |
| rounding errors | 6.3.3.2 Mathematical Functions |
| rows, counting | 3.3.4.8 Counting Rows |
| rows, deleting | A.5.5 Deleting Rows from Related Tables |
| rows, locking | 1.7.4.3 Transactions and Atomic Operations |
| rows, matching problems | A.5.6 Solving Problems with No Matching Rows |
| rows, selecting | 3.3.4.2 Selecting Particular Rows |
| rows, sorting | 3.3.4.4 Sorting Rows |
| RPM file | 2.1.2 Installing MySQL on Linux |
| RPM Package Manager | 2.1.2 Installing MySQL on Linux |
| RTS-threads | E.5 Comments about RTS threads |
| running a web server | 1.4.3.2 Using the MySQL Software for Free Under GPL |
| running configure after prior invocation | 2.3.5 Problems Compiling MySQL? |
| running, ANSI mode | 1.7.2 Running MySQL in ANSI Mode |
| running, batch mode | 3.5 Using mysql in Batch Mode |
| running, multiple servers | 4.1.3 Running Multiple MySQL Servers on the Same Machine |
| running, queries | 3.2 Entering Queries |
|
| S | | |
|---|
| safe-mode command | 4.8.2 mysql, The Command-line Tool |
| safe-updates, mysql option | 4.8.2 mysql, The Command-line Tool |
| safe_mysqld | 4.7.2 mysqld_safe, The Wrapper Around mysqld |
| Sakila | 1.2.1 History of MySQL |
| script files | 3.5 Using mysql in Batch Mode |
| scripts | 4.7.2 mysqld_safe, The Wrapper Around mysqld |
| scripts | 4.7.3 mysqld_multi, A Program for Managing Multiple MySQL Servers |
| scripts | 4.8.2 mysql, The Command-line Tool |
| scripts, mysql_install_db | 2.4.1 Problems Running mysql_install_db |
| scripts, mysqlbug | 1.6.1.3 How to Report Bugs or Problems |
| searching, and case-sensitivity | A.5.1 Case-Sensitivity in Searches |
| searching, full-text | 6.8 MySQL Full-text Search |
| searching, MySQL web pages | 1.6.1.2 Asking Questions or Reporting Bugs |
| searching, two keys | 3.6.7 Searching on Two Keys |
| security system | 4.2 General Security Issues and the MySQL Access Privilege System |
| security, against crackers | 4.2.2 How to Make MySQL Secure Against Crackers |
| SELECT, Query Cache | 6.9 MySQL Query Cache |
| select_limit | 4.8.2 mysql, The Command-line Tool |
| selecting, databases | 3.3.1 Creating and Selecting a Database |
| selling products | 1.4.3 MySQL Licenses |
| sequence emulation | 6.3.6.2 Miscellaneous Functions |
| server administration | 4.8.3 mysqladmin, Administrating a MySQL Server |
| server, connecting | 3.1 Connecting to and Disconnecting from the Server |
| server, connecting | 4.2.8 Connecting to the MySQL Server |
| server, debugging | E.1 Debugging a MySQL server |
| server, disconnecting | 3.1 Connecting to and Disconnecting from the Server |
| server, restart | 2.4 Post-installation Setup and Testing |
| server, shutdown | 2.4 Post-installation Setup and Testing |
| server, starting | 2.4 Post-installation Setup and Testing |
| server, starting and stopping | 2.4.3 Starting and Stopping MySQL Automatically |
| server, starting problems | 2.4.2 Problems Starting the MySQL Server |
| servers, multiple | 4.1.3 Running Multiple MySQL Servers on the Same Machine |
| services, ISP | 1.4.3.2 Using the MySQL Software for Free Under GPL |
| services, web | 1.4.3.2 Using the MySQL Software for Free Under GPL |
| SET, size | Storage Requirements for String Types |
| set-variable, mysql option | 4.8.2 mysql, The Command-line Tool |
| setting, passwords | 4.3.7 Setting Up Passwords |
| setup, post-installation | 2.4 Post-installation Setup and Testing |
| shell syntax | 1.1.1 Conventions Used in This Manual |
| showing, database information | 4.8.9 mysqlshow, Showing Databases, Tables, and Columns |
| shutting down, the server | 2.4 Post-installation Setup and Testing |
| silent column changes | 6.5.3.1 Silent Column Specification Changes |
| silent, mysql option | 4.8.2 mysql, The Command-line Tool |
| size of tables | 1.2.4 How Big Can MySQL Tables Be? |
| sizes, display | 6.2 Column Types |
| skip-column-names, mysql option | 4.8.2 mysql, The Command-line Tool |
| skip-line-numbers, mysql option | 4.8.2 mysql, The Command-line Tool |
| slow queries | 4.8.3 mysqladmin, Administrating a MySQL Server |
| slow query log | 4.9.5 The Slow Query Log |
| socket location, changing | 2.3.3 Typical configure Options |
| socket, mysql option | 4.8.2 mysql, The Command-line Tool |
| Solaris installation problems | 2.6.3 Solaris Notes |
| Solaris troubleshooting | 2.3.5 Problems Compiling MySQL? |
| sorting, character sets | 4.6.1 The Character Set Used for Data and Sorting |
| sorting, data | 3.3.4.4 Sorting Rows |
| sorting, grant tables | 4.2.9 Access Control, Stage 1: Connection Verification |
| sorting, grant tables | 4.2.10 Access Control, Stage 2: Request Verification |
| sorting, table rows | 3.3.4.4 Sorting Rows |
| source distribution, installing | 2.3 Installing a MySQL Source Distribution |
| Spatial Extensions in MySQL | 11.1 Introduction |
| speed, compiling | 5.5.3 How Compiling and Linking Affects the Speed of MySQL |
| speed, increasing | 4.10 Replication in MySQL |
| speed, inserting | 5.2.10 Speed of INSERT Queries |
| speed, linking | 5.5.3 How Compiling and Linking Affects the Speed of MySQL |
| speed, of queries | 5.2 Optimising SELECTs and Other Queries |
| speed, of queries | 5.2.3 Speed of SELECT Queries |
| SQL commands, replication | 4.10.7 SQL Commands Related to Replication |
| SQL, defined | 1.2 What Is MySQL? |
| SQL-92, extensions to | 1.7 MySQL Standards Compliancy |
| sql_yacc.cc problems | 2.3.5 Problems Compiling MySQL? |
| square brackets | 6.2 Column Types |
| SSH | 2.6.1.4 Connecting to MySQL Remotely from Windows with SSH |
| SSL and X509 Basics | 4.3.9 Using Secure Connections |
| SSL related options | 4.3.9.4 GRANT Options |
| stability | 1.2.3 How Stable Is MySQL? |
| Standard SQL, differences from | 4.3.1 GRANT and REVOKE Syntax |
| standards compatibility | 1.7 MySQL Standards Compliancy |
| Starting many servers | 4.1.3 Running Multiple MySQL Servers on the Same Machine |
| starting, comments | 1.7.4.7 `--' as the Start of a Comment |
| starting, mysqld | A.3.2 How to Run MySQL As a Normal User |
| starting, the server | 2.4 Post-installation Setup and Testing |
| starting, the server automatically | 2.4.3 Starting and Stopping MySQL Automatically |
| startup options, default | 4.1.2 `my.cnf' Option Files |
| startup parameters | 5.5.2 Tuning Server Parameters |
| startup parameters, mysql | 4.8.2 mysql, The Command-line Tool |
| startup parameters, tuning | 5.5.1 System/Compile Time and Startup Parameter Tuning |
| statically, compiling | 2.3.3 Typical configure Options |
| status command | 4.8.2 mysql, The Command-line Tool |
| status command, results | 4.8.3 mysqladmin, Administrating a MySQL Server |
| status, tables | 4.5.7.2 SHOW TABLE STATUS |
| stopping, the server | 2.4.3 Starting and Stopping MySQL Automatically |
| storage of data | 5.4.1 Design Choices |
| storage requirements, column type | 6.2.6 Column Type Storage Requirements |
| storage space, minimising | 5.4.2 Get Your Data as Small as Possible |
| stored procedures and triggers, defined | 1.7.4.4 Stored Procedures and Triggers |
| string collating | 4.6.5 String Collating Support |
| string comparisons, case-sensitivity | 6.3.2.1 String Comparison Functions |
| string types | 6.2.3 String Types |
| strings, defined | 6.1.1 Literals: How to Write Strings and Numbers |
| strings, escaping characters | 6.1.1 Literals: How to Write Strings and Numbers |
| strings, non-delimited | 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types |
| strings, quoting | 9.5.2 The DBI Interface |
| striping, defined | 5.6 Disk Issues |
| subqueries | 1.7.4.1 Subqueries |
| subselects | 1.7.4.1 Subqueries |
| superuser | 4.3.4 Setting Up the Initial MySQL Privileges |
| support costs | 1.4.1 Support Offered by MySQL AB |
| support terms | 1.4 MySQL Support and Licensing |
| support, for operating systems | 2.2.3 Operating Systems Supported by MySQL |
| support, licensing | 1.4.3 MySQL Licenses |
| support, mailing address | 1.6.1.3 How to Report Bugs or Problems |
| support, types | 1.4.1 Support Offered by MySQL AB |
| suppression, default values | 1.7.5.2 Constraint NOT NULL and DEFAULT values |
| suppression, default values | 2.3.3 Typical configure Options |
| Sybase compatibility | 6.6.1 USE Syntax |
| symbolic links | 2.6.1.5 Distributing Data Across Different Disks on Windows |
| symbolic links | 5.6.1 Using Symbolic Links |
| syntax, regular expression | G. MySQL Regular Expressions |
| system optimisation | 5.5.1 System/Compile Time and Startup Parameter Tuning |
| system table | 5.2.1 EXPLAIN Syntax (Get Information About a SELECT) |
| system variables | 6.1.5 System Variables |
| system, privilege | 4.2.5 What the Privilege System Does |
| system, security | 4.2 General Security Issues and the MySQL Access Privilege System |
|
