< 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] management node clustering management nodes clustering arbitration issues (MySQL Cluster) 2nd logging issues (MySQL Cluster) 2nd mass storage devices performance analysis master servers replication speed logging parameters 2nd monitoring information 2nd 3rd 4th 5th 6th tuning practices role in replication 2nd 3rd 4th 5th 6th 7th SHOW BINARY LOGS command SHOW BINLOG EVENTS command 2nd SHOW MASTER LOGS command SHOW MASTER STATUS command math queries calculation operations, GROUP BY, WITH ROLLUP statement 2nd calculation operations, performance guidelines 2nd 3rd 4th 5th 6th 7th max allowed packet setting database connectivity max connections setting database connectivity max length for sort data variable max used connections setting database connectivity MaxClients setting Apache/PHP performance configuration MaxDB storage engine selection criteria MaxKeepAliveRequests setting Apache/PHP performance configuration MaxRequestPerChild setting Apache/PHP performance configuration memory buffer pools (InnoDB) 2nd alternatives to 2nd configuring 2nd 3rd 4th 5th 6th innodb buffer pool pages data value innodb buffer pool pages dirty value innodb buffer pool pages flushed value innodb buffer pool read ahead value innodb buffer pool read requests value innodb buffer pool size 2nd 3rd innodb buffer pool wait free value innodb buffer pool write requests value innodb max dirty pages pct 2nd monitoring 2nd 3rd 4th 5th 6th 7th 8th 9th 10th problem indicators 2nd 3rd tuning 2nd 3rd 4th 5th 6th 7th 8th 9th 10th in-memory caches buffer pools key cache memory pools query cache 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th in-memory processing data export rules Linux utilities free vmstat MEMORY tables 2nd mysqld process locking 2nd performance analysis thread status 2nd memory caches disk drives correct configuration of 2nd MyISAM buffer pool key 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th memory pool query memory pool MyISAM memory pools in-memory caches indexes (InnoDB) MEMORY storage engine selection criteria 2nd drawbacks MEMORY tables 2nd memory settings database connectivity 2nd MERGE storage engine selection criteria 2nd 3rd 4th mirroring (RAID 0) 2nd MMC Performance Monitor 2nd monitoring InnoDB data storage 2nd 3rd 4th key cache MySQL Administrator reports MySQL Administrator reports, consumption 2nd MySQL Administrator reports, metrics graphs 2nd 3rd MySQL Administrator reports, read hit rate percentages 2nd MySQL Administrator reports, reads versus disk reads MySQL Administrator reports, write hit rate percentages 2nd MySQL Administrator reports, writes versus disk writes log files InnoDB 2nd 3rd 4th master servers replication performance 2nd 3rd 4th query caches 2nd 3rd 4th slave servers health of 2nd 3rd mount command drive performance parameters modifying (Linux) 2nd mpstat utility (Linux) multicolumn indexes 2nd 3rd creating 2nd multiple key caches deployment of 2nd multiserver configurations topology selection 2nd MyISAM engine recommendations data reloading from data exports 2nd indexes key cache 2nd internal engine caches leveraging 2nd memory caches buffer pool key 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th memory pool query myisamchk utility parallel index creation table compression 2nd table defragmentation 2nd table reports 2nd table reports, deleted blocks section table reports, fragmentation section table reports, index compression section table reports, index depth section table reports, status section table sorting resources 2nd table storage in index order 2nd optimal data storage configuration table maintenance and repair 2nd 3rd 4th 5th table reporting and control 2nd 3rd 4th 5th table sorting resources 2nd performance tips symbolic links 2nd table compression speed optimization bulk insert buffering 2nd concurrency considerations 2nd 3rd delay in key writes 2nd FULLTEXT index construction 2nd FULLTEXT index execution 2nd 3rd 4th 5th FULLTEXT search configuration 2nd 3rd FULLTEXT search implementation 2nd 3rd FULLTEXT searches, performance tips 2nd index update deactivation 2nd loading information 2nd 3rd 4th 5th 6th 7th 8th 9th table size specifications 2nd tables delaying re-creation of indexes 2nd MyISAM storage engine checksum integrity 2nd index key compression 2nd selection criteria 2nd 3rd 4th 5th myisamchk utility 2nd indexes performance features 2nd table statistics deleted blocks section fragmentation section index compression section index depth section status section viewing (MyISAM) 2nd tables compressing (MyISAM) 2nd defragmenting (InnoDB) 2nd 3rd defragmenting (MyISAM) 2nd parallel index creation (MyISAM) sorting resources (MyISAM) 2nd storing in index order (MyISAM) 2nd myisampack utility 2nd tables compressing MySQL locking granularity levels granularity levels, page locks granularity levels, row locks granularity levels, table locks server outage solutions High-Hat Airways scenario 2nd version 4.1 series 2nd version 5.0 series 2nd versions performance evolution listing from 4.0 2nd 3rd 4th 5th 6th 7th 8th 9th 10th website partner solutions MySQL Administrator application control open files limit variable opened tables status variable table cache parameter concurrency insert delayed statements 2nd unlocking tables data backups executing 2nd 3rd graph values innodb data fsyncs innodb data pending innodb data pending writes innodb data reads innodb data writes innodb dblwr writes graphical-based performance monitoring 2nd index cache hit rates InnoDB data storage diagnostics 2nd 3rd 4th key cache reports consumption 2nd metrics graphs 2nd 3rd read hit rate percentages 2nd read versus disk reads write hit rate percentages 2nd writes versus disk writes optimizer control max length for sort data variable optimizer prune level variable optimizer search depth variable query cache ill-performing indicators 2nd monitoring results 2nd 3rd 4th well-performing indicators 2nd query cache hit rates server status variables statement counts com status variable user resource controls GRANT command 2nd user-specific output examination of MySQL Cluster clients clusters advantages 2nd 3rd benefits 2nd versus replication 2nd 3rd data nodes 2nd capacity parameters 2nd logging parameters 2nd memory parameters 2nd 3rd node timing parameters 2nd 3rd transaction parameters 2nd 3rd distributed computing technology product management nodes arbitration issues 2nd logging issues 2nd network issues dedicated subnets numeric IP addresses network protocols SCI socket issues 2nd shared memory issues 2nd TCP/IP issues 2nd nodes checkpoints 2nd 3rd 4th data 2nd data distribution 2nd function of management SQL Node 2nd transporters 2nd 3rd 4th 5th 6th overview 2nd 3rd performance tips 2nd data protection 2nd grouping insert operations load balancing 2nd primary key employment proper indexes shared-nothing nodes SQL nodes arbitration issues batching issues 2nd topologies selecting 2nd 3rd versions selecting 2nd MySQL Core Technologies (product suite category) 2nd MySQL Optimizer indexes max_seeks_for_key parameter 2nd MySQL Query Browser graphical-based performance monitoring 2nd query plans displaying 2nd MySQL software-based RAID disk drive MySQL System Tray mysqladmin utility character-based performance monitoring 2nd mysqlbinlog utility 2nd binary log output 2nd mysqld process locking memory 2nd mysqld utility --log slow queries option slow query log output 2nd -1 option general query log output 2nd mysqldump utility 2nd --add-lock option Mysqldump utility --add-lock option mysqldump utility --delay option --disable-keys option 2nd 3rd --extended-insert option 2nd --no-data option 2nd --where directive 2nd data exports table subsets 2nd databases exporting for testing environments 2nd mysqlimport utility 2nd |
< Day Day Up > |