MySQL 5.0 Certification Study Guide

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] RAID drives

     MySQL performance optimization strategies RAND() functions 2nd Range checked for each record values (Extra output columns) range values (type output columns) read buffer size system variables READ COMMITTED isolation levels (InnoDB storage engines) 2nd 3rd READ LOCAL option (LOCK TABLES statements)

READ option (LOCK TABLES statements) 2nd

READ UNCOMMITTED isolation levels (InnoDB storage engines) 2ndread/write requests     MyISAM tables, changing priorities in

Records field (LOAD DATA INFILE statements)

reducing

    disk space

         character sets ref or null values (type output columns)

ref output columns (EXPLAIN statements) ref values (type output columns)

relay logs     database replication 2nd RELEASE LOCK() functionreloading    dump files

         myslqdump command-line client dump files 2nd

         MySQL Administrator

relocating

    databases

         via symbolic links 2nd

     table data files 2nd 3rd

     table index files 2nd 3rd

removing

     anonymous user accounts

    databases

         warnings

     indexes 2nd

     table records

     tables 2nd     triggers

         privileges

     user accounts

    views

         DROP VIEW statements 2nd RENAME TABLE statements RENAME USER statements 2nd

renaming    columns         retrieved columns     databases

REPAIR TABLE statements     table maintenance 2ndREPEAT statements     stored routine loops 2nd REPEATABLE READ isolation levels (InnoDB storage engines) 2nd 3rd REPLACE statements 2nd 3rd 4th     optimization

     required privileges

replacing     viewsreplication

     binary logs

     CHANGE MASTER statements

     configuring 2nd 3rd

         slave requirements         unique server ID values 2nd

     master/slave architectures 2nd         slave requirements

     master/slave compatibility 2nd     relay logs 2nd     replication threads         SHOW PROCESSLIST statements 2nd     server upgrades

     START SLAVE statements

     troubleshooting 2nd

replication servers

     backups

replication slave servers

     backups

replication slaves

     backups

Replication Status section (MySQL Administrator)

replication threads

     database replication

         SHOW PROCESSLIST statements 2nd

reserved words as identifiers (SQL statements) 2nd

     case sensitivity resource limit checks (client access control) 2nd

resource limits (user accounts), specifying 2nd

Restore section (MySQL Administrator)

Result Area (MySQL Query Browser)

     display, customizing     Search buttonRETURN statements

     stored routine transfer control RETURNS values (routine body clauses) REVOKE statements 2nd 3rd 4threvoking

    privileges         from user accounts 2nd 3rdrewriting    queries         optimization techniques 2ndRIGHT JOIN keywords     outer joins, writing 2nd

root accounts

     passwords ROUND() functions 2nd routine body clauses

     RETURNS values

routines

    stored routines

         specific privilegesroutines (stored)

    qualified names         identifiers (SQL statements)

ROUTINES table (INFORMATION SCHEMA database)     stored routine metadata, displaying 2nd row locks row subqueriesrows

    comparisons

         row subqueries 2nd 3rd

     data retrieval

         aggregating results 2nd

         aggregating results, COUNT() functions 2nd 3rd

         aggregating results, GROUP CONCAT() functions 2nd 3rd 4th

         aggregating results, MIN()/MAX() functions 2nd

         aggregating results, SUM()/AVG() functions 2nd

         concatenating results 2nd 3rd

         data type sort order 2nd 3rd 4th 5th 6th

         eliminating duplicates 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

         limiting selections 2nd 3rd

         sorting results 2nd 3rd 4th

     phantoms 2nd

rows (tables)     AVG ROW LENGTH option 2nd     MAX ROWS option 2nd 3rd

     maximum row counts (MyISAM table optimization) 2nd 3rd 4th rows output columns (EXPLAIN statements)rows subqueries     row comparisons 2nd 3rd

RPM files     MySQL binary distributions     MySQL startup prerequisites