O

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