index_S

 < 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) 2nd
Scalable Coherent Interface (SCI)
     connectivity tuning
    sockets
         clustering issues (MySQL Cluster) 2nd
     transporters (nodes)
schemas (tables)
     copying without associated data for export purposes 2nd
searches
     (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 2nd
SET/SELECT command
     character-based performance monitoring 2nd
setting
     isolation levels 2nd
shared 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) 2nd
SHOW MASTER LOGS command
    master servers
         monitoring
SHOW MASTER STATUS command
    master servers
         monitoring
SHOW PROCESSLIST command
     character-based performance monitoring
SHOW SLAVE STATUS command 2nd
SHOW STATUS command
     character-based performance monitoring 2nd 3rd
SHOW TABLES command
     character-based performance monitoring
SHOW TABLES STATUS command
     character-based performance monitoring 2nd 3rd
SHOW VARIABLES command
     character-based performance monitoring 2nd
shutdowns
    InnoDB
         innodb fast shutdown parameter
single variable testing approach
     performance analysis 2nd
sizes
    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 3rd
speed 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) 2nd
SSL
    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 CLUSTER
stored 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 servers
storing
    table columns
         sort order (ALTER TABLE, ORDER BY statement) 2nd
structured 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 >   


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