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] sar utility (Linux) 2ndScalable Coherent Interface (SCI) connectivity tuning sockets clustering issues (MySQL Cluster) 2nd transporters (nodes) schemas (tables) copying without associated data for export purposes 2ndsearches (queries) performance tips data retrieval, controlling 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th internal engine caches, leveraging 2nd joins joins, column consistency joins, numeric versus nonnumeric 2nd 3rd off-loading processing work via replication 2nd security cost reduction 2nd substring searches 2nd 3rd 4th table views 2nd temporary tables 2nd 3rd secondary indexes InnoDB rowid values 2nd security queries cost reductions 2nd segments (InnoDB) extent groupings SELECT STRAIGHT JOIN statement optimizer assistance option 2nd 3rd 4th select type column EXPLAIN command (optimizer) output 2nd 3rd 4th SELECT, INTO OUTFILE STATEMENT reloading data from data export operations 2nd SERIALIZABLE isolation level 2nd servers clustering problems diagnosing (High-Hat Airways) 2nd 3rd 4th resolving (High-Hat Airways) 2nd 3rd 4th 5th database connectivity application control 2nd binary log caching 2nd 3rd concurrency 2nd 3rd dropping due to errors dropping due to inactivity 2nd dropping due to interruptions joins performance optimization factors 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 optimizer control 2nd 3rd 4th sort performance 2nd 3rd table scans 2nd user resource controls 2nd High-Hat Airways outage diagnosis 2nd 3rd 4th outage solution 2nd 3rd 4th 5th 6th performance tips 2nd topology selection 2nd 3rd 4th 5th 6th queries math calculations 2nd 3rd 4th 5th 6th 7th replication design strategy 2nd 3rd 4th 5th 6th master selection 2nd performance, data criteria 2nd performance, master server logging parameters 2nd performance, master server monitoring 2nd 3rd 4th 5th 6th performance, network issues 2nd 3rd 4th 5th 6th 7th performance, overhead reduction 2nd performance, slave server configuration performance, slave server monitoring 2nd 3rd performance, slave server relay logs 2nd performance, slave server resources 2nd 3rd performance, slave server shared workloads 2nd performance, slave server temporary file storage SHOW BINARY LOGS command SHOW BINLOG EVENTS command 2nd SHOW MASTER LOGS command SHOW MASTER STATUS command tuning practices usage criteria 2nd settings scope GLOBAL variables 2nd SESSION variables 2nd stored procedure problems diagnosing (High-Hat Airways) 2nd 3rd 4th resolving (High-Hat Airways) 2nd 3rd services disabling (Linux/Unix 2nd SESSION variables 2nd sessions database connectivity dropping due to errors dropping due to inactivity 2nd dropping due to interruptions SET constraint 2nd 3rd 4th SET TRANSACTION ISOLATION LEVEL statement 2ndSET/SELECT command character-based performance monitoring 2nd setting isolation levels 2ndshared memory clustering issues (MySQL Cluster) 2nd connectivity tuning shared memory transporters (nodes)shared next-key locks InnoDB shared same-record locks InnoDB 2nd shared-nothing nodes shipping option lookups query problems diagnosing (High-Hat Airways) 2nd resolving (High-Hat Airways) 2nd 3rd query problems (High-Hat Airways) 2nd SHOW BINARY LOGS command master servers monitoring SHOW BINLOG EVENTS command master servers monitoring 2nd SHOW ENGINES command character-based performance monitoring 2nd SHOW INDEX command 2nd cardinality column character-based performance monitoring 2nd collation column column_name column comment column index_type column key_name column non-unique column non_unique column null column packed column results output 2nd 3rd 4th interpretation of 2nd sub_part column tables information output SHOW INNODB STATUS command 2nd 3rd character-based performance monitoring 2nd 3rd SHOW INNODB STATUS command (InnoDB) 2ndSHOW MASTER LOGS command master servers monitoringSHOW MASTER STATUS command master servers monitoringSHOW PROCESSLIST command character-based performance monitoring SHOW SLAVE STATUS command 2nd SHOW STATUS command character-based performance monitoring 2nd 3rdSHOW TABLES command character-based performance monitoring SHOW TABLES STATUS command character-based performance monitoring 2nd 3rd SHOW VARIABLES command character-based performance monitoring 2ndshutdowns InnoDB innodb fast shutdown parameter single variable testing approach performance analysis 2ndsizes tables specifying (MyISAM engine)slave servers replicated replication speed configuration practioces data criteria 2nd monitoring 2nd 3rd overhead reduction 2nd relay logs 2nd resource management 2nd 3rd shared workloads 2nd temporary file storage role in replication 2nd 3rd 4th 5th 6th 7th SHOW SLAVE STATUS command 2nd slow query log logging-based performance monitoring 2nd sockets connectivity tuning sorting indexes myisamchk utility 2nd queries performance tips 2nd 3rd 4th sorts sort buffer size variable adjusting 2nd 3rdspeed optimization MyISAM 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 spyware prevention/monitoring Windows tuning tip 2nd SQL BUFFER RESULTS statement 2nd SQL CACHE statement 2nd SQL NO CACHE statement 2nd SQL Node clustering SQL nodes clustering arbitration issues (MySQL Cluster) batching issues (MySQL Cluster) 2ndSSL connection costs tuning tips 2nd statements optimizer assistance options 2nd FORCE INDEX IGNORE INDEX 2nd SELECT STRAIGHT JOIN 2nd 3rd 4th USE INDEX 2nd storage engines selection criteria transaction performance selection options 2nd ARCHIVE Berkeley Database (BDB) CSV 2nd FEDERATED 2nd InnoDB 2nd MaxDB MEMORY 2nd 3rd MERGE 2nd 3rd 4th MyISAM 2nd 3rd 4th 5th 6th 7th 8th 9th NDB CLUSTERstored procedures benefits application logic reduction client workload reduction consistency network traffic reduction security features specialization performance tips extraneous database operations loop selection 2nd table design practices unnecessary procedure creation use of error handlers 2nd use of existing built-in functions server problems diagnosing (High-Hat Airways scenario) 2nd 3rd 4th resolving (High-Hat Airways scenario) 2nd 3rd versus functions 2nd when not to use advanced logic needs one-off operations overloaded databases serversstoring table columns sort order (ALTER TABLE, ORDER BY statement) 2ndstructured testing versus flexible testing performance analysis methods 2nd sub_part column SHOW INDEX command output subqueries use of 2nd subsets (tables) data export granularity 2nd substring searches queries 2nd 3rd 4th symbolic links databases (MyISAM) 2nd system administrators required knowledge for performance optimization 2nd system loads replicating during during testing |
| < Day Day Up > |