MySQL Administrators Guide and Language Reference (2nd Edition)

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] [X] [Y] [Z]

Aborted_clients status variable

Aborted_connects status variable

access

     checking

     connections, verifying

     full table scans

     Index Merge method algorithm

         intersection

         optimization

         sort-union

         union

     primary key

    privileges [See accounts, privileges.]

     range scans

     requests, verifying

     unique key

     write

Access Control Lists [See security, ACLs.]

access denied errors

accounts

     anonymous

     new users, adding 2nd

     passwords

         configuring 2nd

         hashing

         security

     privileges

         access control

         adding

         administrative

         ALTER

         ALTER ROUTINE

         changes

         checking

         CREATE

         CREATE ROUTINE

         CREATE TEMPORARY TABLES

         CREATE USER

         CREATE VIEW

         DELETE

         deleting

         DROP

         enabling/disabling

         EXECUTE

         FILE

         functionality

         GRANT OPTION

         grant tables

         INDEX

         information locations

         INSERT

         limitations

         LOCK TABLES

         overview

         PROCESS

         REFERENCES

         RELOAD

         REPLICATION CLIENT

         REPLICATION SLAVE

         request verification

         SELECT

         SHOW DATABASES

         SHOW VIEW

         SHUTDOWN

         storing

         SUPER

         UPDATE

     resources

     root

ACID

ACLs (Access Control Lists)

     grant tables

     privileges

         access control

         administrative

         changes

         checking

         enabling/disabling

         FILE

         grant tables

         information locations

         limitations

         request verification

         storing

active threads

ActiveState Perl, installing

add-drop-database option (mysqldump)

add-drop-table option (mysqldump)

add-locks option (mysqldump)

adding

     accounts

     buffering to InnoDB indexes

     character sets

     foreign keys

     indexes

     nodes, clusters

     privileges

     users 2nd 3rd

addtodest option (mysqlhotcopy)

administration [See mysqladmin program.]

administrative privileges

algorithms

     access

     nested-loop join

ALL joins (EXPLAIN statements)

all-databases option

     mysqlcheck

     mysqldump

all-in-1 option (mysqlcheck)

allow-keywords option (mysqldump)

allow-suspicious-udfs option (mysqld) 2nd

ALLOW_INVALID_DATES SQL mode

allowold option (mysqlhotcopy)

alpha releases

ALTER privilege

ALTER ROUTINE privilege

analyze option

     myisamchk

     mysqlcheck

anonymous users 2nd

ANSI mode

ansi option (mysqld)

ANSI SQL mode 2nd

ANSI_QUOTES SQL mode

API nodes [See Cluster, SQL nodes.]

APPEND_BLOCK_EVENT event

ArbitrationDelay parameter (config.ini file) 2nd

ArbitrationRank parameter (config.ini file) 2nd

ArbitrationTimeout parameter (config.ini file)

arbitrators

ARCHIVE storage engine 2nd

arguments [See binary logs, options.]

arrays, character definition

asynchronous replication

atomic operations

attackers

auto-rehash option (mysql)

auto-repair option (mysqlcheck)

AUTO_INCREMENT columns (InnoDB tables)

auto_increment_increment system variable 2nd

auto_increment_offset system variable 2nd

autoclose option (mysqld_safe)

autocommit dynamic system variable

automating Cluster backups