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