[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]
max_connections
McKusick, Kirk
MD5( )
memory
bottlenecks, solving
impact on server performance
Merge tables
2nd
mirroring
missing temporary tables, problems caused by
multi-master load-balancing
multi-master replication configuration
multicolumn indexes
multiple servers, configuration files for
MVCC (Multi-Version Concurrency Control)
my-medium.cnf file
MyBench
2nd
[See also benchmarking]
bench_example script
fork_and_work( ) subroutine
.MYD file types
.MYI file types
MyISAM storage engine
automatic repair
compressed tables
delayed key writes
2nd
full-text indexes
indexes
refreshing statistics
indexes and
indexes in
indexing
key buffer
locking and concurrency
Merge tables
2nd
packed keys
prefix compression
RAID tables
read queries and
REPAIR TABLE command
row counting speed
storage
table size
MyISAM tables
[See MyISAM storage engine]
myisamchk command-line tool
mysnap.pl
output
MySQL
ANSI standard isolation levels, support for
architecture
distributions, compared
installations, binary versus source
load-balancing compared to HTTP
online documentation
performance, monitoring
platforms
support, binary distributions
versions
MySQL 4.0, cache checking limitations
MySQL Benchmark Suite
2nd
[See also benchmarking]
insert test
logging
multi-CPU machines and
testing non-MySQL servers
mysql command interpreter, \G escape
MySQL super-smack
2nd
[See also benchmarking]
configuring
delim option
dictionaries
example benchmarks
gen-data command
installing
obtaining
smack file
test data, preparing
mysql.server startup script
mysql_pconnect( )
mysqladmin command, using for offline backups
mysqlbinlog utility
2nd
mysqld_safe command line
mysqldiff script
mysqldump
2nd
3rd
mysqldumpslow
mysqlhotcopy
2nd
mysqlsnapshot
2nd
mytop
command-line arguments
common tasks
configuration
display modes
command view
status view
thread view
installation
long-running queries, management using
query statistics, collection with
required Perl modules
supported operating systems
web site
|
لطفا منتظر باشید ...
• 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.
