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]
safe-updates option (mysql program) 2nd 3rd safe_mysqld startup script [See mysqld_safe startup script] Sakila SAP DB [See MaxDB databases] scalability scans table avoiding scheduling table maintenance 2nd SCO notes 2nd 3rd 4th SCO UnixWare version 7.1.x notes 2nd scope columns grant tables 2nd 3rd 4th 5th scripts benchmarks mysql_fix_privilege_tables mysql_install_db troubleshooting 2nd 3rd mysqlbug Perl mysqlhotcopy program 2nd 3rd server startup SQL running startup 2nd 3rd 4th 5th mysql.server 2nd mysqld_multi 2nd 3rd 4th 5th 6th 7th 8th mysqld_multi, options 2nd 3rd 4th mysqld_safe 2nd 3rd 4th 5th 6th mysqld_safe, functions mysqld_safe, options 2nd 3rd searches MySQL Web pages 2nd secondary indexes InnoDB storage engines Secure Shell (SSH) user accounts 2nd Secure Sockets Layer (SSL) command line options 2nd encryption GRANT statement options requirements setting 2nd 3rd 4th 5th SSH (Secure Shell) 2nd X509 certificates security 2nd access privilege system Access denied errors 2nd 3rd 4th 5th 6th 7th 8th administrative privileges 2nd changes, implementing 2nd connecting 2nd 3rd 4th 5th 6th 7th 8th connecting, verification 2nd 3rd 4th 5th 6th 7th functions grant tables 2nd 3rd 4th 5th grant tables, columns 2nd 3rd 4th 5th password hashing 2nd 3rd 4th 5th 6th password hashing, limitations password hashing, version 4.1.0 requests , verification 2nd 3rd 4th 5th accounts 2nd 3rd 4th 5th 6th attacks avoiding 2nd 3rd guidelines 2nd 3rd 4th 5th LOAD DATA LOCAL statement 2nd LOAD DATA statement mysqld startup options 2nd 3rd passwords 2nd seeks disk seeks segments tablespaces SELECT statement options SELECT statements optimizing 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 speed select_limit select_limit variable sequential read-aheads InnoDB storage engines server administration mysqladmin program command-line options 2nd 3rd commands 2nd 3rd 4th status command 2nd variables 2nd server option ( mysqlcc program) server parameters tuning 2nd 3rd 4th 5th server startup scripts server system variables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st dynamic 2nd 3rd global 2nd 3rd 4th 5th 6th options 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th session 2nd 3rd SHOW VARIABLES statement 2nd 3rd 4th 5th status 2nd 3rd 4th 5th 6th 7th 8th 9th 10th options 2nd 3rd 4th 5th 6th 7th 8th SHOW STATUS statement 2nd 3rd structured 2nd 3rd 4th servers 4.0 upgrade changes 2nd 3rd 4.0 upgrading changes 2nd 3rd accessing client programs embedded version 4.0 master archiving 2nd 3rd 4th master/slave binary logs 2nd master/slave setup 2nd blocking updates configurations 2nd connections query dates multiple managing, mysqld_multi script 2nd 3rd 4th 5th 6th 7th 8th running 2nd 3rd 4th running, client programs 2nd running, Unix 2nd 3rd running, Windows 2nd 3rd 4th 5th 6th 7th 8th mysqld buffer sizes 2nd 3rd 4th 5th options 2nd 3rd 4th 5th mysqld-max 2nd 3rd 4th 5th BDB storage engines 2nd creating Unix shutdown 2nd 3rd 4th 5th startup 2nd 3rd 4th 5th troubleshooting 2nd 3rd 4th 5th Unix restarting shutdown starting Web running Windows 2nd 3rd starting 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th versus Unix 2nd 3rd 4th 5th services multiple servers running (Windows) 2nd 3rd 4th session system variables 2nd 3rd 4th SET contraints SET PASSWORD statement 2nd 3rd setup post-installation account security 2nd 3rd 4th 5th 6th startup, troubleshooting 2nd 3rd 4th 5th startup/shutdown 2nd 3rd 4th 5th Unix procedures 2nd 3rd 4th 5th 6th 7th 8th 9th Unix procedures, troubleshooting mysql_install_db 2nd 3rd Windows procedures 2nd SGI Irix notes 2nd 3rd shared access MyISAM key cache shell command shell scripts startup parameters shell syntax SHOW INNODB STATUS statement 2nd 3rd 4th 5th 6th 7th SHOW STATUS statement 2nd 3rd SHOW VARIABLES statement 2nd 3rd 4th 5th showing database information mysqlshow program 2nd 3rd 4th shutdown servers 2nd 3rd 4th 5th Unix servers shutdown_timeout variable signatures cryptographic verifying download integrity 2nd 3rd silent option (mysql program) single-sweep multi-join method sites [See Web sites] skip-column- names option (mysql program) skip-line- numbers option (mysql program) slave threads 2nd 3rd I/O 2nd 3rd SQL slow log files 2nd slow queries value (status command) SMP (symmetric multi-processor) snapshots master servers 2nd 3rd 4th socket files modifying/protecting 2nd socket option (mysqlcc program) socket= path option (mysql program) sockets changing locations 2nd Solaris notes 2nd 3rd 4th version x86 versions 2.7/2.8 2nd 3rd troubleshooting sorting character sets 2nd German 2nd grant tables 2nd indexes source code compiling source distribution choosing 2nd 3rd 4th 5th 6th 7th source distributions Linux 2nd 3rd MySQL installations 2nd 3rd 4th 5th 6th 7th commands 2nd configure options 2nd 3rd 4th 5th development source tree 2nd 3rd 4th 5th MIT-pthreads 2nd 3rd testing troubleshooting 2nd 3rd 4th 5th 6th 7th Windows 2nd Windows, compiling clients Windows, source packages 2nd Windows, VC++ 2nd 3rd 4th MySQL installations, requirements 2nd source packages MySQL installations Windows 2nd SPARC Linux notes speed compiling 2nd 3rd increasing via replication linking 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 optimization tips 2nd 3rd 4th 5th 6th OR clauses 2nd ORDER BY clauses 2nd 3rd 4th RIGHT JOIN clauses 2nd SELECT statement table scans, avoiding UPDATE WHERE clauses 2nd 3rd 4th spindles disks SQL 4.0 upgrade changes 2nd 3rd 4.0 upgrading changes 2nd 3rd modes version 3.23 upgrade changes 2nd 3rd SQL (Structured Query Language) defined SQL modes setting 2nd 3rd 4th 5th special 2nd 3rd supported 2nd 3rd 4th SQL scripts running SQL slave threads SQL standards FOREIGN KEY constraints InnoDB storage engines 2nd 3rd SQL-92 extensions sql_yacc.cc troubleshooting square brackets ([]) SSH (Secure Shell) user account 2nd SSL (Secure Sockets Layer) command line options 2nd encryption GRANT statement options requirements setting 2nd 3rd 4th 5th SSH (Secure Shell) 2nd X509 certificates stability 2nd standards compliance 2nd 3rd ANSI modes 2nd constraints default values 2nd ENUM NOT NULL 2nd SET UNIQUE constraints, PRIMARY KEY known errors design issues 2nd 3rd 4th 5th 6th 7th 8th version 3.23 version 4.0 MySQL differences atomic operations 2nd 3rd 4th 5th comments;starting 2nd foreign keys 2nd 3rd SELECT INTO TABLE extension stored procedures subqueries transactions 2nd 3rd 4th 5th triggers views 2nd SQL extensions 2nd 3rd 4th 5th 6th SQL modes startup automatic replication options 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th master. info file format 2nd statement execution 2nd 3rd running normal user accounts 2nd servers 2nd 3rd 4th 5th troubleshooting 2nd 3rd 4th 5th Unix servers Windows servers 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th versus Unix 2nd 3rd 4th 5th startup parameters 2nd 3rd 4th 5th BDB (BerkeleyDB) storage engine 2nd 3rd InnoDB storage engine 2nd 3rd 4th 5th 6th MyISAM storage engines 2nd 3rd mysql program 2nd 3rd 4th 5th 6th 7th mysqladmin program 2nd 3rd mysqlcc program 2nd 3rd 4th mysqld security 2nd 3rd programs 2nd 3rd 4th 5th 6th 7th clients command line non-empty lines 2nd shell scripts syntax 2nd 3rd Unix Windows tuning 2nd startup scripts 2nd 3rd 4th 5th mysql.server 2nd mysqld_multi 2nd 3rd 4th 5th 6th 7th 8th mysqld_multi, options 2nd 3rd 4th mysqld_safe 2nd 3rd 4th 5th 6th functions options 2nd 3rd servers statements EXPLAIN 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th columns 2nd 3rd 4th 5th 6th 7th 8th multiple-table joins 2nd 3rd 4th GRANT 2nd 3rd 4th 5th options INSERT 2nd 3rd 4th LOAD DATA LOAD DATA LOCAL 2nd SELECT optimizing 2nd optimizing, EXPLAIN statement 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd options SET PASSWORD 2nd 3rd SHOW INNODB STATUS 2nd 3rd 4th 5th 6th 7th SPEED speed static compiles static file formats MyISAM storage engine 2nd status query cache 2nd status command status command (mysqladmin program) results 2nd status files 2nd 3rd status system variables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th options 2nd 3rd 4th 5th 6th 7th 8th SHOW STATUS statement 2nd 3rd storage [See also databases] storage engines BDB (BerkeleyDB) 2nd autocommit mode errors 2nd features 2nd 3rd files installing limitations operating systems 2nd startup parameters 2nd 3rd troubleshooting choosing 2nd 3rd 4th InnoDB backup/recover, fuzzy checkpoints 2nd backup/recovery 2nd 3rd backup/recovery, forcing recovery 2nd configuring 2nd 3rd 4th 5th 6th 7th 8th 9th 10th configuring, my.cnf files 2nd 3rd 4th 5th 6th configuring, mysqld server parameters configuring, tablespace files 2nd 3rd configuring, Unix option files 2nd configuring, Windows option files contact information creating creating, AUTO_INCREMENT column 2nd creating, converted MyISAM tables 2nd creating, FOREIGN KEY constraints 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th creating, per-table tablespaces 2nd 3rd 4th creating, replication 2nd creating, transactions 2nd data files, adding/removing 2nd defragmenting tables doublewrite dumping error handling error handling, error codes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th fields file space management 2nd I/O (input/output) I/O (input/output), raw disk partitions 2nd indexes 2nd indexes, clustered indexes, hash indexes, insert buffering indexes, non-clustered indexes, record structure 2nd 3rd locking locking, autocommit mode locking, consistent non-locking reads locking, consistent reads 2nd 3rd 4th 5th locking, next -key locking 2nd locking, setup 2nd 3rd locking, transaction isolation levels 2nd 3rd locking, transactions 2nd 3rd 4th 5th log files, adding/removing 2nd moving 2nd multi-versioning 2nd overview 2nd performance tuning 2nd 3rd performance tuning, InnoDB Monitors 2nd 3rd 4th 5th 6th 7th read-aheads restrictions 2nd 3rd 4th startup parameters 2nd 3rd 4th 5th 6th tablespaces, creating 2nd tablespaces, segments tablespaces, sizing tablespaces, troubleshooting initialization troubleshooting troubleshooting, data dictionary operations 2nd 3rd undo logs version 3.23 2nd ISAM 2nd 3rd converting files versus MyISAM storage engine 2nd MEMORY 2nd 3rd 4th 5th features 2nd 3rd 4th MERGE 2nd 3rd 4th 5th files limitations 2nd problem solving features 2nd remapping troubleshooting 2nd MyISAM 2nd 3rd 4th automatic recovery 2nd converting to InnoDB storage engines 2nd features file formats file formats, compressed 2nd file formats, dynamic 2nd file formats, fixed 2nd files improvements 2nd 3rd 4th index files key cache 2nd 3rd key cache, block size key cache, index preloading 2nd key cache, midpoint insertion strategy 2nd key cache, multiple 2nd 3rd key cache, restructuring 2nd key cache, shared access query speed startup options 2nd 3rd symbolic links 2nd troubleshooting, corruption 2nd troubleshooting, proper closure 2nd 3rd recovery mode server startup troubleshooting stored procedures storing indexes temporary files 2nd string indexes string replacement replace program 2nd strings collating striping Structured Query Language (SQL) defined structured system variables 2nd 3rd 4th subqueries SunOS 4 notes Super Smack Web site support mailing address symbolic links 2nd Unix databases 2nd 3rd 4th Unix tables 2nd 3rd symlinks tables symmetric multi-processor (SMP) synchronization data dictionaries InnoDB storage engines) 2nd syntax global variables myisamchk utility 2nd 3rd session variables shell startup parameters 2nd 3rd syntax option (mysqlcc program) syntax_file option (mysqlcc program) system log files determining problems system requirements Windows 2nd system tables systems optimizing 2nd
|
| < Day Day Up > |