MySQL Database Design and Tuning
| < 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 2ndid column EXPLAIN command (optimizer) outputIGNORE INDEX statement optimizer assistance option 2ndIIS 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 forcinginactivity 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 parameterinnodb file io threads variable InnoDB data storage innodb flush method setting 2ndinnodb open files server variable InnoDB data storage InnoDB storage engine selection criteria 2ndinnodb tablespace monitor variable InnoDB data storage 2nd innodb thread concurrency setting (InnoDB) 2ndinsert buffer InnoDB performance enhancer INSERT DELAYED operator reloading data from data export operationsINSERT DELAYED statement data-loading operations 2nd 3rdINSERT 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 2ndINSERT, 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 engineisolation 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 > |