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] Object Browser (MySQL Query Browser)

     bookmark browser 2nd     database browser     history browserON clauses     GRANT statements 2ndON DELETE CASCADE modifiers     FOREIGN KEY clauses

ON DELETE modifiers

     FOREIGN KEY clausesON DUPLICATE KEY UPDATE clauses     INSERT statements 2nd

ON UPDATE CASCADE modifiers

     FOREIGN KEY clauses

ON UPDATE CURRENT TIMESTAMP atttribute

     TIMESTAMP temporal data type 2nd 3rd 4th 5thON UPDATE modifiers

     FOREIGN KEY clauses Opened tables server status variables

Opened tables status variablesoperating systems     security 2nd         risks tooptimization

     importance of

    indexes

         benefits of 2nd

         column prefixes 2nd 3rd 4th 5th

         design principles 2nd 3rd

         leftmost index prefixes 2nd

         types of

     InnoDB tables

     overview of 2nd

    queries

         EXPLAIN statements 2nd

         horizontal limitations

         LIMIT clauses

         rewriting techniques 2nd 3rd         storage engines 2nd 3rd

         summary tables 2nd 3rd 4th

         WHERE clauses 2nd

     updates 2nd

OPTIMIZE TABLE statements     table maintenance 2ndOptimizer

    updates         MyISAM table optimization 2ndOptimizer (MySQL)     EXPLAIN statements 2nd

optimizersoptimizing    MySQL Server         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

    queries

         determining potential queries 2nd 3rd

         EXPLAIN statements 2nd

         EXPLAIN statements, output columns 2nd 3rd 4th 5th 6th 7th         EXPLAIN statements, usage example 2nd 3rd 4th 5th 6th 7th 8th

         rewriting query techniques 2nd         SHOW WARNINGS statement 2nd

         slow query logs 2nd     tables [See also normalization (tables)]         general design principles 2nd         InnoDB 2nd 3rd         MEMORY

         MERGE 2nd

         MyISAM 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th

         PROCEDURE ANALYSE() 2nd 3rd

optimizing MySQL performance

     database tables 2nd

     databases

     disk activity distribution 2nd

     disk configurations

     disk usage strategiues

     filesystems 2nd

     hardware configurations 2nd

     log files

     MyISAM tables

     MySQL installation     network speeds

     OS limitations

     temporary file storage

option files

     !include directives     !includedir directives     --defaults-extra option

     --defaults-file option     backups     creating/modifying     locating

    options         writing in     organization of optional storage engines Options dialog (MySQL Administrator)Options dialog (MySQL Query Browser)     Administrator section

     Browser section

     Connections section     Editors section     General Options section 2nd

OR REPLACE clauses

     CREATE VIEW statements 2nd 3rd

     views privilege requirements

ORDER BY clauses     DELETE statements

     inner joins     SELECT statements 2nd 3rd 4th 5th 6th

     UNION keyword     UPDATE statementsOS (operating systems)     performance optimization strategies OUT parameters 2nd

outer joins

     LEFT JOIN keywords, writing via 2nd 3rd 4th 5th

     RIGHT JOIN keywords, writing via 2nd

     subqueries, converting to 2nd

overriding

     value restrictions (input data handling) 2nd