[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]
ibbackup (Hot Backup Tool)
IDE versus SCSI disks
implicit commits
in-memory (Heap) tables
[See Heap tables]index privilege
indexes
B-tree indexes
clustered indexes
potential for degraded performance
constraints, used as
database indexes
full-text indexes
hash indexes
index order
index structures
index-only queries
index-organized tables
keys and
limitations
corruption
poor statistics
regular expressions
too many matching rows
wildcard matches
maintenance
obtaining information
refreshing statistics
multicolumn indexes
NULLs
partial indexes
queries against the wrong index
query optimization and
data, insufficient diversity in
full-text indexes versus LIKE
index-based ordering
index-related hints
R-tree indexes
secondary indexes
table types and
Berkeley DB (BDB) storage engine
Heap tables
InnoDB storage engine
MyISAM storage engine
tradeoffs, costs versus advantages
unique indexes
versus primary keys
usage, verifying
[See EXPLAIN command]Innobase
Innobase Oy
InnoDB Hot Backup tool
InnoDB storage engine
2nd
buffer pool
clustered indexes
indexesrefreshing statistics
indexes and
locking and concurrency
primary keys and
referential integrity
SHOW INNODB STATUS command
storage
InnoDB tables
[See InnoDB storage engine]innodb_buffer_pool_size
installing MySQL
iostat
ISAM (Index Sequential Access Method) table format
isolation levels
ANSI SQL
setting
|
لطفا منتظر باشید ...
• 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.
