index_P

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

packaged applications
    performance analysis
         pretesting preparations 2nd
packed column
     SHOW INDEX command output
page locks
pages (InnoDB)
     capacities 2nd
     default sizes 2nd
    extents
         grouping of
    segments
         grouping of
parallel indexes
    tables
         creating (myisamchk utility)
partial indexes 2nd
     similar column values 2nd
     TEXT/BLOB column values 2nd
partitions
    raw disks
         contiguous disk space (InnoDB)
         implementing (InnoDB) 2nd 3rd
         lower overhead (InnoDB)
peers
     cooperation of during testing 2nd
performance
    FULLTEXT searches
         guidelines 2nd
     MySQL version improvements listing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
    tables
         column selection criteria 2nd 3rd 4th 5th 6th 7th 8th 9th
         column views 2nd
         inefficient joins 2nd
         row views 2nd
         views, updating with integrity checking 2nd
performance analysis
     connectivity profiles 2nd
    data sets
         pretesting preparations 2nd
     hardware components 2nd
         attached devices
         disk capacities
         memory
         processors
     organizational support
         peer support 2nd
         production system access
         system loads
         user cooperation
     single variable testing approach 2nd
    software
         databases 2nd
         operating systems 2nd
         packaged applications 2nd
     test plan creation 2nd 3rd
    test results
         recording 2nd 3rd 4th
    testing approaches
         structured versus flexible 2nd
performance monitoring
     character-based tools
         mysqladmin 2nd
         SET/SELECT command 2nd
         SHOW ENGINES command 2nd
         SHOW INDEX command 2nd
         SHOW INNODB STATUS command 2nd 3rd
         SHOW PROCESSLIST command
         SHOW STATUS command 2nd 3rd
         SHOW TABLES command
         SHOW TABLES STATUS command 2nd 3rd
         SHOW VARIABLES command 2nd
    graphical tools
         MySQL Administrator 2nd
         MySQL Query Browser 2nd
    logging tools
         binary log 2nd
         error log 2nd
         general query log 2nd
         slow query log 2nd
    operating systems tools
         free (Linux)
         IBM Performance Monitoring (rmfpms) 2nd
         iostat (Linux)
         MMC Performance Monitor 2nd
         mpstat (Linux)
         netstat (Linux) 2nd
         ps (Linux)
         Red Hat Linux System Monitor
         sar (Linux) 2nd
         top (Linux)
         vmstat (Linux)
         Windows Task Manager 2nd
performance optimization
     benefits of 2nd 3rd
performance-related tools
     benchmark suite 2nd
     BENCHMARK() function 2nd 3rd
persistent connections
     application writing practices 2nd
PHP
     web server tuning tips 2nd
         caching options 2nd
         initialization file configuration 2nd
possible keys column
     EXPLAIN command (optimizer) output 2nd
posttesting
    results analysis
         employee education
         feedback
         future approaches 2nd
prepared statements
     application writing practices 2nd
prestaged reads
     InnoDB performance enhancer
pretesting preparations
    performance analysis
         connectivity profiles 2nd
         data sets 2nd
         hardware components 2nd 3rd 4th 5th 6th
         organizational support 2nd 3rd 4th 5th 6th
         single variable testing approach 2nd
         software 2nd 3rd 4th 5th 6th
         test plan creation 2nd 3rd
PRIMARY KEY constraint 2nd 3rd
     violations of
primary key order
    B-tree indexes
         data storage 2nd
primary keys
     defining 2nd
    indexes
         defining 2nd 3rd
    tables
         clustering (MySQL Cluster)
processing
    optimizer options
         optimizer prune level variable
         optimizer search depth variable
processors
     performance analysis
product suite categories
     APIs
         language libraries 2nd
     connectors
         function of
         ODBC
     Database Storage Engines and Table Types 2nd
         ARCHIVE 2nd
         Berkeley Database (BDB) 2nd
         CSV 2nd 3rd
         EXAMPLE
         FEDERATED 2nd 3rd
         InnoDB 2nd 3rd
         ISAM
         MaxDB 2nd
         MEMORY 2nd 3rd 4th
         MERGE 2nd 3rd 4th 5th
         MyISAM 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
         NDB CLUSTER 2nd
         selection options 2nd
     Distributed Computing Technologies
         MySQL Cluster
         Replication
     Graphical Tools and Assistants
         Configuration Wizard 2nd 3rd 4th 5th
         MySQL Administrator
         MySQL Query Browser
         MySQL System Tray
     MySQL Core Technologies 2nd
     utilities
         myisamchk 2nd
         myisampack 2nd
         mysqlbinlog 2nd
         mysqldump 2nd
         mysqlimport 2nd
production systems
     proper access during testing
protocols
    clustering
         SCI socket issues (MySQL Cluster) 2nd
         shared memory issues (MySQL Cluster) 2nd
         TCP issues (MySQL Cluster) 2nd
     clustering (MySQL Cluster)
ps utility (Linux)

 < 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