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] 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 |
Категории