index_D

 < 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]

data
    importation problems
         diagnosing (High-Hat Airways) 2nd 3rd 4th
         High-Hat Airways 2nd 3rd
         resolving (High-Hat Airways) 2nd 3rd 4th
    protection
         clustering (MySQL Cluster) 2nd
    slave servers
         overhead reduction 2nd
         replication criteria 2nd
data backups
    launching
         via MySQL Administrator 2nd 3rd
         via mysqldump utility 2nd 3rd
         via mysqlhotcopy utility 2nd 3rd
data distribution
    node storage
         fragments
         replicas
data exports
     binary-based method 2nd 3rd
         frequency of
    concurrency issues
         --lock-tables attribute 2nd
         --single-transaction attribute 2nd
     data reloading
         acceleration of 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
         concurrency management 2nd 3rd
         error handling 2nd
         INSERT DELAYED operation
         multirow INSERT operation 2nd
         MyISAM engine recommendations 2nd 3rd 4th
         network performance parameters 2nd
         SELECT, INTO OUTFILE statement 2nd
         table locking 2nd
    in-memory processing
         advantages/disadvantages
    subsets
         retrieval of 2nd
    table schemas
         copying without associated data 2nd
    tables
         delaying index re-creation (mysqldump utility) 2nd 3rd
     text-based method 2nd 3rd
data flushing (InnoDB) 2nd
data modifications
     performance tips 2nd
         DELETE statement
         DELETE statement, DROP TABLE command 2nd
         DELETE statement, LOW PRIORITY option
         DELETE statement, QUICK option 2nd
         DELETE statement, TRUNCATE TABLE command 2nd
         indexes, disabling
         INSERT DELAYED statement 2nd 3rd
         INSERT LOW PRIORITY statement 2nd
         INSERT statement, multiple rows 2nd 3rd 4th
         INSERT, ON DUPLICATE KEY UPDATE statement 2nd 3rd
data node
     clustering 2nd
data nodes
    capacity parameters
         clustering (MySQL Cluster) 2nd
     clustering (MySQL Cluster) 2nd
    logging parameters
         clustering (MySQL Cluster) 2nd
    memory parameters
         clustering (MySQL Cluster) 2nd 3rd
    timing parameters
         clustering (MySQL Cluster) 2nd 3rd
    transaction parameters
         clustering (MySQL Cluster) 2nd 3rd
data sets
    performance analysis
         pretesting preparations 2nd
data storage
    InnoDB
         configuring 2nd 3rd 4th
         innodb autoextend increment variable
         innodb file io threads variable
         innodb open files server variable
         innodb tablespace monitor variable 2nd
         monitoring 2nd 3rd 4th
         tuning 2nd 3rd 4th
data storage (MyISAM)
     optimal configuation
         table maintenance and repair 2nd 3rd 4th 5th
         table reporting and control 2nd 3rd 4th 5th
         table sorting resources 2nd
data-loading operations
     performance tips 2nd
         DELETE statement
         DELETE statement, DROP TABLE command 2nd
         DELETE statement, LOW PRIORITY option
         DELETE statement, QUICK option 2nd
         DELETE statement, TRUNCATE TABLE command 2nd
         indexes, disabling
         INSERT DELAYED statement 2nd 3rd
         INSERT LOW PRIORITY statement 2nd
         INSERT statement, multiple rows 2nd 3rd 4th
         INSERT, ON DUPLICATE KEY UPDATE statement 2nd 3rd
Database Storage Engines and Table Types
     (product suite category) 2nd
     ARCHIVE
     Berkeley Database (BDB)
     CSV
     EXAMPLE
     FEDERATED
     InnoDB
     ISAM
     MaxDB
     MEMORY
     MERGE
     MyISAM
     NDB CLUSTER
    storage engines
         ARCHIVE
         Berkeley Database (BDB)
         CSV 2nd
         FEDERATED 2nd
         InnoDB 2nd
         MaxDB
         MEMORY 2nd 3rd
         MERGE 2nd 3rd 4th
         MyISAM 2nd 3rd 4th 5th 6th 7th 8th 9th
         NDB CLUSTER
         selection options 2nd
databases
    integrity
         primary keys, defining 2nd
    performance analysis
         pretesting preparations 2nd
     symbolic links (MyISAM) 2nd
deadlocks
     transaction length
debugging
     performance analysis 2nd
decimal types (numbers)
     column performance implications
dedicated subnets
     clustering (MySQL Cluster)
DEFAULT constraint 2nd 3rd
defragmenting
    tables
         myisamchk utility 2nd
         OPTIMIZER TABLE command 2nd 3rd
     tables (InnoDB) 2nd 3rd
degraded concurrency
     transaction length
DELETE statement
     data-loading operations
         DROP TABLE command 2nd
         LOW PRIORITY option
         QUICK option 2nd
         TRUNCATE TABLE command 2nd
deploying
    disk drives
         speed issues
descending indexes 2nd
designing
    databases
         when not to normalize 2nd 3rd
destroying
    connections
         cost of 2nd 3rd
diagnosing
    application failures
         High-Hat Airways scenario 2nd 3rd 4th 5th
    large-sale data importation problems
         High-Hat Airways 2nd 3rd 4th
    server clustering problems
         High-Hat Airways 2nd 3rd 4th
    server outages
         High-Hat Airways scenario 2nd 3rd 4th
    stored procedure problems
         High-Hat Airways 2nd 3rd 4th
    transaction failures
         High-Hat Airways scenario 2nd 3rd 4th
disabling
    extraneous services
         Windows tuning tip 2nd
Disk Cleanup utility
    system files
         deleting (Windows) 2nd
Disk Defragmenter utility
    disks
         defragmenting (Windows) 2nd 3rd
disk drives
    access parameters
         modifying (Linux) 2nd
     autoextend variable settings (InnoDB) 2nd
     defragmenting (Windows Disk Defragmenter utility) 2nd 3rd
    performance tips
         deployment of speedy drives
         memory cache configuration 2nd
         RAID strategy implementation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
         temporary directory distribution 2nd
disk striping (RAID 0) 2nd
disks
    capacities
         performance analysis
    Linux reporting utilities
         iostat
DISTINCT statement
     queries 2nd
Distributed Computing Technologies
     (product suite category)
     MySQL Cluster
     Replication
distributing
    temporary directories
         disk drive performance 2nd
doulblewrite buffer
     InnoDB performance enhancer
drivers (ODBC)
     Don't Cache Results setting
     Force Use of Named Pipes setting
     Use Compressed Protocol setting
DROP TABLE command 2nd
duplexing (RAID 0) 2nd
dynamic hashing
     indexes

 < Day Day Up >   


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

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net