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] KeepAlive setting     Apache/PHP performance configuration

KeepAliveTimeout setting     Apache/PHP performance configurationkernels    upgrades

         importance of (Linux/Unix 2nd

key cache     in-memory caches     indexes (MyISAM engine) 2nd

     MyISAM

         configuring 2nd 3rd 4th 5th 6th 7th         function of 2nd

         index block multiuple threads         index block time stamps         index block updates

         index blocks, midpoint insertion strategy

         monitoring 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

         multiple deployment of 2nd

key column     EXPLAIN command (optimizer) output 2nd

key len column

     EXPLAIN command (optimizer) output 2ndkey_name column

     SHOW INDEX command outputkeys    indexes

         compressing (MyISAM storage engine) 2nd