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] named pipes     connectivity tuning 2nd

names pipes    ODBC driver setting         Force Use of Name Pipes NDB CLUSTER storage engine

     selection criteria

net buffer length setting     database connectivitynet read timeout setting

     database connectivity

net retry timeout setting     database connectivity

net write timeout setting     database connectivity netstat utility (Linux) 2nd

networks

    connectivity performance

         reloading data from data export operations 2nd

    Linux utilities         netstat 2nd

    replication speed

         compression algorithm         encryption issues 2nd

         error handling issues 2nd         performance of 2nd         timeout issues 2nd

nodes

     checkpoints 2nd

         global

         local

     data 2nd

    data distribution

         fragments

         replicas

     function of

    load balancing

         clustering (MySQL Cluster) 2nd

     management

    realignment of

         server clustering

     SQL Node 2nd

     transporters 2nd         Scalable Coherent Interface (SCI)

         shared memory

         TCP/IP local         TCP/IP remotenon-leaf nodes     B-tree indexesnon-unique column

     SHOW INDEX command outputnon_unique column     SHOW INDEX command outputnonnumeric joins

     versus numeric joins 2nd 3rd

normalization     three-normal-form rule     when not to 2nd 3rd

NOT NULL constraint 2nd 3rd

null column     SHOW INDEX command output

numeric joins     versus nonnumeric joins 2nd 3rdnumeric types

     column performance implications 2nd

numeric-based indexes

     versus character-based indexes 2nd 3rd