index_I

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

IBM Performance Monitoring (rmfpms) utility 2nd
id column
     EXPLAIN command (optimizer) output
IGNORE INDEX statement
     optimizer assistance option 2nd
IIS
    PHP tuning tips
         bandwidth limits 2nd
         CGI improvements 2nd
         connection timeouts
         HTTP compression
importing
    large scale data
         diagnosis of (High-Hat Airways scenario) 2nd 3rd 4th
         High-Hat Airways scenario 2nd 3rd
         resolution of (High-Hat Airways scenario) 2nd 3rd 4th
in-memory caches
    memory settings
         database connectivity 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
in-memory processing
    data exports
         advantages/disadvantages
in-memory temporary tables
    queries
         forcing
inactivity
    sessions
         dropping 2nd
index cache
     hit rates example (MySQL Administrator)
index_type column
     SHOW INDEX command output
indexes
    applications
         development strategies 2nd 3rd
     ascending 2nd
     B-tree 2nd 3rd
         leaf nodes
         non-leaf nodes
         primary key order;data storage 2nd
    blocks
         10% memory allocation rule 2nd
         implicit time stamping
         midpoint insertion strategy 2nd 3rd
         multiple threads
         updating
     cardinality of columns 2nd 3rd
         hash 2nd 3rd
    character-based
         versus numeric-based 2nd 3rd
    clustered
         InnoDB 2nd
     compressing (MyISAM)
     descending 2nd
     disabling for data-loading operations
     dynamic hashing
     filter columns 2nd 3rd
    forced selections
         optimizer assistance option 2nd 3rd 4th 5th 6th 7th
    FULLTEXT searches
         building 2nd
         configuring 2nd 3rd
         implementing 2nd 3rd
         performance tips 2nd
         using 2nd 3rd 4th 5th
     hash
         buckets 2nd
         structure of 2nd 3rd
     highly duplicate type
    InnoDB
         adaptive hash type 2nd
         buffer pools
         data storage/structure 2nd
         foreign key generation
         memory pools
         performance boosting features 2nd 3rd 4th 5th 6th 7th
    join columns
         placing on 2nd 3rd
     key cache (MyISAM engine) 2nd
    keys
         compressing (MyISAM engine) 2nd
     leading wildcards in key 2nd
    logging
         --log-queries-not-using indexes parameter 2nd
     multicolumn 2nd 3rd
         creating 2nd
    MyISAM
         deactivating 2nd
    myisamchk utility
         performance boosting tool 2nd
    MySQL Optimizer
         max_seeks_for_key parameter 2nd
     over-indexed disadvantages
    parallel
         creating (myisamchk utility)
     partial 2nd
         similar column values 2nd
         TEXT/BLOB column values 2nd
    primary keys
         defining 2nd 3rd
     R-tree
    secondary
         InnoDB 2nd
     SHOW INDEX command 2nd
         cardinality column
         collation column
         column_name column
         comment column
         index_type column
         key_name column
         non_unique column
         null column
         packed column
         results output 2nd 3rd 4th
         results output, interpretation of 2nd
         seq_in_index column
         sub_part column
     SHOW INNODB STATUS command
    sorting/grouping
         incorrect order of 2nd
    tables
         building 2nd 3rd 4th 5th 6th 7th 8th
         clustering (MySQL Cluster)
         delaying re-creation of (mysqldump utility) 2nd 3rd
         resorting (OPTIMIZER TABLE command) 2nd 3rd
         sorting operations 2nd 3rd 4th
     unanchored access
initialization files (PHP)
     configuring web server connections 2nd
InnoDB
    concurrency
         performance tips
    data storage
         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
    disk performance tips
         autoextend variable settings 2nd
         data flushing 2nd
         raw partition implementation 2nd 3rd
    engine recommendations
         data reloading from data exports 2nd
     I/O operations 2nd
         clustered indexes 2nd
         extents
         pages 2nd
         secondary indexes 2nd
         segments
         tablespaces 2nd
    indexes
         adaptive hash type 2nd
         buffer pools
         data storage/structure 2nd
         foreign key generation
         memory pools
         performance boosting features 2nd 3rd 4th 5th 6th 7th
    large-scale operations
         performance tips 2nd
     locking 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
    log files
         configuring 2nd 3rd 4th
         crash recovery
         function of
         innodb flash 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
         rollbacks
         tuning 2nd 3rd 4th
    memory
         buffer pools 2nd
         buffer pools, alternatives to 2nd
         buffer pools, configuring 2nd 3rd 4th 5th 6th
         buffer pools, innodb buffer pool pages data value
         buffer pools, innodb buffer pool pages dirty value
         buffer pools, innodb buffer pool pages flushed value
         buffer pools, innodb buffer pool read ahead value
         buffer pools, innodb buffer pool read requests value
         buffer pools, innodb buffer pool size 2nd 3rd
         buffer pools, innodb buffer pool wait free value
         buffer pools, innodb buffer pool write requests value
         buffer pools, innodb max dirty pages pct 2nd
         buffer pools, monitoring 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
         buffer pools, problem indicators 2nd 3rd
         buffer pools, tuning 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
    performance enhancers
         doublewrite buffer
         insert buffer
         prestaged reads
         versioning 2nd
    performance tips
         table defragmentation 2nd 3rd
    shutdown performance
         innodb fast shutdown parameter
     storage architecture 2nd
         clustered indexes 2nd
         extents
         pages 2nd
         secondary indexes 2nd
         segments
         tablespaces 2nd
    tables
         delaying re-creation of indexes
    tablespaces
         configuration of
    threads
         innodb thread concurrency setting 2nd
innodb autoextend increment setting (InnoDB) 2nd
innodb autoextend increment variable
    InnoDB
         data storage
innodb data dblwr writes value (MySQL Administrator)
innodb data fsyncs value (MySQL Administrator)
innodb data pending value (MySQL Administrator)
innodb data pending writes value (MySQL Administrator)
innodb data reads value (MySQL Administrator)
innodb data writes value (MySQL Administrator)
innodb fast shutdown parameter
innodb file io threads variable
    InnoDB
         data storage
innodb flush method setting 2nd
innodb open files server variable
    InnoDB
         data storage
InnoDB storage engine
     selection criteria 2nd
innodb tablespace monitor variable
    InnoDB
         data storage 2nd
innodb thread concurrency setting (InnoDB) 2nd
insert buffer
     InnoDB performance enhancer
INSERT DELAYED operator
     reloading data from data export operations
INSERT DELAYED statement
     data-loading operations 2nd 3rd
INSERT LOW PRIORITY statement
     data-loading operations 2nd
INSERT operator
     reloading data from data export operations 2nd
INSERT statement
    data-loading operations
         multiple rows 2nd 3rd 4th
    grouping operations
         clustering (MySQL Cluster)
    multiple rows
         application writing practices 2nd
INSERT, ON DUPLICATE KEY UPDATE statement
     data-loading operations 2nd 3rd
integer types (numbers)
     column performance implications
integrity
    databases
         primary keys, defining 2nd
integrity checking
    table updates
         implementing via views 2nd
interactive timeout setting
     database connectivity
interruptions
    sessions
         dropping
interserver communication
     topology selection 2nd
iostat utility (Linux)
IP addresses
    numeric
         clustering (MySQL Cluster)
ISAM storage engine
isolation levels
     optimal transactions
         READ COMMITTED 2nd
         READ UNCOMMITTED 2nd 3rd 4th
         REPEATABLE READ 2nd
         SERIALIZABLE 2nd
         setting 2nd
    selection criteria
         transaction performance 2nd 3rd
     SET TRANSACTION ISOLATION LEVEL statement 2nd
    transaction length
         selection of

 < 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

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