index_S

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [Y] [Z]

saving
    queries
         in Query window (MySQL Query Browser)
scalar subqueries 2nd
     column comparisons 2nd
         ALL keywords 2nd
         ANY keywords 2nd 3rd
         EXISTS keywords 2nd
         IN keywords 2nd
         NOT IN keywords
         SOME keywords
     CONCAT() functions
scaling MySQL
    multiple server management
         data directories 2nd 3rd
         external locking
         InnoDB tablespace files
         log files
         MySQL Instance Manager
         network interfaces 2nd 3rd
         unique service names 2nd
    replication
         binary logs
         CHANGE MASTER statements
         configuring 2nd 3rd
         configuring, slave requirements
         configuring, unique server ID values 2nd
         master/slave architectures 2nd
         master/slave architectures, slave requirements
         master/slave compatibility 2nd
         relay logs 2nd
         replication threads 2nd 3rd
         server upgrades
         START SLAVE statements
         troubleshooting 2nd
schemas [See databases]
Script Editor (MySQL Query Browser)
script files
     error statements
    processing
         via command-line
         via SOURCE command
Search button (MySQL Query Browser Result Area)
searches
     FULLTEXT indexes
security
    database administration
         stored routines 2nd 3rd 4th
         triggers
     FEDERATED tables 2nd
     filesystems 2nd 3rd
         log files
         risks to 2nd
     grant tables, flushing
     log files
    MySQL installation
         secure installation conditions 2nd
         Windows security measures
     MySQL Server 2nd
     network interfaces, restricting
     networks
         deleting anonymous accounts
         granting user privileges
         MySQL Cluster
         risks to
         root accounts
         user access 2nd 3rd
     operating systems 2nd
         risks to
     passwords 2nd 3rd
         root accounts
     root accounts
    SQL mode
         ERROR FOR DIVISION BY ZERO mode
         Strict mode
         TRADITIONAL mode 2nd
     stored routine privileges 2nd
    upgrades
         grant tables
         privilege tables 2nd
         SQL mode values 2nd 3rd
    user accounts
         deleting anonymous accounts
         granting privileges to
         network access 2nd 3rd
SELECT INTO OUTFILE statements 2nd 3rd
     data file format specifiers 2nd 3rd 4th
     FIELDS clauses
     LINES clauses 2nd
     NULL values 2nd
     text backups 2nd
SELECT INTO statements
     store routines, assigning variable values in
SELECT privilege
     trigger column references
SELECT privileges
     user account management
SELECT statements
     AVG() aggregate functions 2nd
     column aliases 2nd
     COUNT() aggregate functions 2nd 3rd
     data retrieval 2nd
         aggregating results 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
         column retrieval 2nd 3rd 4th 5th
         concatenating row results 2nd 3rd
         grouping results 2nd 3rd 4th 5th 6th
         grouping results, multilevel summary values 2nd 3rd 4th
         grouping results, selecting groups 2nd 3rd
         grouping results, sorting 2nd
         row retrieval 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th
     DISTINCT clauses 2nd 3rd 4th
     FOR UPDATE statements modifiers
    FROM clauses
         subqueries 2nd
     GROUP BY clauses 2nd 3rd 4th 5th
     GROUP CONCAT() aggregate functions 2nd 3rd 4th
     GROUP CONCAT() functions 2nd 3rd
     HAVING clauses 2nd 3rd
     HIGH PRIORITY clauses
    joins
         overview of 2nd
     LIMIT clauses 2nd 3rd
     LOCK IN SHARE MODE statements modifiers 2nd
     MAX() aggregate functions 2nd 3rd
     MIN() aggregate functions 2nd 3rd
     ORDER BY clauses 2nd 3rd 4th 5th 6th
     SUM() aggregate functions 2nd
     syntax of
     UNION keyword 2nd 3rd
     user variables
     WHERE clauses
         row retrieval
select type output columns (EXPLAIN statements)
selecting
    rows
         limiting selections (data retrieval) 2nd 3rd
SERIALIZABLE isolation levels (InnoDB storage engines) 2nd
server
    internal temporary tables
         MySQL Server memory usage
Server (MySQL) 2nd
server (mysql)
    client/server architectures
         client connection methods 2nd
         communication protocols 2nd
         operational overview 2nd 3rd
         optimizers
         SQL parsers
         storage engine tiers 2nd
Server (MySQL)
    data directory
         database directories
         frm files 2nd
         InnoDB storage engine tablespaces/log files
         server log files
         status files
         storage engine data/index files
     disk space usage 2nd
    logs
         benefits of 2nd
         binary 2nd
         error 2nd
         general query
         slow query
    manual operation
         in Windows
    memory usage
         buffers
         buffers, grant table buffers
         buffers, InnoDB storage engine log buffers
         buffers, key buffers 2nd
         buffers, MEMORY storage engine tables
         buffers, mysql client connection buffers
         caches
         caches, host caches
         caches, query caches
         caches, table caches
         server internal temporary tables
         thread handlers
     mysqladmin extended-status command-line utility
     mysqladmin variables command-line utility
    optimizing
         configuring memory parameters
         configuring memory parameters, global parameters 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
         configuring memory parameters, per-client parameters 2nd 3rd
         interpreting server information 2nd 3rd 4th 5th 6th 7th 8th 9th
         measuring server load status 2nd
         query cache
         query cache, determining utilization of 2nd 3rd
         query cache, enabling 2nd 3rd
     runtime configurations
         option file search order 2nd
         specifying options 2nd 3rd 4th 5th
     security configurations 2nd
     server load status, measuring 2nd 3rd
     SET statements
     SHOW PROCESSLIST statements
     SHOW STATUS statements
         LIKE clauses
     SHOW VARIABLES statements
         LIKE clauses 2nd
     SQL mode
         ANSI mode
         ANSI QUOTES mode
         checking
         clearing
         composite modes 2nd
         ERROR FOR DIVISION BY ZERO mode
         IGNORE SPACE mode
         setting, multiple mode names
         setting, single mode values
         STRICT ALL TABLES mode 2nd
         STRICT TRANS TABLES mode 2nd
         TRADITIONAL mode
     SQL mode, setting 2nd
    starting/stopping
         Unix startup methods 2nd
         Unix startup prerequisites 2nd 3rd
         Windows startup prerequisites 2nd
     status files
    status variables
         Key read requests
         Key reads
         Opened tables
         Qcache hits
         Qcache inserts
         Qcache lowmem prunes
         Qcache queries in cache
         Threads connected
     status variables, Bytes received
     status variables, Bytes sent
     status variables, Com
     status variables, Com select
     status variables, displaying 2nd 3rd
     status variables, measuring server load status 2nd 3rd
     status variables, Opened tables
     status variables, Questions
     status variables, Slow queries 2nd
     status variables, Uptime
     status variables, uses of
    system variables
         innodb buffer pool size
         innodb log buffer size
         join buffer size
         key buffer size 2nd
         max connections
         query cache limit
         query cache min res unit
         query cache size
         query cache type 2nd 3rd
         query cache wlock invalidate
         read buffer size
         sort buffer size
         table cache
     system variables, displaying 2nd 3rd
     system variables, setting 2nd
         global variables
         session variables 2nd
     time zone tables, loading 2nd
     Windows service, operating as 2nd 3rd
Server Connections section (MySQL Administrator)
Server Information section (MySQL Administrator) 2nd
server log files
     MySQL Server storage
Server Logs section (MySQL Administrator) 2nd
server-side help
     mysql client, accessing from 2nd 3rd
server-wide parameters (MySQL Server)
     configuring
         InnoDB buffer pools 2nd
         InnoDB log buffers
         maximum connections allowed
         MyISAM key caches 2nd 3rd
         storage engine selections
         table caches 2nd
servers
     --log-queries-not-using-indexes option
    client access control
         --skip-grant-tables option
         connection request checks 2nd 3rd
         disalbing
         FLUSH PRIVILEGES statements
         FLUSH STATEMENT statements
         grant tables, Host values
         grant tables, User values 2nd
         resource limit checks 2nd
         stages of 2nd
         statement privilege checks
    client program connection information options
         --password 2nd
         --user
     client program connection options
         --host 2nd 3rd
         --port 2nd
         --protocol 2nd 3rd 4th
         --shared-memory-base-name 2nd
         --socket 2nd
         specifying
     graphical client/server connections
    ID values
         server replication configuration 2nd
    log files
         determining potential queries for optimization
    multiple server management
         data directories 2nd 3rd 4th
         external locking
         log files
         MySQL Instance Manager
         network interfaces 2nd 3rd
         unique service names 2nd
     MySQL Administrator connections
     MySQL Query Browser connections
     mysqld 2nd
     mysqld-debug
     mysqld-max
     mysqld-max-nt
     mysqld-nt 2nd
     network interfaces, restricting
    performance
         key caches
    replication
         backups
         binary logs
         CHANGE MASTER statements
         configuring 2nd 3rd
         configuring, slave requirements
         configuring, unique server ID values 2nd
         master/slave architectures 2nd
         master/slave architectures, slave requirements
         master/slave compatibility 2nd
         relay logs 2nd
         replication threads 2nd 3rd
         server upgrades
         START SLAVE statements
         troubleshooting 2nd
    storage engines
         compiling
         viewing availability 2nd
    transaction isolation levels
         setting at startup 2nd 3rd
    upgrades
         replication
     versus hosts
servers (mysql)
     client connectors
         MySQL Connector/J 2nd
         MySQL Connector/NET 2nd
         MySQL Connector/ODBC 2nd
Service Control section (MySQL Administrator) 2nd
     Configure Service tab
     Start/Stop Service tab 2nd
services (Windows)
     MySQL Server, operating as 2nd 3rd
session variables
     displaying
     setting 2nd
SET clauses
     INSERT statements
     UPDATE statements 2nd
SET PASSWORD statements 2nd 3rd
SET statements
     server system variables, setting
     store routines, assigning variable values in 2nd
     user variables 2nd
SET string data type 2nd 3rd 4th
SET TRANSACTION ISOLATION LEVEL statements
shared tablespaces
     InnoDB storage engine configurations 2nd
         explicit control
         tablespace characteristics 2nd
     InnoDB tables 2nd
shared-memory connections
     --protocol client program/server connection option
SHOW CHARACTER SET statements 2nd
SHOW COLLATION statements 2nd
SHOW COLUMNS statements
     database metadata, accessing 2nd 3rd 4th
     LIKE clauses
SHOW CREATE DATABASE statement
SHOW CREATE FUNCTION statements
     stored function metadata, displaying
SHOW CREATE PROCEDURE statements
     stored procedure metadata, displaying
SHOW CREATE TABLE statements 2nd
     KEY clauses
     table storage engines, determining 2nd
SHOW CREATE VIEW statements
     privilege requirements
SHOW DATABASES statement 2nd
     LIKE clauses
SHOW DATABASES statements
     database metadata, accessing 2nd 3rd
     LIKE clauses
SHOW ENGINEINNODB STATUS statements 2nd
SHOW ENGINES statements 2nd 3rd
SHOW ERRORS statements 2nd
SHOW FIELDS statements
     database metadata, accessing
SHOW FULL TABLES statements 2nd
SHOW FUNCTION STATUS statements
     stored function metadata, displaying
SHOW GRANTS statements 2nd 3rd
SHOW INDEX statements
     database metadata, accessing
SHOW KEYS statements
     database metadata, accessing
SHOW MASTER STATUS statements
SHOW PROCEDURE STATUS statements
     stored procedure metadata, displaying
SHOW PROCESSLIST statements 2nd
     query optimization, determining potential queries for
     replication threads, viewing 2nd
SHOW SLAVE HOSTS statements
SHOW SLAVE STATUS statements 2nd
SHOW statements
     versus INFORMATION SCHEMA database 2nd
SHOW STATUS statements 2nd 3rd
     LIKE clauses
SHOW TABLE statements
     FROM clauses 2nd
SHOW TABLE STATUS statements
     table storage engines, determining 2nd
SHOW TABLES statements
     database metadata, accessing 2nd 3rd
     LIKE clauses
SHOW VARIABLES statements 2nd 3rd
     LIKE clauses 2nd
SHOW WARNINGS statements 2nd 3rd 4th 5th
     query optimization 2nd
SHUTDOWN privileges
     user account management
SIGN() functions 2nd
signed hour/minute offset time zones
Skipped field (LOAD DATA INFILE statements)
slow logs
Slow queries server status variables 2nd
slow query logs
     diagnostic information 2nd 3rd 4th
     query optimization 2nd
SMALLINT integer data types 2nd
     AUTO INCREMENT column attributes 2nd
software
     MySQL software websites
SOME keywords
     column comparisons
sort buffer size system variables
sorting
     data types 2nd 3rd 4th 5th 6th
     row query results 2nd 3rd 4th
    rows
         grouped data 2nd
SOURCE command
     script files, processing
source MySQL distributions
SPATIAL indexes 2nd
specific database privileges
specific stored routine privileges
specific table column privileges
specific table privileges
specifiers (privileges)
splitting
     dynamic-length row-storage formatted MyISAM tables 2nd
SQL mode
     ERROR FOR DIVISION BY ZERO mode, enabling
     Strict mode, enabling
     TRADITIONAL mode, enabling 2nd
    upgrades
         security 2nd 3rd
SQL mode (MySQL Server)
     ANSI mode
     ANSI QUOTES mode
     checking
     clearing
     composiite modes 2nd
     ERROR FOR DIVISION BY ZERO mode
     IGNORE SPACE mode
    setting
         multiple mode names
         single mode values
     STRICT ALL TABLES mode 2nd
     STRICT TRANS TABLES mode 2nd
     TRADITIONAL mode
SQL mode (MySQL Server), setting 2nd
SQL parsers
SQL SECURITY DEFINER values (characteristics clauses) 2nd
SQL SECURITY INVOKER values (characteristics clauses)
SQL statements [See statements]
SQLEXCEPTION conditions
SQLWARNING conditions
START SLAVE statements
Start/Stop Service tab (MySQL Administrator, Service Control section) 2nd
starting
     MySQL Administrator 2nd
starting/stopping
    MySQL Server
         Unix startup methods 2nd
         Unix startup prerequisites 2nd 3rd
         Windows startup prerequisites 2nd
Startup Variables section (MySQL Administrator) 2nd
statement terminators 2nd 3rd 4th
statements
    canceling
         in mysql client interactive mode
     command-line execution
    compound statements
         defining stored routines 2nd
         triggers 2nd
    DEALLOCATE PREPARE
         prepared statements
    error statements
         in script files
         mysql client interactive mode
    EXECUTE
         prepared statements 2nd
    identifiers
         case sensitivity 2nd
         function names as
         qualified names 2nd
         reserved words as 2nd 3rd
         syntax of 2nd
     PREPARE statement 2nd
statements (SQL)
     ALTER DATABASE statement 2nd
    ALTER FUNCTION
         stored routines
    ALTER PROCEDURE
         stored routines
     ALTER TABLE 2nd
         ADD clauses
         adding indexes to tables 2nd
         dropping indexes 2nd
         ENGINE clauses
         FIRST keywords
         MODIFY clauses
         specifying multiple table alterations
     ALTER VIEW
    ANALYZE TABLE
         table maintenance 2nd
    CALL
         invoking stored routines
    CASE
         stored routine conditional testing 2nd
     CHANGE MASTER
     CHECK TABLE
         InnoDB table maintenance
         table maintenance 2nd
     comments 2nd
    compound
         in stored routines 2nd
     CREATE DATABASE statement 2nd
         CHARACTER SET option
         COLLATE option
    CREATE FUNCTION
         characteristics clauses, COMMENT values 2nd
         characteristics clauses, DETERMINISTIC values 2nd
         characteristics clauses, LANGUAGE SQL values 2nd
         characteristics clauses, NOT DETERMINISTIC values 2nd 3rd 4th
         characteristics clauses, SQL SECURITY DEFINER values 2nd 3rd 4th
         characteristics clauses, SQL SECURITY INVOKER values 2nd
         defining stored routines 2nd
         routine body clauses 2nd
         routine body clauses, RETURNS values 2nd
    CREATE INDEX
         adding indexes to tables 2nd
    CREATE PROCEDURE
         defining stored routines 2nd
     CREATE TABLE
         ALTER TABLE option 2nd
         AVG ROW LENGTH option 2nd
         DATA DIRECTORY option 2nd
         ENGINE clauses 2nd
         ENGINE option
         IF NOT EXISTS clauses
         INDEX clauses
         INDEX DIRECTORY option 2nd
         KEY keywords
         MAX ROWS option 2nd 3rd
         PRIMARY KEY keywords 2nd 3rd
         UNIQUE keywords 2nd 3rd 4th
     CREATE TABLE LIKE 2nd
     CREATE TABLE SELECT 2nd 3rd
     CREATE TEMPORARY TABLE
     CREATE TRIGGER 2nd
     CREATE USER 2nd
    CREATE VIEW
         ALGORITHM clauses 2nd 3rd 4th
         OR REPLACE clauses 2nd 3rd
         privilege requirements
         syntax of 2nd
         WITH CHECK OPTION clauses
    DECLARE
         stored routines 2nd
    DECLARE CURSOR
         stored routines
     DECLARE HANDLER 2nd
     DELETE
         emptying tables
         LIMIT clauses
         optimization
         ORDER BY clauses
         required privileges
         WHERE clauses 2nd
     DESCRIBE
         accessing database metadata 2nd 3rd
    DROP DATABASE statement
         IF EXISTS clause
    DROP FUNCTION
         stored routines
     DROP INDEX
    DROP PROCEDURE
         stored routines
     DROP TABLE 2nd
     DROP TRIGGER 2nd
     DROP USER 2nd
     DROP VIEW 2nd
         privilege requirements
    EXECUTE statements
         user variables
     EXPLAIN
         join analysis
         optimization
         query analysis usage example 2nd 3rd 4th 5th 6th 7th 8th
         query analysis, output columns 2nd 3rd 4th 5th 6th 7th
    FETCH
         stored routines
     FLUSH PRIVILEGES
     FLUSH STATEMENT
     GRANT 2nd 3rd
         IDENTIFIED BY clauses
         ON clauses 2nd
         SQL mode upgrades
         syntax of
         TO clauses 2nd
    IF
         stored routine conditional testing
    INFORMATION SCHEMA TABLES
         determining table storage engines
    INSERT
         data updates 2nd 3rd
         NULL values
         ON DUPLICATE KEY UPDATE clauses 2nd
         optimization 2nd
         records with duplicate key values 2nd
         required privileges
         SET clauses
         syntax of 2nd
         tables, adding multiple records to 2nd 3rd
         VALUES keyword 2nd
    ITERATE
         stored routine transfer control
    LEAVE
         stored routine transfer control
     LOAD DATA INFILE 2nd
         data file format specifiers 2nd 3rd 4th
         Deleted field
         duplicate table records 2nd
         efficiency of
         FIELDS clauses
         LINES clauses 2nd
         loading specific table columns 2nd
         NULL values 2nd
         privilege requirements
         Records field
         Skipped field
         skipping data file lines
         skipping table column values
         specifying data file locations 2nd 3rd
         syntax of
         transforming table column values 2nd
         Warnings field
     LOCK TABLES 2nd
         LOW PRIORITY WRITE option
         READ LOCAL option
         READ option 2nd
         WRITE option
    LOOP
         stored routine loops 2nd
    OPTIMIZE TABLE
         table maintenance 2nd
    prepared statements
         benefits of
         creating 2nd
         deallocating
         executing 2nd
         mysql client usage example 2nd
     privilege checks (client access control)
     RENAME TABLE
     RENAME USER 2nd
    REPAIR TABLE
         table maintenance 2nd
    REPEAT
         stored routine loops 2nd
     REPLACE 2nd 3rd 4th
         optimization
         required privileges
    RETURN
         stored routine transfer control
     REVOKE 2nd 3rd 4th
    SELECT
         AVG() aggregate functions 2nd
         column aliases 2nd
         COUNT() aggregate functions 2nd 3rd
         data retrieval 2nd
         data retrieval, aggregating results 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
         data retrieval, column retrieval 2nd 3rd 4th 5th
         data retrieval, concatenating row results 2nd 3rd
         data retrieval, grouping results 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th
         data retrieval, row retrieval 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th
         DISTINCT clauses 2nd 3rd 4th
         FOR UPDATE modifiers
         FROM clauses, subqueries 2nd
         GROUP BY clauses 2nd 3rd 4th 5th
         GROUP CONCAT() aggregate functions 2nd 3rd 4th
         GROUP CONCAT() functions 2nd 3rd
         HAVING clauses 2nd 3rd
         HIGH PRIORITY clauses
         joins 2nd
         LIMIT clauses 2nd 3rd
         LOCK IN SHARE MODE modifiers 2nd
         MAX() aggregate functions 2nd 3rd
         MIN() aggregate functions 2nd 3rd
         ORDER BY clauses 2nd 3rd 4th 5th 6th
         SUM() aggregate functions 2nd
         syntax of
         UNION keyword 2nd 3rd
         WHERE clauses 2nd
    SELECT INTO
         assigning variable values in stored routines
     SELECT INTO OUTFILE 2nd 3rd
         binary backups 2nd
         data file format specifiers 2nd 3rd 4th
         FIELDS clauses
         LINES clauses 2nd
         NULL values 2nd
    SELECT statements
         user variables
     SET
         assigning variable values in stored routines 2nd
     SET PASSWORD 2nd 3rd
    SET statements
         user variables 2nd
     SET TRANSACTION ISOLATION LEVEL
    SHOW
         versus INFORMATION SCHEMA database 2nd
     SHOW CHARACTER SET 2nd
     SHOW COLLATION 2nd
    SHOW COLUMNS
         accessing database metadata 2nd 3rd 4th
         LIKE clauses
     SHOW CREATE DATABASE statement
    SHOW CREATE FUNCTION
         displaying stored function metadata
    SHOW CREATE PROCEDURE
         displaying stored procedure metadata
     SHOW CREATE TABLE 2nd
         determining table storage engines 2nd
         KEY clauses
     SHOW CREATE VIEW
         privilege requirements
    SHOW DATABASES
         accessing database metadata 2nd 3rd
         LIKE clauses
     SHOW DATABASES statement 2nd
         LIKE clauses
     SHOW ENGINEINNODB STATUS 2nd
     SHOW ENGINES 2nd 3rd
     SHOW ERRORS 2nd
    SHOW FIELDS
         accessing database metadata
     SHOW FULL TABLES 2nd
    SHOW FUNCTION STATUS
         displaying stored function metadata
     SHOW GRANTS 2nd 3rd
     SHOW INDEX
         accessing database metadata
    SHOW KEYS
         accessing database metadata
     SHOW MASTER STATUS
    SHOW PROCEDURE STATUS
         displaying stored procedure metadata
     SHOW PROCESSLIST 2nd
         query optimization
         viewing replication threads 2nd
     SHOW SLAVE HOSTS
     SHOW SLAVE STATUS 2nd
     SHOW STATUS 2nd 3rd
         LIKE clauses
    SHOW TABLE
         FROM clauses 2nd
     SHOW TABLE STATUS
         determining table storage engines 2nd
    SHOW TABLES
         accessing database metadata 2nd 3rd
         LIKE clauses
     SHOW VARIABLES 2nd 3rd
         LIKE clauses 2nd
     SHOW WARNINGS 2nd 3rd 4th 5th
         query optimization 2nd
     START SLAVE
     stored routines
     TRUNCATE TABLE 2nd
         emptying tables
         required privileges
     UNLOCK TABLES
     UPDATE 2nd
         LIMIT clauses 2nd
         optimization
         ORDER BY clauses
         required privileges
         SET clauses 2nd
         WHERE clauses 2nd 3rd 4th
         WITHC CHECK OPTION clauses 2nd 3rd
    USE
         selecting/changing default databases
     user accounts, modifying
    WHILE
         stored routine loops 2nd 3rd
STATUS command
     information display example 2nd
status files
     backups
     MySQL Server
     MySQL Server storage
status variables (MySQL server)
     Key read requests
     Key reads
     Opened tables
     Qcache hits
     Qcache inserts
     Qcache lowmem prunes
     Qcache queries in cache
     Threads connected
stopping/starting
    MySQL Server
         Unix startup methods 2nd
         Unix startup prerequisites 2nd 3rd
         Windows startup prerequisites 2nd
storage engine tiers (mysql client/server architecture) 2nd
storage engines
     ARCHIVE
     BDB
     BLACKHOLE
     compiling
     CSV
    data/index files
         MySQL Server storage
     EXAMPLE
     FEDERATED 2nd
         operational characteristics
    InnoDB
         --skip-innodb option
         --without-innodb option
         ACID compliance 2nd
         buffer pool configurations
         dirty reads
         disabling
         disabling autocommit mode 2nd 3rd
         foreign keys 2nd 3rd 4th 5th
         implicitly ending transactions
         innodb buffer pool size option
         innodb data file path option
         innodb data home dir option 2nd
         innodb flush log at trx commit option 2nd
         innodb log buffer size option
         innodb log file size option
         innodb log files in group option
         isolation levels, setting at server startup 2nd 3rd
         locking characteristics 2nd 3rd
         log file configurations 2nd 3rd
         log files
         nonrepeatable reads
         operational characteristics 2nd
         phantoms 2nd
         READ COMMITTED isolation levels 2nd 3rd
         READ UNCOMMITTED isolation levels 2nd
         REPEATABLE READ isolation levels 2nd 3rd
         SERIALIZABLE isolation levels 2nd
         setting transaction savepoints
         shared tablespace configurations 2nd 3rd 4th 5th
         shared tablespaces 2nd
         SHOW ENGINEINNODB STATUS statements 2nd
         SHOW TABLE STATUS statements
         storing log buffers in MySQL Server
         table management
         table optimization 2nd 3rd
         tablespace/log file storage in MySQL Server
         transaction effects on explicit table locks
         transactional model 2nd 3rd 4th
         viewing status information 2nd
     ISAM
     management
     MEMORY
         BTREE indexes
         hash indexes
         operational characteristics
         storing tables in MySQL Server
         table management
         table optimization
     memory usage
    MERGE
         disadvantages of
         locking characteristics
         operational characteristics
         table optimization 2nd
    MyISAM
         AUTO INCREMENT numeric column attribute 2nd
         locking characteristics 2nd 3rd 4th
         operational characteristics 2nd
         row-storage formats 2nd
         row-stroage formats, converting
         row-stroage formats, explicitly specifying for new tables
         table management
         table optimization 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th
     MySQL Server optimization
     NDBCluster
         benefits of 2nd
     operational characterisitics 2nd
     optional engines
     server availability, viewing 2nd
     SHOW ENGINES statements 2nd
     table management 2nd
    tables
         creating MEMORY tables
         creating TEMPORARY tables 2nd
         determining in 2nd
         optimizing, general design principles 2nd
         optimizing, PROCEDURE ANALYSE() 2nd 3rd
         specifying in
     tables, specifying for 2nd
storage engines (queries) 2nd 3rd
stored functions [See also stored routines]
     ALTER FUNCTION statements
     DROP FUNCTION statements
     invoking
    metadata, displaying
         SHOW CREATE FUNCTION statements
         SHOW FUNCTION STATUS statements
    parameters
         IN
     syntax of
     versus stored procedures
stored procedures [See also stored routines]
     ALTER PROCEDURE statements
     DROP PROCEDURE statements
    invoking
         CALL statements
    metadata, displaying
         SHOW CREATE PROCEDURE statements
         SHOW PROCEDURE STATUS statements
     multiple result sets, retrieving
    parameters
         IN
         INOUT
         OUT 2nd
     syntax of
     versus stored functions
stored routines
     access privileges
     ALTER FUNCTION statements
     ALTER PROCEDURE statements
     application performance, enhancing 2nd
     benefits of 2nd
     compound statements
    conditional testing
         CASE statements 2nd
         IF statements
     database administration security 2nd
         DEFINER security characterisitic 2nd
         EXECUTE privilege characteristic
     defining 2nd
         compound statements 2nd 3rd 4th
         conditions 2nd
         CREATE FUNCTION statements 2nd 3rd 4th 5th 6th
         CREATE PROCEDURE statements 2nd 3rd 4th 5th 6th
         cursors 2nd
         DECLARE statements 2nd
         declaring parameters 2nd 3rd
         flow control 2nd
         handlers 2nd 3rd
         SELECT INTO statements
         SET statements 2nd
         variables 2nd 3rd 4th
     DROP FUNCTION statements
     DROP PROCEDURE statements
    functions
         versus procedures
    invoking
         CALL statements
    loops
         LOOP statement 2nd
         REPEAT statement 2nd
         WHILE statement 2nd 3rd
    managing
         in MySQL Query Browser 2nd
    metadata, displaying
         ROUTINES table (INFORMATION SCHEMA database) 2nd
     namespaces 2nd
     privileges 2nd
    qualified names
         identifiers (SQL statements)
     specific privileges
    transfer control
         ITERATE statement
         LEAVE statement
         RETURN statement
storing
    database directories
         in MySQL Server
    frm files
         in MySQL Server 2nd
    InnoDB storage engine tablespaces/log files
         in MySQL Server
    server log files
         in MySQL Server
    status files
         in MySQL Server
    storage engine data/index files
         in MySQL Server
    temporary files
         performance optimization strategies
STRCMP() functions
STRICT ALL TABLES mode (SQL mode) 2nd
STRICT ALL TABLES SQL mode 2nd
Strict mode (SQL mode), enabling
STRICT TRANS TABLES mode (SQL mode) 2nd
STRICT TRANS TABLES SQL mode 2nd
string column attributes
     BINARY 2nd
     CHARACTER SET 2nd
     COLLATE 2nd
string data types
     BINARY 2nd 3rd
     binary string data types 2nd
         characteristics of 2nd
         string column atttributes 2nd
         versus nonbinary data types 2nd
     BLOB 2nd 3rd
     CHAR 2nd 3rd
     ENUM 2nd 3rd 4th 5th
     LONGBLOB
     LONGTEXT
     MEDIUMBLOB
     MEDIUMTEXT
     nonbinary string data types 2nd 3rd
         characteristics of 2nd
         string column atttributes 2nd
         versus binary data types 2nd
     overview of
     SET 2nd 3rd 4th
     TEXT 2nd 3rd 4th
     TINYBLOB
     TINYTEXT
     VARBINARY 2nd 3rd
     VARCHAR 2nd 3rd 4th
string expressions 2nd
     case sensitivity 2nd
         binary strings 2nd 3rd 4th 5th
         literal strings
         nonbinary strings
     pattern-matching 2nd 3rd 4th 5th 6th
subqueries
     column subqueries
    converting
         to inner joins 2nd 3rd
         to outer joins 2nd
     correlated subqueries
     FROM clauses 2nd
     noncorrelated subqueries 2nd
     row subqueries
         row comparisons 2nd 3rd
     scalar subqueries 2nd
         column comparisons 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
         CONCAT() functions
     table subqueries
     updates 2nd
     usage examples
    WHERE clauses
         converting subqueries to inner joins
         updates
SUM() aggregate functions
     SELECT statements 2nd
summarizing
     row data retrievals 2nd
         COUNT() aggregate functions 2nd 3rd
         GROUP CONCAT() aggregate functions 2nd 3rd 4th
         MIN()/MAX() aggregate functions 2nd
         SUM()/AVG() aggregate functions 2nd
summary tables
     query optimization 2nd 3rd 4th
SUPER privilege
     trigger creation/deleting
SUPER privileges
     user account management
symbolic links
     databases, moving 2nd
symlinking
     tables
syntax
     INSERT statements 2nd
     SELECT statements
     stored functions
     stored procedures
syntax browser (MySQL Query Browser, Information Browser)
SYSTEM time zones
System Tray monitor (MySQL Administrator)
system values (type output columns)
system variables (MySQL server)
     innodb buffer pool size
     innodb log buffer size
     join buffer size
     key buffer size 2nd
     max connections
     query cache limit
     query cache min res unit
     query cache size
     query cache type 2nd 3rd
     query cache wlock invalidate
     read buffer size
     sort buffer size
     table cache