MySQL Database Design and Tuning

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] enabling     query caches 2nd 3rd

encryption    replication servers         performance issues 2nd ENUM constraint 2nd 3rd

error handlers

     CONTINUE 2nd     EXIT 2nderror handling

     data reloading from data exports 2nd

    replication servers         performance issues 2nd

error log     logging-based performance monitoring 2nderrors

    sessions

         dropping

EXAMPLE storage engine

examples    High Hat Airways

         background of 2nd 3rd

exclusive next-key locks     InnoDB 2nd 3rd

exclusive non-next-key locks     InnoDB 2nd EXIT error handler 2nd

EXPLAIN command (optimizer) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd

     launching 2nd

     results columns 2nd

         extra 2nd 3rd 4th 5th 6th 7th

         id

         key 2nd

         key len 2nd

         possible keys 2nd

         ref 2nd

         rows 2nd

         select type 2nd 3rd 4th

         table

         type 2nd 3rd 4th 5th

    sample queries

         output 2nd

     uses for 2ndexplicit requests

     table locks 2nd

exporting    data         binary-based method 2nd 3rd 4th         text-based method 2nd 3rd    databases

         for testing purposes (mysqldump utility) 2nd extents (InnoDB)     page groupingsextra column

     EXPLAIN command (optimizer) output 2nd 3rd 4th 5th 6th 7th