M

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]

Mac OS X
mailing lists
     answering questions
     Cluster
     guidelines
     listing of
     MaxDB
     MySQL security
     net etiquette
     non-English
     subscribing/unsubscribing
maintenance
     log files
    MyISAM tables [See analyze option, myisamchk.]
     mysqlcheck
         default behavior
         invoking
         options
         overview
     query cache
     tables 2nd
make_binary_distribution program
management clients [See also options, ndb_mgm.]
management nodes
     configuring
     defined
     installing
     multiple
management server process [See config-file option, ndb_mgmd.]
manual
     formats available
     online location
     online searches
     typographical conventions
master servers
     forcing to block updates
     multiple-master replication
master thread states (replication)
master-connect-retry option
master-data option
master-host option
master-info-file option
master-password option
master-port option
master-retry-count option
master-ssl option
master-ssl-ca option
master-ssl-capath option
master-ssl-cert option
master-ssl-cipher option
master-ssl-key option
master-user option
master.info file
master/slave replication setup
max-record-length option (myisamchk)
max-relay-log-size option
max_allowed_packet system variable
     mysql
     mysqld
     mysqldump
max_binlog_cache_size system variable 2nd
max_binlog_size system variable 2nd
max_connect_errors system variable 2nd
max_connections system variable 2nd
MAX_CONNECTIONS_PER_HOUR system variable
max_delayed_threads system variable 2nd
max_error_count system variable 2nd
max_heap_table_size system variable 2nd
max_insert_delayed_threads system variable 2nd
max_join_size system variable 2nd 3rd
max_length_for_sort_data system variable (mysqld)
MAX_QUERIES_PER_HOUR system variable
max_relay_log_size system variable 2nd
max_seeks_for_key system variable 2nd
max_sort_length system variable 2nd
max_tmp_tables system variable 2nd
MAX_UPDATES_PER_HOUR system variable
Max_used_connections status variable
max_user_connections system variable 2nd 3rd
max_write_lock_count system variable 2nd
MaxDB
     defined
     features
     history
     interoperability with MySQL
     library
     licensing
     Loader
     mailing list
     MySQL, compared
     support
     Synchronization Manager
     training classes
     Web forum
     Web site
maximum option (mysqld)
MaxNoOfAttributes parameter (config.ini file)
MaxNoOfConcurrentIndexOperations parameter (config.ini file)
MaxNoOfConcurrentOperations parameter (config.ini file)
MaxNoOfConcurrentScans parameter (config.ini file)
MaxNoOfConcurrentTransactions parameter (config.ini file)
MaxNoOfFiredTriggers parameter (config.ini file)
MaxNoOfIndexes parameter (config.ini file)
MaxNoOfLocalOperations parameter (config.ini file)
MaxNoOfLocalScans parameter (config.ini file)
MaxNoOfOrderedIndexes parameter (config.ini file)
MaxNoOfSavedMessages parameter (config.ini file)
MaxNoOfTables parameter (config.ini file)
MaxNoOfTriggers parameter (config.ini file)
MaxNoOfUniqueHashIndexes parameter (config.ini file)
MaxScanBatchSize parameter (config.ini file)
MD5 checksums
medium-check option
     myisamchk
     mysqlcheck
memlock option (mysqld)
memory
     allocation
     Cluster
         index
         requirements
     data nodes
     in-memory storage
     index
     maximum allocation
     myisamchk
     optimizing
MEMORY storage engine 2nd
MERGE storage engine
     advantages
     disadvantages
     forum
     overview
     problems
     queries, issuing
     remapping
     tables, creating
metadata objects (Cluster) 2nd
method option (mysqlhotcopy)
methods
     Index Merge
     locking
     range access
MGM (management) node
Microsoft
    Windows [See installation, Windows.]
     WiX
midpoint insertion strategy
mirror sites for downloads
MIT-pthreads package
mixed hardware architectures
modes (SQL) 2nd
     ALLOW_INVALID_DATES
     ANSI 2nd
     ANSI_QUOTES
     DB2
     default
     ERROR_FOR_DIVISION_BY_ZERO
     HIGH_NOT_PRECEDENCE
     IGNORE_SPACE
     MAXDB
     MSSQL
     MYSQL323
     MYSQL40
     NO_AUTO_CREATE_USER
     NO_AUTO_VALUE_ON_ZERO
     NO_BACKSLASH_ESCAPES
     NO_DIR_IN_CREATE
     NO_ENGINE_SUBSTITUTION
     NO_FIELD_OPTIONS
     NO_KEY_OPTIONS
     NO_TABLE_OPTIONS
     NO_UNSIGNED_SUBTRACTION
     NO_ZERO_DATE
     NO_ZERO_IN_DATE
     ONLY_FULL_GROUP_BY
     ORACLE
     PIPES_AS_CONCAT
     POSTGRESQL
     REAL_AS_FLOAT
     STRICT 2nd
     STRICT_ALL_TABLES
     STRICT_TRANS_TABLES 2nd
     TRADITIONAL 2nd
modules, listing of
monitoring
     performance
     server status
monitoring-interval option (mysqlmanager)
moving
     .ibd files
     InnoDB tables
MSI (Microsoft Windows Installer)
MSSQL SQL mode
multi-byte characters
multi-column indexes
multi-versioning
     concurrency control
     InnoDB tables
multi_read_range system variable 2nd
multiple granularity locking
multiple key caches
multiple mysqld servers
multiple nodes, running
multiple servers
     client programs
     data directory sharing
     options
     Unix
     Windows
multiple tablespaces
multiple-master replication
multiple-part indexes
multiple-table joins
my.cnf file
     Cluster configuration
     connection parameters
     InnoDB storage engine examples
     passwords
     replication options
     Unix socket files/TCP/IP port numbers
MyISAM storage engine
     automatic recovery
     characteristics
     forum
     key caches
         block buffers 2nd
         index blocks
         midpoint insertion strategy
         multiple
         preloading
         restructuring
         sharing
         size
     key space
     log files, viewing 2nd
     maintenance
     overview
     startup options
     storage 2nd
     system variables
     troubleshooting
myisam-recover option (mysqld) 2nd
myisam_block_size myisamchk variable
myisam_data_pointer_size system variable 2nd
myisam_max_extra_sort_file_size system variable
     MyISAM tables
     mysqld
myisam_max_sort_file_size system variable
     MyISAM tables
     mysqld
myisam_recover_options system variable (mysqld)
myisam_repair_threads system variable 2nd
myisam_sort_buffer_size system variable
     MyISAM tables
     mysqld
myisam_stats_method system variable 2nd 3rd
myisamchk 2nd 3rd
     crash recovery
     example output
     memory allocation
     options
         analyze
         block-search
         debug
         description
         help
         repair
         set-auto-increment
         silent
         sort-index
         sort-records
         table checking
         verbose
         version
         wait
     overview
     tables
         details, viewing
         error checking
         maintenance 2nd
         optimizing
         repairing
     types of information produced
     variables
myisamlog program 2nd
myisampack program 2nd 3rd
     column information
     invoking
     options
     results
     table compression example
MySQL
     5.0 new features
     defined
     distributions
     downgrading
     features
         clients
         connectivity
         data types
         internals/portability
         localization
         scalability/limits
         security
         statements/functions
         tools
     forums
     history
     interoperability with MaxDB
     mailing lists
     MaxDB, compared
     name
     overview
     pronunciation
     release series
     upgrading
         different architectures
         to 5.0
         to 5.1
     versions
     Web site
MySQL AB
     binaries, compiling
     defined
MySQL Cluster [See backups, Cluster.]
MySQL Configuration Wizard
     character sets
     concurrent connections
     configuration
         starting
         types
     ini file
     InnoDB tablespace
     options
         maintenance options
         networking options
         service options
     overview
     security
     server types
     starting
     storage engine selection
     strict mode
MySQL Dolphin
MySQL Installation Wizard
     Confirmation dialog box
     Custom Install dialog box
     downloading
     install types
     overview
     starting
     system changes
     upgrading
MySQL Instance Manager [See IM (Instance Manager).]
mysql program 2nd
     auto-reconnect, disabling
     commands
         delimiter
         list of
         pager
         prompt
         status
         tee
     environment variables
     options
         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
     overview
     query results, viewing
     safe-updates option
     SQL statements, executing
     variables
mysql.server script 2nd
mysql.sock location
MYSQL323 SQL mode
MYSQL40 SQL mode
mysql_fix_privilege_tables script 2nd
MYSQL_HISTFILE environment variable
.mysql_history file
MYSQL_HOME environment variable
MYSQL_HOST environment variable
mysql_insert_id( ) function
mysql_install_db script 2nd 3rd
MYSQL_PWD environment variable
mysql_real_escape_string( ) function
MYSQL_TCP_PORT environment variable
MYSQL_UNIX_PORT environment variable 2nd
mysql_upgrade script 2nd 3rd
mysql_zap program 2nd
mysqlaccess program 2nd
mysqladmin option (mysqld_multi script)
mysqladmin program 2nd 3rd
     commands, list of 2nd
     options
         character-sets-dir
         compress
         count
         debug
         default-character-set
         force
         help
         host
         password
         port
         protocol
         relative
         silent
         sleep
         socket
         user
         verbose
         version
         vertical
         wait
     status command
     variables
mysqlbinlog utility 2nd 3rd
     hex dumps
     invoking
     multiple binary logs
     options
         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
     overview
     piping output
     point-in-time recovery
     redirecting output
     variables
mysqlbug script
mysqlcheck program 2nd
     default behavior
     invoking
     options
         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
     overview
mysqld option
     mysqld_multi script
     mysqld_safe
mysqld program
     buffer sizes
     cluster options
     Cluster server process, as 2nd
     command options
         allow-suspicious-udfs
         ansi
         basedir
         bind-address
         binlog-format
         binlog-row-event-max-size
         bootstrap
         character-set-client-handshake
         character-set-filesystem
         character-set-server
         character-sets-dir
         chroot
         collation-server
         console
         core-file
         datadir
         debug
         default-character-set
         default-collation
         default-storage-engine
         default-table-type
         default-time-zone
         delay-key-write
         des-key-file
         enable-named-pipe
         exit-info
         external-locking
         flush
         help
         init-file
         innodb-safe-binlog
         language
         large-pages
         log
         log-bin
         log-bin-index
         log-bin-trust-function-creators
         log-bin-trust-routine-creators
         log-error
         log-isam
         log-long-format
         log-queries-not-using-indexes
         log-short-format
         log-slow-admin-statements
         log-slow-queries
         log-warnings
         low-priority-updates
         maximum
         memlock
         myisam-recover
         ndb-connectstring
         ndbcluster
         old-passwords
         one-thread
         open-files-limit
         pid-file
         port
         port-open-timeout
         reading
         safe-mode
         safe-show-database
         safe-user-create
         secure-auth
         shared-memory
         shared-memory-base-name
         skip-bdb
         skip-concurrent-insert
         skip-external-locking
         skip-grant-tables
         skip-host-cache
         skip-innodb
         skip-name-resolve
         skip-ndbcluster
         skip-networking
         skip-safemalloc
         skip-show-database
         skip-stack-trace
         skip-symbolic-links
         skip-thread-priority
         socket
         sql-mode
         standalone
         symbolic-links
         temp-pool
         tmpdir
         transaction-isolation
         user
         version
     config.ini parameters
     multiple
     options
         bdb-home
         bdb-lock-detect
         bdb-logdir
         bdb-no-recover
         bdb-no-sync
         bdb-shared-data
         bdb-tmpdir
         delay-key-write
         innodb
         innodb_status_file
         myisam-recover
         skip-bdb
         sync-bdb-logs
     security options
         allow-suspicious-udfs
         local-infile
         old-passwords
         safe-show-database
         safe-user-create
         secure-auth
         skip-grant-tables
         skip-name-resolve
         skip-networking
         skip-show-database
     shutdown process
     SQL mode
         ALLOW_INVALID_DATES
         ANSI 2nd
         ANSI_QUOTES
         DB2
         default
         ERROR_FOR_DIVISION_BY_ZERO
         HIGH_NOT_PRECEDENCE
         IGNORE_SPACE
         MAXDB
         MSSQL
         MYSQL323
         MYSQL40
         NO_AUTO_CREATE_USER
         NO_AUTO_VALUE_ON_ZERO
         NO_BACKSLASH_ESCAPES
         NO_DIR_IN_CREATE
         NO_ENGINE_SUBSTITUTION
         NO_FIELD_OPTIONS
         NO_KEY_OPTIONS
         NO_TABLE_OPTIONS
         NO_UNSIGNED_SUBTRACTION
         NO_ZERO_DATE
         NO_ZERO_IN_DATE
         ONLY_FULL_GROUP_BY
         ORACLE
         PIPES_AS_CONCAT
         POSTGRESQL
         REAL_AS_FLOAT
         STRICT 2nd
         STRICT_ALL_TABLES
         STRICT_TRANS_TABLES 2nd
         TRADITIONAL 2nd
     starting
         mysqlmanager
         normal user
     startup scripts
         mysqld.server
         mysqld_multi
         mysqld_safe
     status variables
         Aborted_clients
         Aborted_connects
         Binlog_cache_disk_use
         Binlog_cache_use
         Bytes_received
         Bytes_sent
         Com
         Compression
         Connections
         Created_tmp_disk_tables
         Created_tmp_files
         Created_tmp_tables
         Delayed_errors
         Delayed_insert_threads
         Delayed_writes
         Flush_commands
         Handler_commit
         Handler_delete
         Handler_discover
         Handler_read_first
         Handler_read_key
         Handler_read_next
         Handler_read_prev
         Handler_read_rnd
         Handler_read_rnd_next
         Handler_rollback
         Handler_update
         Handler_write
         Innodb_buffer_pool_pages_data
         Innodb_buffer_pool_pages_dirty
         Innodb_buffer_pool_pages_flushed
         Innodb_buffer_pool_pages_free
         Innodb_buffer_pool_pages_latched
         Innodb_buffer_pool_pages_misc
         Innodb_buffer_pool_pages_total
         Innodb_buffer_pool_read_ahead_rnd
         Innodb_buffer_pool_read_ahead_seq
         Innodb_buffer_pool_read_requests
         Innodb_buffer_pool_reads
         Innodb_buffer_pool_wait_free
         Innodb_buffer_pool_write_requests
         Innodb_data_fsyncs
         Innodb_data_pending_fsyncs
         Innodb_data_pending_reads
         Innodb_data_pending_writes
         Innodb_data_read
         Innodb_data_reads
         Innodb_data_writes
         Innodb_data_written
         Innodb_dblwr_pages_written
         Innodb_dblwr_writes
         Innodb_log_waits
         Innodb_log_write_requests
         Innodb_log_writes
         Innodb_os_log_fsyncs
         Innodb_os_log_pending_fsyncs
         Innodb_os_log_pending_writes
         Innodb_os_log_written
         Innodb_page_size
         Innodb_pages_created
         Innodb_pages_read
         Innodb_pages_written
         Innodb_row_lock_current_waits
         Innodb_row_lock_time
         Innodb_row_lock_time_avg
         Innodb_row_lock_time_max
         Innodb_row_lock_waits
         Innodb_rows_deleted
         Innodb_rows_inserted
         Innodb_rows_read
         Innodb_rows_updated
         Key_blocks_not_flushed
         Key_blocks_unused
         Key_blocks_used
         Key_read_requests
         Key_reads
         Key_write_requests
         Key_writes
         Last_query_cost
         Max_used_connections
         Not_flushed_delayed_rows
         Open_files
         Open_streams
         Open_tables
         Opened_tables
         Qcache_free_blocks
         Qcache_free_memory
         Qcache_hits
         Qcache_inserts
         Qcache_lowmem_prunes
         Qcache_not_cached
         Qcache_queries_in_cache
         Qcache_total_blocks
         Questions
         Rpl_status
         Select_full_join
         Select_full_range_join
         Select_range
         Select_range_check
         Select_scan
         Slave_open_temp_tables
         Slave_retried_transactions
         Slave_running
         Slow_launch_threads
         Slow_queries
         Sort_merge_passes
         Sort_range
         Sort_rows
         Sort_scan
         Ssl
         Table_locks_immediate
         Table_locks_waited
         Threads_cached
         Threads_connected
         Threads_created
         Threads_running
         Uptime
         viewing
     status, monitoring
     system variables 2nd
         auto_increment_increment
         auto_increment_offset
         back_log
         basedir
         bdb_cache_size
         bdb_home
         bdb_log_buffer_size
         bdb_logdir
         bdb_max_lock
         bdb_shared_data
         bdb_tmpdir
         binlog_cache_size
         binlog_format
         bulk_insert_buffer_size
         character_set_client
         character_set_connection
         character_set_database
         character_set_filesystem
         character_set_results
         character_set_server
         character_set_system
         character_sets_dir
         collation_connection
         collation_database
         collation_server
         completion_type
         concurrent_insert
         connect_timeout
         datadir
         date_format
         datetime_format
         default
         default_week_format
         delay_key_write
         delayed_insert_limit
         delayed_insert_timeout
         delayed_queue_size
         div_precision_increment
         dynamic
         enabling/disabling 2nd
         engine_condition_pushdown
         expire_logs_days
         flush
         flush_time
         ft_boolean_syntax
         ft_max_word_len
         ft_min_word_len
         ft_query_expansion_limit
         ft_stopword_file
         global
         group_concat_max_len
         have_archive
         have_bdb
         have_blackhole_engine
         have_compress
         have_crypt
         have_csv
         have_example_engine
         have_geometry
         have_innodb
         have_isam
         have_ndbcluster
         have_openssl
         have_query_cache
         have_raid
         have_row_based_replication
         have_rtree_keys
         have_symlink
         init_connect
         init_file
         init_slave
         innodb
         interactive_timeout
         join_buffer_size
         key_buffer_size
         key_cache_age_threshold
         key_cache_block_size
         key_cache_division_limit
         language
         large_file_support
         large_pages
         license
         local_infile
         locked_in_memory
         log
         log_bin
         log_bin_trust_function_creators
         log_bin_trust_routine_creators
         log_error
         log_slave_updates
         log_slow_queries
         log_warnings
         long_query_time
         low_priority_updates
         lower_case_file_system
         lower_case_table_names
         max_allowed_packet
         max_binlog_cache_size
         max_binlog_size
         max_connect_errors
         max_connections
         max_delayed_threads
         max_error_count
         max_heap_table_size
         max_insert_delayed_threads
         max_join_size
         max_length_for_sort_data
         max_relay_log_size
         max_seeks_for_key
         max_sort_length
         max_tmp_tables
         max_user_connections
         max_write_lock_count
         multi_read_range
         myisam_data_pointer_size
         myisam_max_extra_sort_file_size
         myisam_max_sort_file_size
         myisam_recover_options
         myisam_repair_threads
         myisam_sort_buffer_size
         myisam_stats_method
         named_pipe
         net_buffer_length
         net_read_timeout
         net_retry_count
         net_write_timeout
         new
         old_passwords
         one_shot
         open_files_limit
         optimizer_prune_level
         optimizer_search_depth
         pid_file
         port
         preload_buffer_size
         protocol_version
         query_alloc_block_size
         query_cache_limit
         query_cache_min_res_unit
         query_cache_size
         query_cache_type
         query_cache_wlock_invalidate
         query_prealloc_size
         range_alloc_block_size
         read_buffer_size
         read_only
         read_rnd_buffer_size
         relay_log_purge
         secure_auth
         server_id
         session
         shared_memory
         shared_memory_base_name
         skip_external_locking
         skip_networking
         skip_show_database
         slave_compressed_protocol
         slave_load_tmpdir
         slave_net_timeout
         slave_skip_errors
         slave_transaction_retries
         slow_launch_time
         socket
         sort_buffer_size
         sql_mode
         sql_slave_skip_counter
         storage_engine
         structured
         sync_binlog
         sync_frm
         system_time_zone
         table_cache
         table_type
         thread_cache_size
         thread_concurrency
         thread_stack
         time_format
         time_zone
         tmp_table_size
         tmpdir
         transaction_alloc_block_size
         transaction_prealloc_size
         tx_isolation
         updatable_views_with_limit
         values
         version
         version_bdb
         version_comment
         version_compile_machine
         version_compile_os
         viewing 2nd
         wait_timeout
mysqld script
mysqld-max program 2nd
     BDB support
     configure options
     NDB Cluster support
     storage engine support
mysqld-path option (mysqlmanager)
mysqld-version option (mysqld_safe script)
mysqld.server script
mysqld_multi script 2nd 3rd
     GNRs
     invoking
     options
         config-file
         example
         help
         log
         mysqladmin
         mysqld
         no-log
         option file example
         password
         silent
         tcp-ip
         user
         verbose
         version
mysqld_safe script 2nd 3rd
     editing
     options
         autoclose
         basedir
         core-file-size
         datadir
         defaults-extra-file
         defaults-file
         help
         ledir
         log-error
         mysqld
         mysqld-version
         NetWare
         nice
         no-defaults
         open-files
         pid-file
         port
         socket
         timezone
         user
mysqldump command
mysqldump program 2nd 3rd
     databases
     options
         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
     overview
     point-in-time recovery
     variables
mysqlhotcopy script 2nd
     options
         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
     overview
mysqlimport program 2nd 3rd 4th 5th
mysqlmanager program 2nd
     commands
     configuration files
     connecting to
     mysqld, starting
     options
         bind-address
         default-mysqld-path
         defaults-file
         help
         install
         log
         monitoring-interval
         mysqld-path
         nonguraded
         passwd
         password-file
         pid-file
         port
         print-defaults
         remove
         run-as-service
         shutdown-delay
         socket
         standalone
         user
         version
     server status, monitoring
     users/passwords
mysqlshow program 2nd
     invoking
     options
         character-sets-dir
         compress
         count
         debug
         default-character-set
         help
         host
         keys
         password
         port
         protocol
         show-table-type
         socket
         status
         user
         verbose
         version
     overview