MySQL AB MySQL Administrator[ap]s Guide
| < Day Day Up > |
| [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] [Y] [Z]
one-database option (mysql program) Open Source defined Open Source Database Benchmark Open Source license open tables counting open tables value (status command) OpenBSD 2.5 notes OpenBSD 2.8 notes opening tables 2nd 3rd OpenPGP Web site opens value (status command) operating systems BDB (BerkeleyDB) storage engine 2nd BeOS notes BSD Unix notes FreeBSD 2nd 3rd NetBSD OpenBSD 2.5 OpenBSD 2.8 version 2.x version 3.x version 4.x error codes InnoDB storage engines 2nd 3rd 4th 5th 6th 7th 8th file- size limits 2nd Linux notes Alpha 2nd binary distributions 2nd 3rd IA-64 MIPS post-installations 2nd 3rd 4th PowerPC source distributions 2nd 3rd SPARC version 2.0 x86 2nd Mac OS X notes 10.x (Darwin) server 1.2 (Rhapsody) OS/2 notes 2nd Solaris notes 2nd 3rd 4th version x86 versions 2.7/2.8 2nd 3rd supported 2nd 3rd 4th Unix notes Alpha-DEC-OSF/1 2nd 3rd Alpha-DEC-Unix (Tru64) 2nd 3rd HP-UX version 10.20 2nd HP-UX version 11.x 2nd 3rd IBM-AIX 2nd 3rd 4th SCO 2nd 3rd 4th SCO UnixWare version 7.1.x 2nd SGI Irix 2nd 3rd SunOS 4 operations atomic 2nd 3rd 4th 5th opn_files_limit variable optimization bottlenecks 2nd compiling 2nd 3rd databases design 2nd index columns 2nd index columns, multiple 2nd indexes, hash indexes, IS NULL clause indexes, leftmost prefix indexes, LIKE values indexes, storing indexes, uses of 2nd 3rd 4th 5th MyISAM key cache 2nd 3rd MyISAM key cache, block size MyISAM key cache, index preloading 2nd MyISAM key cache, midpoint insertion strategy 2nd MyISAM key cache, multiple 2nd 3rd MyISAM key cache, restructuring 2nd MyISAM key cache, shared access reducing size 2nd tables, open tables, opening/closing 2nd 3rd tables, reducing number of linking 2nd 3rd locking 2nd 3rd methods 2nd 3rd 4th table-level, limitations 2nd 3rd 4th memory 2nd 3rd overview 2nd benchmarks 2nd 3rd benchmarks, performance 2nd customer uses 2nd design benefits/limitations 2nd design portability 2nd 3rd queries 2nd DELETE DISTINCT clauses 2nd estimating performance 2nd EXPLAIN statement 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th EXPLAIN statement, columns 2nd 3rd 4th 5th 6th 7th 8th EXPLAIN statement, multiple-table joins 2nd 3rd 4th INSERT 2nd 3rd 4th IS NULL clauses 2nd LEFT JOIN clauses 2nd 3rd LIMIT clauses 2nd OR clauses 2nd ORDER BY clauses 2nd 3rd 4th RIGHT JOIN clauses 2nd SELECT statement speed table scans , avoiding tips 2nd 3rd 4th 5th 6th UPDATE WHERE clauses 2nd 3rd server parameters tuning 2nd 3rd 4th 5th system 2nd optimizations disks 2nd 3rd filesystem parameters hdparm command RAID spindles striping symbolic links 2nd symbolic links, Unix databases 2nd symbolic links, Unix tables 2nd 3rd symbolic links, Windows databases 2nd optimizing DNS 2nd tables myisamchk utility option arguments option files program options 2nd 3rd 4th 5th 6th 7th 8th clients command line non-empty lines 2nd shell scripts syntax 2nd 3rd Unix Windows options command-line mysql program 2nd 3rd 4th 5th 6th 7th mysqladmin program 2nd 3rd mysqlcc program 2nd 3rd 4th replication startup 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th master. info file format 2nd statement execution 2nd 3rd OR clauses optimizing 2nd OR Index Merge optimization 2nd Oracle compatibility ORDER BY clauses optimizing 2nd 3rd 4th OS/2 notes 2nd Out of memory error
|
| < Day Day Up > |