MySQL Database Design and Tuning
| < Day Day Up > |
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] B-tree indexes 2nd 3rd leaf nodes non-leaf nodes primary key order data storage 2ndback log setting database connectivity bandwidth IIS/PHP performance configuration limitations on 2nd batching SQL nodes clustering issues (MySQL Cluster) 2nd benchmark suite (performance tool) 2ndBENCHMARK() function (performance tool) 2nd 3rd Berkeley Database (BDB) storage engine selection criteria binary log logging-based performance monitoring 2nd binary logs binlog cache disk use status variable binlog cache use status variable caching 2nd 3rd transaction alloc block size variable transaction prealloc size variable binary-based data exports executing 2nd 3rd frequency of binlog cache disk use status variable binlog cache use status variable BLOB column indexes defining 2nd BLOBs column performance implications 2nd blocks (indexes) 10% memory allocation rule 2nd implicit time stamping midpoint insertion strategy 2nd 3rd multiple threads updatingbottlenecks Apache/PHP web servers elimination of 2ndbuckets hash indexes 2ndbuffer pool MyISAM buffer pools in-memory caches indexes (InnoDB) buffer pools (InnoDB) 2nd alternatives to 2nd configuring 2nd 3rd 4th 5th 6th excessive waits hit rates 2nd innodb buffer pool pages data innodb buffer pool pages dirty innodb buffer pool pages flushed data innodb buffer pool read ahead data innodb buffer pool read requests value innodb buffer pool wait free data innodb buffer pool write requests value monitoring 2nd 3rd 4th 5th 6th 7th 8th 9th 10th problem indicators 2nd 3rd tuning 2nd 3rd 4th 5th 6th 7th 8th 9th 10thbuild suggestions Apache/PHP web servers bulk insert buffering MyISAM speed optimization 2nd |
| < Day Day Up > |