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] HANDLER statement    queries

         performance tips 2nd 3rd 4th    tables         rows, handling 2nd 3rd 4thhardware

    performance analysis

         attached devices         disk capacities         memory

         pretesting preparations 2nd 3rd

         processors    server outage solutions

         High-Hat Airways scenario 2ndhardware-based RAID     disk drive

hash columns

    tables

         index cardinality 2nd 3rd

hash indexes     buckets 2nd

     structure of 2nd 3rd

hdparm command    drive access parameters

         modifying (Linux) 2ndHIGH PRIORITY statement    queries

         prioritizing 2nd

High-Hat Airways

     background of 2nd 3rd

     FULLTEXT search example

    lost luggage application

         DEFAULT constraint 2nd

         ENUM constraint 2nd

         FOREIGN KEY constraint 2nd 3rd 4th 5th 6th

         NOT NULL constraint 2nd

         PRIMARY KEY constraint 2nd

         SET constraint 2nd 3rd

         UNIQUE constraint

     package delivery case study 2nd 3rd

         package status lookup problems 2nd

         package status lookup problems, diagnosis 2nd 3rd

         package status lookup problems, solution 2nd 3rd         shipping option lookup problems 2nd

         shipping option lookup problems, diagnosis 2nd

         shipping option lookup problems, resolving 2nd 3rd    random transaction bottlenecks         diagnosis of 2nd 3rd         order of solution implementation 2nd         replication strategy

         resolution of 2nd         resource restriction strategy         rollup strategy    replication strategy

         designing 2nd 3rd 4th 5th 6th

High-Hat Airways scenario     airfare sale fiasco 2nd 3rd 4th         application failure diagnosis 2nd 3rd 4th 5th

         application failure solutions 2nd 3rd 4th 5th 6th

         server outage diagnosis 2nd 3rd 4th         server outage solution 2nd 3rd 4th 5th 6th

         transaction failure diagnosis 2nd 3rd 4th         transaction failure solution 2nd 3rd 4th 5th 6th     data importation problems 2nd 3rd

         diagnosing 2nd 3rd 4th

         resolving 2nd 3rd 4th

    server clustering problems

         diagnosis of 2nd 3rd 4th         resolution of 2nd 3rd 4th 5th

    stored procedure problems

         diagnosis of 2nd 3rd 4th         resolution of 2nd 3rd

highly duplicate indexeshostname resolution    connectivity tuning

         cost reduction 2nd

HostNameLookups setting

     Apache/PHP performance configuration 2nd

HTTP

    IIS/PHP performance configuration

         compression