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] safe-mode option (mysqld) safe-recover option (myisamchk) safe-show-database option (mysqld) 2nd safe-updates option (mysql) 2nd safe-user-create option (mysqld) 2nd safe_show_database system variable Sakila SAP DB [See features, MaxDB.] SBR (statement-based replication) scalability Scalable Coherent Interface [See sockets, SCI.] scans (Cluster) scheduling table maintenance SCI (Scalable Coherent Interface) sockets, configuring driver installation network structure package installation requirements testing Transporters scripts [See also clients, programs.] configure mysqld-max running after prior invocation source distribution installations mysql.server 2nd mysql_fix_privilege mysql_install_db 2nd 3rd mysql_safe mysql_upgrade 2nd mysqlbug mysqld.server mysqld_multi 2nd 3rd GNRs invoking option file example options mysqld_safe 2nd 3rd editing NetWare options server startup secondary indexes Secure Sockets Layer (SSL) secure-auth option mysql mysqld 2nd secure_auth system variable 2nd security ACLs attackers Cluster 2nd data protection databases escaping special characters firewalls LOAD DATA LOCAL statements mailing list mysqld options starting overview passwords 2nd privileges [See accounts, privileges.] unencrypted data on Internet Security Options dialog box SELECT INTO TABLE extension SELECT privilege SELECT statements identifier query cache configuring defragmenting disabling functionality identical queries incoming queries maintenance non-cached queries options performance monitoring status transactions variable-length blocks query speed type Select_full_join status variable Select_full_range_join status variable select_limit variable Select_range status variable Select_range_check status variable Select_scan status variable selecting [See storage engines, choosing.] selective backups SendBufferMemory parameter (config.ini file) SendLimit parameter (config.ini file) SendSignalId parameter (config.ini file) SCI section SHM section TCP_DEFAULT section SERIALIZABLE isolation level Server Type dialog box server-side programs server_id system variable 2nd ServerPort parameter (config.ini file) servers auto-reconnect, disabling connecting 2nd master forcing to block updates multiple-master replication multiple client programs data directory sharing options Unix Windows mysqld-max 2nd BDB support configure options NDB Cluster support storage engine support parameters restarting scripts shutting down slave configuring connections formats last statement date starting troubleshooting starting/stopping Windows installation selecting starting as Windows service starting for first time starting from command line Service Options dialog box Services program session variables SET command (mysqlmanager) SET constraints SET DEFAULT action SET NULL action SET PASSWORD statement set-auto-increment option (myisamchk) set-character-set option (myisamchk) set-charset option (mysqldump) set-collation option (myisamchk) setting [See Cluster, configuring.] share-nothing architectures shared-memory connections shared-memory option (mysqld) shared-memory-base-name option multiple servers mysqld shared_memory system variable shared_memory_base_name system variable SharedBufferSize parameter (config.ini file) sharing data across disks key caches locks tablespaces shell syntax ShmKey parameter (config.ini file) ShmSize parameter (config.ini file) short password hashes short-form option (mysqlbinlog) SHOW command mysqlmanager ndb_mgm SHOW DATABASES privilege SHOW ENGINE INNODB STATUS statement SHOW INSTANCE OPTIONS command (mysqlmanager) SHOW INSTANCE STATUS command (mysqlmanager) SHOW INSTANCES command (mysqlmanager) SHOW VIEW privilege show-table-type option (mysqlshow) show-warnings option (mysql) shutdown command (mysqladmin) 2nd SHUTDOWN command (ndb_mgm) SHUTDOWN privilege shutdown process shutdown-delay option (mysqlmanager) shutdown_timeout variable (mysqladmin) shutting down Cluster 2nd servers sigint-ignore option (mysql) signatures silent option myisamchk myisampack mysql mysqladmin mysqlcheck mysqld_multi script mysqlimport perror single replication channels single-master replication single-part indexes 2nd single-sweep multi-join method single-transaction option (mysqldump) single-user mode (Cluster) size block buffers data 2nd files InnoDB tables MyISAM key caches mysqld buffers tables skip-bdb option (mysqld) 2nd skip-column-names option (mysql) skip-comments option (mysqldump) skip-concurrent-insert option (mysqld) skip-external-locking option (mysqld) skip-grant-tables option (mysqld) 2nd skip-host-cache option (mysqld) skip-innodb option (mysqld) skip-line-numbers option (mysql) skip-name-resolve option (mysqld) 2nd skip-ndbcluster option (mysqld) skip-networking option (mysqld) 2nd skip-safemalloc option (mysqld) skip-show-database option (mysqld) 2nd skip-slave-start option (replication) skip-stack-trace option (mysqld) skip-symbolic-links option (mysqld) skip-thread-priority option (mysqld) skip_external_locking system variable (mysqld) skip_networking system variable (mysqld) skip_show_database system variable (mysqld) slave servers configuring connections formats last statement date thread states slave-load-tmpdir option (replication) slave-net-timeout option (replication) slave-skip-errors option (replication) slave_compressed_protocol system variable 2nd 3rd SLAVE_EVENT event slave_load_tmpdir system variable (mysqld) slave_net_timeout system variable 2nd Slave_open_temp_tables status variable Slave_retried_transactions status variable Slave_running status variable slave_skip_errors system variable slave_transaction_retries system variable 2nd sleep option (mysqladmin) Sleepycat Web site slow logs 2nd slow queries Slow_launch_threads status variable slow_launch_time system variable 2nd Slow_queries status variable socket option multiple servers mysql mysqladmin mysqlbinlog mysqlcheck mysqld mysqld_safe mysqldump mysqlhotcopy mysqlimport mysqlmanager mysqlshow socket system variable (mysqld) sockets location 2nd SCI software [See clients, programs.] Solaris x86_64 issues Solaris, troubleshooting sort-index option (myisamchk) sort-records option (myisamchk) sort-recover option (myisamchk) sort-union access algorithm sort_buffer_size system variable myisamchk mysqld sort_key_blocks system variable Sort_merge_passes status variable Sort_range status variable Sort_rows status variable Sort_scan status variable sorting character sets db tables grant tables 2nd host tables source distributions commands installing compiling problems configure script development source tree MIT-pthreads overview Windows Windows spassword option (mysqlaccess) speed compiling deleting increasing with replication inserting linking optimization tips permission checks effect on queries [See queries, ; speed.] UPDATE statements split brain scenario SQL (Structured Query Language) extensions modes 2nd ALLOW_INVALID_DATES ANSI 2nd ANSI_QUOTES DB2 default ERROR_FOR_DIVISION_BY_ZERO IGNORE_SPACE MAXDB MSSQL MYSQL323 MYSQL40 mysqld NO_AUTO_CREATE_USER NO_AUTO_VALUE_ON_ZERO NO_BACKSLASH_ESCAPES NO_DIR_IN_CREATE 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 nodes accessing configuring defined installing queries, running standards, differences with MySQL atomic operations comments foreign keys SELECT INTO TABLE extension stored procedures subqueries transactions triggers views statements, executing SQL-92 sql-mode option (mysqld) SQL:1999 SQL:2003 sql_auto_is_null dynamic system variable sql_big_selects dynamic system variable sql_big_tables dynamic system variable sql_buffer_result dynamic system variable SQL_CACHE option sql_log_bin dynamic system variable sql_log_off dynamic system variable sql_log_update dynamic system variable sql_low_priority_updates dynamic system variable sql_max_join_size dynamic system variable sql_mode system variable 2nd SQL_NO_CACHE option sql_notes dynamic system variable sql_quote_show_create dynamic system variable sql_safe_updates dynamic system variable sql_select_limit dynamic system variable sql_slave_skip_counter system variable 2nd sql_warnings dynamic system variable square brackets ([ ]) SSH clients remote connections SSL (Secure Sockets Layer) ssl option SSL protocol certificates, configuring OpenSSL options overview yaSSL Ssl status variable ssl-ca option ssl-capath option ssl-cert option ssl-cipher option ssl-key option stability standalone options mysqld mysqlmanager standard MySQL clients standard SQL differences with MySQL atomic operations comments foreign keys SELECT INTO TABLE extension stored procedures subqueries transactions triggers views extensions standards compatibility 2nd atomic operations comments foreign keys 2nd SELECT INTO TABLE extension stored procedures subqueries transactions triggers views START command (ndb_mgm) START INSTANCE command (mysqlmanager) start-datetime option (mysqlbinlog) start-position option (mysqlbinlog) start-slave command (mysqladmin) START_EVENT_V3 event StartFailureTimeout parameter (config.ini file) starting Cluster 2nd 3rd initialization modes stages startup events comments data MySQL Configuration Wizard MySQL Installation Wizard mysqld mysqld.server mysqld_multi mysqld_safe mysqlmanager normal user ndb_mgm ndbd nodes options BDB storage engine InnoDB storage engine servers as Windows service automatically command line first time troubleshooting StartPartialTimeout parameter (config.ini file) StartPartitionedTimeout parameter (config.ini) startup events startup parameters mysqladmin character-sets-dir compress count debug default-character-set force help host password port protocol relative silent sleep socket user verbose version vertical wait tuning statement-based replication (SBR) 2nd statements CREATE TABLE 2nd DELETE EXPLAIN ALL joins column length mismatches condition pushdowns constant tables distinct values eq_ref tables EXTENDED keyword Extra column filesorts index joins index scans index_merge joins index_subquery join indexes join types keys LEFT JOIN multiple-table joins number of rows possible_keys column queries [See queries, ; speed.] ranges ref column ref tables ref_or_null joins SELECT statement identifier SELECT statement type system tables tables temporary tables unique_subquery join WHERE clause GRANT accounts, creating privileges INSERT concurrent 2nd grant privileges speed LOAD DATA LOCAL LOAD INDEX INTO CACHE REVOKE SELECT identifier query cache query speed type SET PASSWORD SHOW ENGINE INNODB STATUS SQL UPDATE static tables statically compiling statistics events (Cluster) stats_method system variable status command mysql mysqladmin STATUS command (ndb_mgm) status files (replication) status option (mysqlshow) 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 STOP command (ndb_mgm) STOP INSTANCE command (mysqlmanager) stop-datetime option (mysqlbinlog) stop-position option (mysqlbinlog) stop-slave command (mysqladmin) STOP_EVENT event StopOnError parameter (config.ini file) stopping Cluster servers storage data host in-memory indexes minimizing MyISAM formats tables privilege information 2nd transactions storage engines ARCHIVE 2nd BDB characteristics installing mysqld-max support operating systems supported overview restrictions startup options troubleshooting BLACKHOLE 2nd choosing Cluster supported CSV 2nd EXAMPLE 2nd FEDERATED flow of information forum functionality limitations overview tables, creating InnoDB [See configuring, InnoDB storage engine.] MEMORY characteristics forum overview tables, creating MERGE advantages disadvantages forum overview problems queries, issuing remapping tables, creating MyISAM automatic recovery characteristics corrupted tables forum key caches key space maintenance overview startup options storage 2nd system variables tables not closed properly mysqld-max support NDB Cluster [See enabling, NDB Cluster storage engine.] node process [See log files, ndbd.] storage nodes 2nd backups boolean values buffering checkpointing defined disk paging identifying intervals logging 2nd memory metadata objects multiple scans/buffering temporary storage timeouts transactions storage_engine system variable 2nd stored procedures stored routines Strict Mode Options dialog box STRICT SQL mode 2nd STRICT_ALL_TABLES SQL mode STRICT_TRANS_TABLES SQL mode 2nd strings collating replacing striping Structured Query Language [See nodes, SQL.] structured system variables subqueries subscribing, mailing lists suffix option (mysqlhotcopy) SUPER privilege Super Smack superuser option (mysqlaccess) superusers support autodiscovery (NDBCluster) BDB 2nd data types debugging forums IRC mailing lists answering questions Cluster guidelines listing of MaxDB MySQL security net etiquette non-English subscribing/unsubscribing MaxDB native threads NDB Cluster NetWare non-native threads operating systems 2nd storage engines TCP/IP time zones transactions suppressing default values symbolic links symbolic-links option (mysqld) sync-bdb-logs option (mysqld) sync_binlog system variable InnoDB tables mysqld sync_frm system variable 2nd Synchronization Manager (MaxDB) system bottlenecks finding sources crashes errors optimization restarts security ACLs attackers data protection databases escaping special characters firewalls LOAD DATA LOCAL statements mysqld overview passwords privileges restart mode (Cluster) unencrypted data on Internet tables EXPLAIN statements testing/repairing upgrading system variables auto_increment_increment 2nd auto_increment_offset 2nd back_log basedir bdb_cache_size bdb_home bdb_log_buffer_size bdb_logdir bdb_max_lock bdb_shared_data binlog_cache_size binlog_format bulk_insert_buffer_size 2nd 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 dbd_tmpdir 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 InnoDB storage engine innodb_additional_mem_pool_size innodb_autoextend_increment innodb_buffer_pool_awe_mem_mb innodb_buffer_pool_size innodb_checksums innodb_commit_concurrency innodb_concurrency_tickets innodb_data_file_path innodb_data_home_dir innodb_doublewrite innodb_fast_shutdown innodb_file_io_threads innodb_file_per_table innodb_flush_log_at_trx_commit innodb_flush_method innodb_force_recovery innodb_lock_wait_timeout innodb_locks_unsafe_for_binlog innodb_log_arch_dir innodb_log_archive innodb_log_buffer_size innodb_log_file_size innodb_log_files_in_group innodb_log_group_home_dir innodb_max_dirty_pages_pct innodb_max_purge_lag innodb_mirrored_log_groups innodb_open_files innodb_safe_binlog innodb_support_xa innodb_sync_spin_loops innodb_table_locks innodb_thread_sleep_delay 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_CONNECTIONS_PER_HOUR max_delayed_threads max_error_count max_heap_table_size max_insert_delayed_threads max_join_size max_length_for_sort_data MAX_QUERIES_PER_HOUR max_relay_log_size max_seeks_for_key max_sort_length max_tmp_tables MAX_UPDATES_PER_HOUR max_user_connections 2nd max_write_lock_count multi_read_range MyISAM tables myisam_data_pointer_size myisam_max_extra_sort_file_size 2nd myisam_max_sort_file_size 2nd myisam_recover_options myisam_repair_threads myisam_sort_buffer_size 2nd myisam_stats_method 2nd mysqld 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 2nd optimizer_search_depth 2nd pid_file port preload_buffer_size protocol_version query_alloc_block_size query_cache_limit 2nd query_cache_min_res_unit 2nd query_cache_size 2nd query_cache_type 2nd 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 2nd sync_frm system_time_zone table_cache 2nd 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 system_time_zone system variable (mysqld) |
Категории