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]
C API 4.0 upgrade changes 4.0 upgrading changes version 3.23 upgrade changes C++ compiler executables troubleshooting cache hostnames 2nd key MyISAM storage engine 2nd 3rd MyISAM storage engine, block size MyISAM storage engine, index preloading 2nd MyISAM storage engine, midpoint insertion strategy 2nd MyISAM storage engine, multiple 2nd 3rd MyISAM storage engine, restructuring 2nd MyISAM storage engine, shared access query 2nd configuring 2nd 3rd implementing 2nd 3rd maintaining 2nd SELECT statement options status 2nd tables 2nd 3rd caching optimization Can't connect to local MySQL server (2002) error 2nd 3rd 4th Can't create/write to file error Can't find file error 2nd Can't initialize character set error 2nd case-sensitivity access privilege system database names table names CC environment variable cc1plus troubleshooting certificates X509 SSL (Secure Sockets Layer) certification MySQL AB 2nd CFLAGS environment variable character sets 2nd 3rd 4th adding 2nd 3rd 4th Can't initialize character set error 2nd definition arrays 2nd German 2nd limitations 2nd multi-byte replicating characters wildcard check options myisamchk utility 2nd 3rd checking tables mysqlcheck program 2nd 3rd 4th 5th 6th checkpoints InnoDB storage engine 2nd clauses DISTINCT optimizing 2nd IS NULL indxes optimizing 2nd LEFT JOIN optimizing 2nd 3rd LIMIT optimizing 2nd OR optimizing 2nd ORDER BY optimizing 2nd 3rd 4th RIGHT JOIN optimizing 2nd WHERE optimizing 2nd 3rd 4th clean .idb files 2nd Client does not support authentication protocol error 2nd client libraries linking troubleshooting 2nd client programs multiple servers running 2nd server access clients 4.0 upgrading changes Aborted clients error 2nd compiling Windows startup parameters version 3.23 upgrade changes closing tables 2nd 3rd clustered indexes InnoDB storage engines code source compiling cold MyISAM key cache collating strings columnes types columns AUTO-INCREMENT InnoDB storage engines 2nd BLOB indexing compressed tables 2nd 3rd displaying mysqlshow program 2nd 3rd 4th EXPLAIN statement 2nd 3rd 4th 5th 6th 7th 8th grant tables 2nd 3rd 4th 5th privilege access system 2nd 3rd 4th 5th indexes database optimization 2nd database optimization, multiple columns 2nd TEXT indexing command line invoking programs 2nd multiple servers running (Windows) 2nd 3rd mysqld options 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th options SSL (Secure Sockets Layer) 2nd program options 2nd 3rd 4th 5th startup parameters Windows startup 2nd command-line history .mysql_history file command-line options mysql program 2nd 3rd 4th 5th 6th 7th mysqladmin program 2nd 3rd mysqlcc program 2nd 3rd 4th command-line tools mysql 2nd 3rd auto- reconnect option 2nd commands 2nd 3rd 4th 5th 6th 7th executing statements options 2nd 3rd 4th 5th 6th 7th query results, displaying vertically 2nd safe-updates option 2nd SQL scripts, running variables , setting 2nd commands 2nd shell Commands out of sync error comments starting 2nd commercial licenses contact information commerial licenses 2nd Web sites commerical licenses MySQL AB commerical support types commiting transactions InnoDB storage engines compatibility ANSI/ISO SQL 2nd 3rd ANSI modes 2nd constraints constraints, default values 2nd constraints, ENUM constraints, NOT NULL 2nd constraints, PRIMARY KEY constraints, SET constraints, UNIQUE differences differences, atomic operations 2nd 3rd 4th 5th differences, comments 2nd differences, foreign keys 2nd 3rd differences, SELECT INTO TABLE extension differences, stored procedures differences, subqueries differences, transactions 2nd 3rd 4th 5th differences, triggers differences, views 2nd extensions 2nd 3rd 4th 5th 6th known errors, design issues 2nd 3rd 4th 5th 6th 7th 8th known errors, version 3.23 known errors, version 4.0 SQL modes Oracle PostgreSQL replication versions 2nd upgrading upgrading versions 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 3.21 2nd 3.22 3.23 C API changes 3.23 client changes 3.23 SQL changes 2nd 3rd 3.23 table changes 4.0 C API changes 2nd 4.0 client changes 4.0 password changes 4.0 server changes 2nd 3rd 4th 5th 6th 4.0 SQL changes 2nd 3rd 4th 5th 6th compatiblity protocols compile options binary distributions 2nd compilers C++ executables, troubleshooting internal troubleshooting compiles static compiling clients Windows optimizing 2nd source code speed 2nd 3rd compliance Y2K (Year 2000) 2nd 3rd compress option (mysql program) compress option (mysqlcc program) compressed file formats MyISAM storage engine 2nd compressing tables myisampack program 2nd 3rd myisampack program, columns 2nd 3rd myisampack program, examples 2nd 3rd 4th 5th 6th 7th 8th 9th 10th concurrency multi-versioned concurrency control 2nd Conditional Use logos config.cache file 2nd 3rd 4th 5th 6th 7th configuration options MySQL installations 2nd 3rd 4th 5th --with-charset 2nd --with-collation 2nd --with-extra-charsets 2nd configurations InnoDB storage engine 2nd 3rd 4th 5th 6th 7th 8th 9th 10th my.cnf files 2nd 3rd 4th 5th 6th mysqld server parameters tablespace files, setting up 2nd 3rd Unix option files 2nd Windows option files master/slave setup 2nd MySQL servers mysqld command line options 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 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 server system variables, dynamic 2nd 3rd server system variables, global 2nd 3rd 4th 5th server system variables, 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 server system variables, session 2nd 3rd 4th server system variables, SHOW VARIABLES statement 2nd 3rd 4th 5th server system variables, status 2nd 3rd 4th 5th 6th 7th 8th 9th 10th server system variables, structured 2nd 3rd 4th SQL modes, setting 2nd 3rd 4th 5th SQL modes, special 2nd 3rd SQL modes, supported 2nd 3rd 4th query cache 2nd 3rd configure options MySQL installations 2nd 3rd 4th 5th connect-timeout variable connect_timeout variable 2nd connection_name option (mysqlcc program) connections Aborted connections error 2nd access privilege system 2nd 3rd 4th 5th 6th 7th 8th verification 2nd 3rd 4th 5th 6th 7th Lost connection to server during query error 2nd master/slave setup resources limiting ( user accounts) 2nd Too many connections error 2nd connectivity consistent reads InnoDB storage engine 2nd 3rd 4th 5th non-locking InnoDB storage engine const tables constraints default values 2nd ENUM NOT NULL 2nd PRIMARY KEY SET UNIQUE consulting MySQL AB contact information MySQL AB 2nd contraints FOREIGN KEY InnoDB storage engines 2nd 3rd 4th 5th 6th InnoDB storage engines, indexes 2nd 3rd InnoDB storage engines, SQL standards 2nd 3rd conventions typographical Reference Manual 2nd 3rd 4th converting table types copy on demand copyrights 2nd corrupted MyISAM tables troubleshooting 2nd corrupted tables troubleshooting 2nd costs support counters auto-increment crash recovery error checking 2nd maintenance scheduling 2nd myisamchk utility 2nd 3rd 4th 5th invocation syntax 2nd 3rd memory usage 2nd options 2nd 3rd 4th 5th 6th options, check 2nd 3rd options, repair 2nd 3rd 4th variables 2nd 3rd table optimization table repair 2nd 3rd 4th 5th tables retrieving information 2nd 3rd 4th 5th 6th 7th 8th 9th 10th crash-me program 2nd 3rd 4th crashes troubleshooting 2nd 3rd 4th 5th cryptographic signatures verifying download integrity 2nd 3rd customer support mailing address MySQL AB customer uses 2nd CVS tree MySQL installations 2nd 3rd 4th 5th CXX environment variable CXXFLAGS environment variable
|
| < Day Day Up > |