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] i-am-a-dummy option (mysql) IANA (Internet Assigned Numbers Authority) .ibd files Id parameter (config.ini file) COMPUTER section MYSQLD section NDB_MGMD section NDBD section ignore option (mysqlimport) ignore-lines option (mysqlimport) ignore-spaces option (mysql) ignore-table option (mysqldump) IGNORE_SPACE SQL mode IM (Instance Manager) commands FLUSH INSTANCES SET SHOW SHOW INSTANCE OPTIONS SHOW INSTANCE STATUS SHOW INSTANCES START INSTANCE STOP INSTANCE UNSET configuration files connecting to mysqld, starting options bind-address default-mysqld-path defaults-file help install log monitoring-interval mysqld-path nonguarded passwd password-file pid-file port print-defaults remove run-as-service shutdown-delay socket standalone user version server status, monitoring users/passwords implementing replication implicit commits implicit rollbacks IMPORT TABLESPACE importing data databases tables 2nd in-memory storage incremental backups 2nd independence of databases Index Merge method intersection optimization sort-union union INDEX privilege index_merge joins index_subquery joins indexes adding to tables binary logs BLOB columns blocks MyISAM key cache size clustered columns EXPLAIN statements FULLTEXT 2nd functionality hash 2nd InnoDB tables IS NULL joins leftmost prefixes LIKE comparisons loose index scans memory multi-column multiple-part non-clustered operations performed ORDER BY clause scans single-part storing TEXT columns tight index scans GROUP BY clause WHERE clauses IndexMemory parameter (config.ini file) INFO events information option (myisamchk) ini files INI format init-file option (mysqld) init_connect system variable (mysqld) init_file system variable (mysqld) init_slave system variable (mysqld) initial node restarts 2nd initial option (ndbd) initial start mode (Cluster) initializing Cluster grant tables inner joins nested-loop join algorithms outer join combination pushed-down conditions InnoDB Hot Backup InnoDB Monitors example output output stopping innodb option (mysqld) InnoDB storage engine AUTO_INCREMENT columns backups configuring multiple tablespaces my.cnf file examples options shared tablespaces tablespace files contact information crash recovery defragmenting disk I/O dumping error handling errors, list of Linux error codes Windows error codes file space management forcing recovery foreign key constraints actions adding checking by rows conditions deleting dump files FOREIGN KEY constraint ON UPDATE CASCADE/ON UPDATE SET NULL operations parent rows syntax tables, dropping triggers viewing forum fuzzy checkpointing indexes initialization problems InnoDB Monitors locking configuring deadlocks intention locks modes next-key shared mode locks moving between machines multi-versioning MyISAM table conversions overview performance tuning recovering from backups replication restrictions size startup options system variables 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_concurrency innodb_thread_sleep_delay sync_binlog tables, creating tablespaces, creating transactions autocommit mode consistent reads implicit commits/rollbacks isolation levels troubleshooting innodb system variable (mysqld) InnoDB tables AUTO_INCREMENT columns backups configuring multiple tablespaces my.cnf file examples options shared tablespaces tablespace files contact information crash recovery creating defragmenting disk I/O dumping error handling errors, list of Linux error codes Windows error codes file space management forcing recovery foreign key constraints actions adding checking by rows conditions deleting dump files FOREIGN KEY constraint ON UPDATE CASCADE/ON UPDATE SET NULL operations parent rows syntax tables, dropping triggers viewing forum fuzzy checkpointing indexes initialization problems InnoDB Monitors locking configuring deadlocks intention locks modes next-key shared mode locks moving between machines multi-versioning MyISAM table conversions overview performance tuning recovering from backups replication restrictions size startup options system variables 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_concurrency innodb_thread_sleep_delay sync_binlog tablespaces, creating transactions autocommit mode consistent reads 2nd implicit commits/rollbacks isolation levels troubleshooting InnoDB Tablespace dialog box innodb-safe-binlog option (mysqld) innodb_additional_mem_pool_size system variable innodb_autoextend_increment system variable 2nd innodb_buffer_pool_awe_mem_mb system variable Innodb_buffer_pool_pages_data status variable Innodb_buffer_pool_pages_dirty status variable Innodb_buffer_pool_pages_flushed status variable Innodb_buffer_pool_pages_free status variable Innodb_buffer_pool_pages_latched status variable Innodb_buffer_pool_pages_misc status variable Innodb_buffer_pool_pages_total status variable Innodb_buffer_pool_read_ahead_rnd status variable Innodb_buffer_pool_read_ahead_seq status variable Innodb_buffer_pool_read_requests status variable Innodb_buffer_pool_reads status variable innodb_buffer_pool_size system variable Innodb_buffer_pool_wait_free status variable Innodb_buffer_pool_write_requests status variable innodb_checksums system variable innodb_commit_concurrency system variable 2nd innodb_concurrency_tickets system variable 2nd innodb_data_file_path system variable Innodb_data_fsyncs status variable innodb_data_home_dir system variable Innodb_data_pending_fsyncs status variable Innodb_data_pending_reads status variable Innodb_data_pending_writes status variable Innodb_data_read status variable Innodb_data_reads status variable Innodb_data_writes status variable Innodb_data_written status variable Innodb_dblwr_pages_written status variable Innodb_dblwr_writes status variable innodb_doublewrite system variable innodb_fast_shutdown system variable innodb_file_io_threads system variable innodb_file_per_table system variable innodb_flush_log_at_trx_commit system variable innodb_flush_method system variable innodb_force_recovery system variable innodb_lock_wait_timeout system variable innodb_locks_unsafe_for_binlog system variable innodb_log_arch_dir system variable innodb_log_archive system variable innodb_log_buffer_size system variable innodb_log_file_size system variable innodb_log_files_in_group system variable innodb_log_group_home_dir system variable Innodb_log_waits status variable Innodb_log_write_requests status variable Innodb_log_writes status variable innodb_max_dirty_pages_pct dynamic system variable innodb_max_dirty_pages_pct system variable innodb_max_purge_lag dynamic system variable innodb_max_purge_lag system variable innodb_mirrored_log_groups system variable innodb_open_files system variable Innodb_os_log_fsyncs status variable Innodb_os_log_pending_fsyncs status variable Innodb_os_log_pending_writes status variable Innodb_os_log_written status variable Innodb_page_size status variable Innodb_pages_created status variable Innodb_pages_read status variable Innodb_pages_written status variable Innodb_row_lock_current_waits status variable Innodb_row_lock_time status variable Innodb_row_lock_time_avg status variable Innodb_row_lock_time_max status variable Innodb_row_lock_waits status variable Innodb_rows_deleted status variable Innodb_rows_inserted status variable Innodb_rows_read status variable Innodb_rows_updated status variable innodb_safe_binlog system variable innodb_status_file option (mysqld) innodb_support_xa system variable 2nd innodb_sync_spin_loops system variable 2nd innodb_table_locks system variable 2nd innodb_thread_concurrency system variable 2nd innodb_thread_sleep_delay system variable 2nd INSERT privilege INSERT statements concurrent 2nd grant privileges speed insert-ignore option (mysqldump) insert_id dynamic system variable inserts [See also foreign keys, adding.] concurrent 2nd speed of install option (mysqlmanager) installation BDB storage engine binary distributions BitKeeper trees Cluster multi-computer software distribution selection downloads host storage layouts Linux RPM packages Mac OS X packages management nodes NetWare packages operating systems supported overview Perl post-installation [See testing, post-installation.] source distributions compiling problems configure script development source tree MIT-pthreads overview Windows Unix version selection Windows automated installers distributions MySQL Configuration Wizard MySQL Installation Wizard noinstall zip archives options files package selection requirements server selection starting first time starting from as Windows service starting from command line testing troubleshooting Unix, compared upgrading Instance Manager [See IM (Instance Manager).] intention locks interactive_timeout system variable 2nd interconnects (Cluster high-speed) access methods performance benchmarks SCI sockets, configuring transporters internals of MySQL Internet Assigned Numbers Authority (IANA) Relay Chat (IRC) unencrypted data intersection access algorithm intervals (Cluster) INTVAR_EVENT event invalid data constraints invalid expressions invoking myisampack mysql_upgrade mysqlbinlog mysqlcheck mysqld_multi mysqlshow programs IRC (Internet Relay Chat) IS NULL indexes optimization ISAM tables, upgrading isolation levels Cluster supported transactions |
Категории