< Day Day Up >   


[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

large-scale data
    importation problems
         diagnosing (High-Hat Airways scenario) 2nd 3rd 4th
         High-Hat Airways scenario 2nd 3rd
         resolving (High-Hat Airways scenario) 2nd 3rd 4th
leading wildcards (indexes) 2nd
leaf nodes
     B-tree indexes
length of transactions
         degraded concurrency
         resource consumption
         rollback issues
         rollback segments
         prevention of
         user interface communication
LIMIT statement
         limiting 2nd 3rd 4th
     performance tips
         hdparm command 2nd
         mount command 2nd
    performance tools
         IBM Performance Monitoring (rmfpms) 2nd
         netstat 2nd
         ps 2nd 3rd 4th
         Red Hat System Monitor
     tuning tips 2nd
         disabling unnecessary services 2nd
         recent kernel upgrades 2nd
local checkpoints
lock concurrency (InnoDB)
     granularity levels
         page locks
         row locks
         table locks
         table locks, explicit requests 2nd
     InnoDB 2nd 3rd
         exclusive next-key locks 2nd 3rd
         exclusive non-next-key locks 2nd
         lock concurrency
         monitoring (SHOW INNODB STATUS command) 2nd
         row-level locking scope 2nd
         shared next-key locks
         shared same-record locks 2nd
         data reload preparations 2nd
         READ 2nd
log files
         configuring 2nd 3rd 4th
         crash recovery
         function of
         innodb flush log at trx commit setting
         innodb log buffer setting
         innodb log buffer size setting
         innodb log file size setting
         innodb log files in group setting
         innodb log waits setting
         innodb log write requests setting
         innodb log writes setting
         innodb os log pending writes setting
         monitoring 2nd 3rd 4th
         tuning 2nd 3rd 4th
         --log-queries-not-using indexes parameter 2nd
    management nodes
         clustering issues (MySQL Cluster) 2nd
    master servers
         overhead costs 2nd
logging tools (performance monitoring)
     binary log 2nd
     error log 2nd
     general query log 2nd
     slow query log 2nd
lookup tables
     design mistakes 2nd

 < Day Day Up >   

MySQL Database Design and Tuning
MySQL Database Design and Tuning
ISBN: 0672327651
EAN: 2147483647
Year: 2005
Pages: 131

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: