MySQL Administrators Guide and Language Reference (2nd Edition)
Index[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] offset option (mysqlbinlog) old-password command (mysqladmin) old-passwords option 2nd 3rd OLD_PASSWORD( ) function old_passwords system variable 2nd old_server option (mysqlaccess) ON UPDATE CASCADE operations ON UPDATE SET NULL operations one-database option (mysql) one-thread option (mysqld) one_shot system variable (mysqld) online backups online manual 2nd ONLY_FULL_GROUP_BY SQL mode open issues for Windows Open Source Database Benchmark suite defined SSH client Web site open tables 2nd open-files option (mysqld_safe script) open-files-limit option (mysqld) Open_files status variable open_files_limit system variable mysqlbinlog mysqld Open_streams status variable Open_tables status variable Opened_tables status variable opening tables OpenSSL operating systems BDB storage engine support Cluster hardware combinations supported crash recovery error codes Linux Windows file-size limits Linux error codes installation RPM Package Manager Mac OS X replication support support Unix [See installation, Unix.] Windows [See installation, Windows.] opt option (mysqldump) optimization benchmarks bottlenecks finding sources Cluster column indexes conditions, deleting constant tables controlling data size DELETE statements design disk performance issues DISTINCT clause expressions, evaluating filesort folding GROUP BY clause hostname caches Index Merge 2nd INSERT statements invalid expressions IS NULL LEFT JOIN LIMIT clause loose index scans memory multi-column indexes MyISAM key cache block buffers 2nd index blocks midpoint insertion strategy multiple preloading restructuring sharing size mysqlcheck default behavior invoking options overview nested joins inner joins nested-loop join algorithm order of execution outer and inner combination outer joins parentheses, deleting pushed-down conditions syntax ORDER BY clause outer joins parentheses, deleting permission checks portability queries performance, estimating resolving with index tree row retrieval speed, increasing very fast examples query speed column length mismatches condition pushdowns constant tables distinct values eq_ref tables Extra column filesorts full table scans index merges index scans indexes join types key length keys LEFT JOIN multiple-table joins possible_keys column ranges ref column ref tables ref_or_null joins rows column SELECT identifier SELECT types subqueries system tables tables temporary tables WHERE clauses ranges multiple-part indexes single-part indexes RIGHT JOIN symbolic links system tables scans, avoiding WHERE clauses tips UPDATE statements WHERE clauses optimization access algorithm optimize option (mysqlcheck) optimizer_prune_level system variable 2nd 3rd optimizer_search_depth system variable 2nd 3rd option files [See IM (Instance Manager), configuration files.] options [See also commands, variables.] add-drop-database add-drop-table add-locks addtodest all-databases mysqlcheck mysqldump all-in-1 allow-keywords allow-suspicious-udfs 2nd allowold analyze myisamchk mysqlcheck ansi auto-rehash auto-repair autoclose backup myisamchk myisampack basedir mysql_upgrade mysqld mysqld_safe batch BDB startup bdb-home bdb-lock-detect bdb-logdir bdb-no-recover bdb-no-sync bdb-shared-data bdb-tmpdir bind-address mysqld mysqlmanager binlog-do-db binlog-format binlog-ignore-db binlog-row-event-max-size block-search bootstrap brief case sensitivity character-set-client-handshake character-set-filesystem character-set-server character-sets-dir myisamchk myisampack mysql mysqladmin mysqlbinlog mysqlcheck mysqld mysqldump mysqlimport mysqlshow check myisamchk mysqlcheck check-only-changed myisamchk mysqlcheck check-upgrade checkpoint chroot mysqld mysqlhotcopy Cluster processes collation-server column-name column-names columns command comments commit compact compatible complete-insert compress mysql mysqladmin mysqlcheck mysqldump mysqlimport mysqlshow config-file mysqld_multi script ndb_mgmd configure connect-string console copy core-file core-file-size correct-checksum count mysqladmin mysqlshow create-options daemon ndb_mgmd ndbd data-file-length database mysql mysqlbinlog databases mysqlcheck mysqldump datadir mysql_upgrade mysqld mysqld_safe db debug myisamchk myisampack mysql mysqlaccess mysqladmin mysqlbinlog mysqlcheck mysqld mysqldump mysqlhotcopy mysqlimport mysqlshow NDB programs debug-info default-character-set mysql mysqladmin mysqlcheck mysqld mysqlimport mysqlshow default-collation default-storage-engine default-table-type default-time-zone defaults-extra-file 2nd defaults-file mysqld_safe mysqlmanager delay-key-write 2nd delayed-insert delete delete-master-logs delimiter des-key-file description disable-bin-log disable-keys dryrun enable-named-pipe example execute mysql NDB programs exit-info extend-check extended extended-insert external-locking fast myisamchk mysqlcheck fields-enclosed-by mysqldump mysqlimport fields-escaped-by mysqldump mysqlimport fields-optionally-enclosed-by mysqldump mysqlimport fields-terminated-by mysqldump mysqlimport first-slave flush flush-logs flushlog force myisamchk myisampack mysql mysql_upgrade mysqladmin mysqlcheck mysqldump mysqlimport force-read help myisamchk myisampack mysql mysql_zap mysqlaccess mysqladmin mysqlbinlog mysqlcheck mysqld mysqld_multi mysqld_safe mysqldump mysqlhotcopy mysqlimport mysqlmanager mysqlshow NDB programs perror programs hex-blob hexdump host mysql mysqlaccess mysqladmin mysqlbinlog mysqlcheck mysqldump mysqlhotcopy mysqlimport mysqlshow howto html i-am-a-dummy ignore ignore-lines ignore-spaces ignore-table information init-file initial InnoDB 2nd innodb innodb-safe-binlog innodb_status_file insert-ignore install join keepold keys keys-used language 2nd large-pages ledir line-numbers lines-terminated-by mysqldump mysqlimport local local-infile mysql mysqld local-load lock-all-tables lock-tables mysqldump mysqlimport log mysqld mysqld_multi script mysqlmanager log-bin log-bin-index log-bin-trust-function-creators log-bin-trust-routine-creators log-error mysqld mysqld_safe log-isam log-long-format log-queries-not-using-indexes log-short-format log-slave-updates log-slow-admin-statements log-slow-queries log-warnings mysqld replication loose low-priority low-priority-updates master-connect-retry master-data master-host master-info-file master-password master-port master-retry-count master-ssl master-ssl-ca master-ssl-capath master-ssl-cert master-ssl-cipher master-ssl-key master-user max-record-length max-relay-log-size maximum medium-check myisamchk mysqlcheck memlock method monitoring-interval multiple servers MyISAM storage engine myisam-recover 2nd myisamchk analyze block-search debug description help repair set-auto-increment silent sort-index sort-records table checking verbose version wait myisamlog myisampack backup character-sets-dir debug force help join packlength silent test tmpdir verbose version wait mysql auto-rehash batch character-sets-dir column-names compress database debug debug-info default-character-set delimiter execute force help host html i-am-a-dummy ignore-spaces line-numbers local-infile named-commands no-auto-rehash no-beep no-named-commands no-pager no-tee one-database pager password port prompt protocol quick raw reconnect safe-updates secure-auth show-warnings sigint-ignore silent skip-column-names skip-line-numbers socket table tee unbuffered user verbose version vertical wait xml mysql_zap mysqlaccess brief commit copy db debug help host howto old_server password plan preview relnotes rhost rollback spassword superuser table user version mysqladmin character-sets-dir compress count debug default-character-set force help host mysqld_multi password port protocol relative silent sleep socket user verbose version vertical wait mysqlbinlog character-sets-dir database debug disable-log-bin force-read help hexdump host local-load offset password port position protocol read-from-remote-server result-file short-form socket start-datetime start-position stop-datetime stop-position to-last-log user version mysqlcheck all-databases all-in-1 analyze auto-repair character-sets-dir check check-only-changed check-upgrade compress databases debug default-character-set extended fast force help host medium-check optimize password port protocol quick repair silent socket tables use-frm user verbose version mysqld bdb-home bdb-lock-detect bdb-logdir bdb-no-recover bdb-no-sync bdb-shared-data bdb-tmpdir mysqld_multi mysqld_safe ndb-connectstring ndbcluster skip-bdb sync-bdb-logs mysqld-path mysqld-version mysqldump add-drop-database add-drop-table add-locks all-databases allow-keywords character-sets-dir comments compact compatible complete-insert compress create-options databases debug default-character-set delayed-insert delete-master-logs disable-keys extended-insert fields-enclosed-by fields-escaped-by fields-optionally-enclosed-by fields-terminated-by first-slave flush-logs force help hex-blob host ignore-table insert-ignore lines-terminated-by lock-all-tables lock-tables master-data no-autocommit no-create-db no-create-info no-data opt order-by-primary password port protocol quick quote-names result-file routines set-charset single-transaction skip-comments socket tab tables triggers tz-utc user verbose version where xml mysqlhotcopy addtodest allowold checkpoint chroot debug dryrun flushlog help host keepold method noindices password port quiet record_log_pos regexp resetmaster resetslave socket suffix tmpdir user mysqlimport character-sets-dir columns compress debug default-character-set delete fields-enclosed-by fields-escaped-by fields-optionally-enclosed-by fields-terminated-by force help host ignore ignore-lines lines-terminated-by local lock-tables low-priority password port protocol replace silent socket user verbose version mysqlmanager mysqlshow character-sets-dir compress count debug default-character-set help host keys password port protocol show-table-type socket status user verbose version named-commands ndb NDB programs ndb-connectstring 2nd ndb_mgm ndb_mgmd ndbcluster 2nd ndbd nice no-auto-rehash no-autocommit no-beep no-create-db no-create-info no-data no-defaults 2nd no-log no-named-commands no-pager no-tee nodaemon ndb_mgmd ndbd noindices nonguarded nostart offset old-passwords 2nd 3rd old_server one-database one-thread open-files open-files-limit opt optimize order-by-primary packlength pager parallel-recover passwd password mysql mysqlaccess mysqladmin mysqlbinlog mysqlcheck mysqld_multi script mysqldump mysqlhotcopy mysqlimport mysqlshow password-file perror pid-file multiple servers mysqld mysqld_safe mysqlmanager plan port multiple servers mysql mysqladmin mysqlbinlog mysqlcheck mysqld mysqld_safe mysqldump mysqlhotcopy mysqlimport mysqlmanager mysqlshow port-open-timeout position precedence preview print-defaults 2nd programs command line descriptions of option files program variables specifying with environment variables prompt protocol mysql mysqladmin mysqlbinlog mysqlcheck mysqldump mysqlimport mysqlshow query cache quick myisamchk mysql mysqlcheck mysqldump quiet quote-names raw read-from-remote-server read-only myisamchk replication reconnect record_log_pos recover regexp relative relay-log relay-log-index relay-log-info-file relay-log-purge relay-log-space-limit relnotes remove repair replace replace utility replicate-do-db replicate-do-table replicate-ignore-db replicate-ignore-table replicate-rewrite-db replicate-same-server-id replicate-wild-do-table replicate-wild-ignore-table replication log-slave-updates log-warnings master-connect-retry master-host master-info-file master-password master-port master-retry-counts master-ssl master-ssl-ca master-ssl-capath master-ssl-cert master-ssl-cipher master-ssl-key master-user max-relay-log-size read-only relay-log relay-log-index relay-log-info-file relay-log-purge relay-log-space-limit replicate-do-db replicate-do-table replicate-ignore-db replicate-rewrite-db replicate-same-server-id replicate-wild-do-table replicate-wild-ignore-table replicate_ignore_table report-host report-port skip-slave-start slave-load-tmpdir slave-net-timeout slave-skip-errors slave_compressed_protocol report-host report-port resetmaster resetslave result-file mysqlbinlog mysqldump rhost rollback routines run-as-service safe-mode safe-recover safe-show-database 2nd safe-updates 2nd safe-user-create 2nd secure-auth mysql mysqld 2nd set-auto-increment set-character-set set-charset set-collation shared-memory shared-memory-base-name multiple servers mysqld short-form show-table-type show-warnings shutdown-delay sigint-ignore silent myisamchk myisampack mysql mysqladmin mysqlcheck mysqld_multi script mysqlimport perror single-transaction skip-bdb 2nd skip-column-names skip-comments skip-concurrent-insert skip-external-locking skip-grant-tables 2nd skip-host-cache skip-innodb skip-line-numbers skip-name-resolve 2nd skip-ndbcluster skip-networking 2nd skip-safemalloc skip-show-database 2nd skip-slave-start skip-stack-trace skip-symbolic-links skip-thread-priority slave-load-tmpdir slave-net-timeout slave-skip-errors slave_compressed_protocol sleep socket multiple servers mysql mysqladmin mysqlbinlog mysqlcheck mysqld mysqld_safe mysqldump mysqlhotcopy mysqlimport mysqlmanager mysqlshow sort-index sort-records sort-recover spassword sql-mode SQL_CACHE SQL_NO_CACHE ssl ssl-ca ssl-capath ssl-cert ssl-cipher ssl-key standalone mysqld mysqlmanager start-datetime start-position startup status stop-datetime stop-position suffix superuser symbolic-links sync-bdb-logs tab table mysql mysqlaccess tables mysqlcheck mysqldump tcp-ip tee temp-pool test timezone tmpdir myisamchk myisampack mysqld mysqlhotcopy to-last-log transaction-isolation triggers try-reconnect tz-utc unbuffered unpack update-state use-frm USE_SYMDIR user mysql mysql_upgrade mysqlaccess mysqladmin mysqlbinlog mysqlcheck mysqld mysqld_multi mysqld_safe mysqldump mysqlhotcopy mysqlimport mysqlmanager mysqlshow verbose myisamchk myisampack mysql mysql_upgrade mysqladmin mysqlcheck mysqld_multi script mysqldump mysqlimport mysqlshow perror version myisamchk myisampack mysql mysqlaccess mysqladmin mysqlbinlog mysqlcheck mysqld mysqld_multi script mysqldump mysqlimport mysqlmanager mysqlshow NDB programs perror vertical mysql mysqladmin wait myisamchk myisampack mysql where with-bdb with-big-tables with-blackhole-storage-engine with-charset with-collation with-csv-storage engine with-debug with-embedded-server with-example-storage-engine with-extra-charsets with-federated-storage-engine with-innodb with-mit-threads with-ndbcluster with-server-suffix without-server xml mysql mysqldump Oracle compatibility ORACLE SQL mode ORDER BY clause order-by-primary option (mysqldump) outer joins embedding outer join conversions inner join combination nested-loop join algorithms null-rejected conditions operation conversions optimizing pushed-down conditions output paging |
Категории