High Performance MySQL [Electronic resources]

Derek J. Balling

نسخه متنی -صفحه : 105/ 94
نمايش فراداده

[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