[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]
C-JDBC (Clustered JDBC)
caching
CPU cache
load-balancing and
MySQL 4.0, cache checking limitations
query cache
server tuning and
write caching
RAID and
catalogs, use of storage engines for
CD-ROM applications, use of storage engines for
CHANGE MASTER TO ... command
check_repl script
clumpy data
cluster partitioning
data-based partitioning
filtering
multicluster partitioning
role-based partitioning
clustered indexes
2nd
potential for degraded performance
CNAME
code example permissions
columns_priv table
2nd
concurrency
[See locking and concurrency]configuration files
client and server section names
command-line arguments
comments
file formats
file locations
key/value pairs
machine size and
reconfiguration
revision control
sample configuration files
my-medium.cnf
server variables, setting
set-variable statements
connection pooling and load-balancing
CPU speed versus main memory speed
CPUs, solving bottlenecks with
CREATE and SELECT table conversion method
creation id
|
لطفا منتظر باشید ...
• 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.
