[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
[X]
queriesanalysis
execution
EXPLAIN output
[See EXPLAIN command]hashing of
index-only queries
optimization
parsing
preventing caching
processing
using the wrong index
whitespace in
query barrels
query cache
query_cache_type
query optimization versus server tuning
query optimizer
2nd
data, insufficient diversity in
full-text versus LIKE
impossible queries
index-based ordering
query performance
influencing with hints
index usage
join order
query cache
result sizes
slow queries, identifying
tricks for improving
two queries instead of one
unions versus ORs
|
لطفا منتظر باشید ...
• Table of Contents
• Index
• Reviews
• Reader Reviews
• Errata
• Academic
High Performance MySQL
By
Derek J. Balling, Jeremy Zawodny
Publisher: OReilly
Pub Date: April 2004
ISBN: 0-596-00306-4
Pages: 294
Slots: 1.0
In High Performance MySQL you will
learn about MySQL indexing and optimization in depth so you
can make better use of these key features. You will learn
practical replication, backup, and load-balancing strategies
with information that goes beyond available tools to discuss
their effects in real-life environments. And youll learn
the supporting techniques you need to carry out these tasks,
including advanced configuration, benchmarking, and
investigating logs.
