[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]
B-tree indexes
backups
custom scripts, writing
data compression and
filesystem snapshots
offline backups
online versus offline
planning
dumps versus raw backups
raw backups
reasons for performing
auditing
disaster recovery
testing
recovery
[See recovery]replication and
2nd
retention of old backups
storage demands and media
table types and consistency
tools
InnoDB Hot Backup
mysqldump
mysqlhotcopy
mysqlsnapshot
balanced tree (B-tree) indexes
BDB storage engine
[See Berkeley DB storage engine]BDB tables
[See Berkeley DB storage engine]BEGIN statement
bench_example script
benchmarking
importance
performance testing versus stress testing
questions answered by
strategies
testing methodology
client numbers
client/server separation
isolating the variable
iterative testing
real data
repetition
tools
MyBench
[See MyBench]MySQL Benchmark Suite
[See MySQL Benchmark Suite]MySQL super-smack
[See MySQL super-smack]scripting solutions
[See MyBench]Windows and
Berkeley DB (BDB) storage engine
2nd
indexes
refreshing statistics
primary keys and
binary installations, MySQL.com binaries versus distribution binaries
binary logs
resetting
buffers
bulletin boards, use of storage engines for
|
لطفا منتظر باشید ...
• 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.
