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]
Mac OS X MySQL installations 2nd 3rd 4th 5th notes 10.x (Darwin) server 1.2 (Rhapsody) mailing lists 2nd 3rd 4th 5th answering questions archive location 2nd bugs database 2nd 3rd 4th 5th 6th 7th 8th IRC (Internet Relay Chat) postings subscribing/unsubscribing maintaining query cache 2nd maintaining databases myisamchk utility 2nd crash recovery 2nd 3rd error checking 2nd invocation syntax 2nd 3rd memory usage 2nd options 2nd 3rd 4th 5th 6th options, check 2nd 3rd options, repair 2nd 3rd 4th retrieving information 2nd 3rd 4th 5th 6th 7th 8th 9th 10th schedling 2nd table optimization table repair 2nd 3rd 4th 5th variables 2nd 3rd maintaining log files 2nd make_binary_distribution script mapping MERGE tables master servers archiving 2nd 3rd 4th master threads master. info file format 2nd master/slave setup 2nd blocking updates configurations 2nd connections query dates master/slave setups binary logs 2nd max_allowed_packet variable 2nd max_join_size variable 2nd MaxDB databases concepts features 2nd 3rd 4th history 2nd interoperability 2nd licensing reserved words 2nd 3rd 4th 5th 6th resource links versus MySQL 2nd 3rd 4th maximum memory used value (status command) MD5 checksum verifying download integrity 2nd memory determining problems myisamchk utility 2nd optimizing 2nd 3rd Out of memory virtual compiling problems memory in use value (status command) MEMORY storage engine 2nd 3rd 4th 5th features 2nd 3rd 4th MERGE storage engine 2nd 3rd 4th 5th files limitations 2nd problem solving features 2nd remapping troubleshooting 2nd midpoint insertion strategy MyISAM key cache 2nd MIPS Linux notes mirror sites MIT-pthreads MySQL installation 2nd 3rd mode autocommit BDB (BerkeleyDB) storage engine modes ANSI 2nd autocommit InnoDB storage engines, locking for update mode consistent reads, InnoDB storage engines 2nd lock in share consistent reads, InnoDB storage engines 2nd recovery storage engines SQL setting 2nd 3rd 4th 5th special 2nd 3rd supported 2nd 3rd 4th modules 2nd NLM (NetWare Loadable Module) monitors InnoDB 2nd 3rd 4th 5th 6th 7th moving InnoDB storage engines 2nd MRG [period] files MRG_MyISAM engine [See MERGE storage engine] multi-byte character sets Can't initialize character set error 2nd multi-byte characters multi-versioned concurrency control 2nd multi-versioning InnoDB storage engines 2nd multiple columns indexes database optimization 2nd multiple MyISAM key cache 2nd 3rd multiple servers managing mysqld_multi script 2nd 3rd 4th 5th 6th 7th 8th mysqld_multi script, options 2nd 3rd 4th running 2nd 3rd 4th client programs 2nd Unix 2nd 3rd Windows Windows, command line 2nd 3rd Windows, services 2nd 3rd 4th multiple tablespaces InnoDB storage engines 2nd 3rd 4th multiple-table joins 2nd 3rd 4th mutex implementing my.cnf files 2nd InnoDB storage engine 2nd 3rd 4th 5th 6th my_install_db scripts troubleshooting 2nd 3rd MYD [period] file MYI [period] file MyISAM compressed tables 2nd 3rd columns 2nd 3rd examples 2nd 3rd 4th 5th 6th 7th 8th 9th 10th MyISAM storage engine 2nd 3rd 4th automatic recovery 2nd converting to InnoDB storage engines 2nd features file formats compressed 2nd dynamic 2nd fixed 2nd files improvements 2nd 3rd 4th index files key cache 2nd 3rd block size index preloading 2nd midpoint insertion strategy 2nd multiple 2nd 3rd restructuring 2nd shared access startup options 2nd 3rd troubleshooting corruption 2nd proper closure 2nd 3rd MyISAM storage engines queries speed symbolic links 2nd MyISAM tables maximum size 2nd myisamchk myisamchk script myisamchk utility database maintenance 2nd crash recovery 2nd 3rd error checking 2nd invocation syntax 2nd 3rd memory usage 2nd options 2nd 3rd 4th 5th 6th options, check 2nd 3rd options, repair 2nd 3rd 4th retrieving information 2nd 3rd 4th 5th 6th 7th 8th 9th 10th scheduling 2nd table optimization table repair 2nd 3rd 4th 5th variables 2nd 3rd myisampack program options 2nd 3rd 4th tables compressing 2nd 3rd compressing, columns 2nd 3rd compressing, examples 2nd 3rd 4th 5th 6th 7th 8th 9th 10th MySQL defined 2nd 3rd overview 2nd 3rd MySQL 3.23 InnoDB storage engine 2nd MySQL 4.0 features 2nd 3rd 4th embedded server MySQL 4.1 features 2nd 3rd 4th 5th future MySQL 5.0 features future 2nd MySQL 5.1 future 2nd MySQL AB business model certification 2nd commerical licenses consulting contact information 2nd customer support partnerships training 2nd core values overview 2nd MySQL Certification Program Web site MySQL Control Center [See mysqlcc program] MySQL Database Software MySQL Language Reference mysql program 2nd 3rd 4th auto- reconnect option 2nd command-line options 2nd 3rd 4th 5th 6th 7th commands 2nd 3rd 4th 5th 6th 7th executing statements query results displaying vertically 2nd safe-updates option 2nd SQL scripts running variables setting 2nd MySQL server has gone away error 2nd MySQL Web site 2nd MySQL-MAX installing MYSQL-PS1 environment variable mysql.columns_priv tables wildcards mysql.db tables wildcards mysql.host tables wildcards mysql.server script mysql.server startup script 2nd mysql.sock changing location mysql.sock files modifying/protecting 2nd mysql.tables_priv tables wildcards mysql. user tables netmask notation wildcards MYSQL_DEBUG environment variable mysql_fix_privilege_tables script 2nd MYSQL_HISTFILE environment variable mysql_history [period] file MYSQL_HOST environment variable mysql_install_db script MYSQL_PWD environment variable MYSQL_TCP_PORT environment variable MYSQL_UNIX_PORT environment variable mysqlaccess program mysqladmin program 2nd command-line options 2nd 3rd commands 2nd 3rd 4th status command 2nd variables 2nd mysqlbinlog program 2nd 3rd 4th 5th 6th 7th options 2nd 3rd 4th temporary files deleting mysqlbug mailing list postings mysqlbug script 2nd mysqlcc program 2nd 3rd 4th 5th command-line options 2nd 3rd 4th mysqlcheck program 2nd 3rd 4th 5th 6th 7th mysqld command line options 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th startup options security 2nd 3rd mysqld options binary log files mysqld process checking mysqld script mysqld server parameters InnoDB storage engine mysqld servers buffer sizes 2nd 3rd 4th 5th options 2nd 3rd 4th 5th mysqld-max script mysqld-max servers 2nd 3rd 4th 5th BDB storage engines 2nd creating Unix mysqld_multi script mysqld_multi startup script 2nd 3rd 4th 5th 6th 7th 8th options 2nd 3rd 4th mysqld_safe script mysqld_safe startup script 2nd 3rd 4th 5th 6th functions options 2nd 3rd mysqldump 2nd mysqldump program 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th mysqlhotcopy program 2nd 3rd 4th mysqlimport mysqlimport program 2nd 3rd 4th 5th 6th mysqlshow program 2nd 3rd 4th 5th
|
| < Day Day Up > |