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] aborted clients status setting     database connectivity

accelerating     data loading from data exports 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th         concurrency management 2nd 3rd         error handling 2nd

         InnoDB engine recommendations 2nd

         MyISAM engine recommendations 2nd adaptive hash indexes (InnoDB) 2ndadministrators

     required knowledge for performance optimization 2nd

ALTER TABLE statement (InnoDB) 2nd 3rdALTER TABLE, ORDER BY statement

    tables         column sort order 2ndanalyse() function

     column selection results 2nd 3rd

ANALYZE TABLE command

    table statistics

         viewing ANALYZER TABLE command (optimizer) 2nd

Apache web servers

     PHP tuning tips 2nd         bottleneck elimination 2nd

         build suggestions         HostNameLookups setting 2nd         KeepAlive setting

         KeepAliveTimeout setting

         MaxClients setting

         MaxKeepAliveRequests setting

         MaxRequestsPerChild setting

         version upgrades

APIs

     (product suite category)

     language libraries 2nd

applications

     efficient coding practices 2nd

         multirow INSERT statements 2nd

         ODBC configuration 2nd

         persistent connections 2nd

         prepared statements 2nd

    High-Hat Airways

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

     indexing strategies 2nd 3rd

    performance analysis         pretesting preparations 2nd     performance optimization 2ndarbitration    management nodes

         clustering issues (MySQL Cluster) 2nd    SQL nodes         clustering issues (MySQL Cluster) ARCHIVE storage engine

     selection criteria

ascending indexes 2ndattached devices     performance analysis

autoextend variable

     disk drives (InnoDB) 2nd