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] RAND_EVENT event range access method (indexes) multiple-part single-part range_alloc_block_size system variable 2nd ranges checking conditions EXPLAIN statements optimizing scans raw disk partitions raw option (mysql) rc releases RDBMS (relational database management system) re-creating grant tables READ COMMITTED isolation level READ UNCOMMITTED isolation level read-from-remote-server option (mysqlbinlog) read-only option myisamchk replication read_buffer_size system variable myisamchk mysqld read_only system variable 2nd read_rnd_buffer_size system variable 2nd reading command options option files REAL_AS_FLOAT SQL mode ReceiveBufferMemory parameter (config.ini file) reconfiguring reconnect option (mysql) reconnecting servers record_log_pos option (mysqlhotcopy) recover option (myisamchk) recovery backups Cluster 2nd InnoDB tables backups crashes forcing fuzzy checkpointing MyISAM tables operating system crashes point-in-time mysqlbinlog mysqldump positions, specifying times, specifying tables crash recovery details, viewing error checking maintenance schedule optimizing repairing RedoBuffer parameter (config.ini) ref column (EXPLAIN statements) ref tables ref_or_null joins EXPLAIN statements IS NULL optimization REFERENCES privilege referential actions refresh command (mysqladmin) regexp option (mysqlhotcopy) registration relational database management system (RDBMS) relational databases relative option (mysqladmin) relay logs relay-log option (replication) relay-log-index option (replication) relay-log-info-file option (replication) relay-log-purge option (replication) relay-log-space-limit option (replication) relay_log_purge system variable (mysqld) releases build process errors names numbers series testing updating upgrading 5.0 5.1 different architectures relnotes option (mysqlaccess) reload command (mysqladmin) 2nd RELOAD privilege remote connections (SSH) remove option (mysqlmanager) repair option myisamchk mysqlcheck repairs mysqlcheck default behavior invoking options overview tables MyISAM tables system tables REPEATABLE READ isolation level replace option (mysqlimport) replace program 2nd replicas 2nd replicate-do-db option (replication) replicate-do-table option (replication) replicate-ignore-db option (replication) replicate-ignore-table option (replication) replicate-rewrite-db option (replication) replicate-same-server-id option (replication) replicate-wild-do-table option (replication) replicate-wild-ignore-table option (replication) replication asynchronous benefits BLACKHOLE storage engine Cluster abbreviations/symbols automatic backups backups, creating binlog-injector thread cluster-to-cluster layout compared failovers future support master cluster preparations problems requirements schema changes, discovering single channel tables two channels configuring database options, checking errors, reporting features forcing masters to block updates high availability implementation InnoDB tables limitations log formats master thread states master/slave setup mixed hardware architectures mixed operating system support multiple-masters 2nd NDB tables options log-slave-updates log-warnings master-connect-retry 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-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-ignore-table replicate-rewrite-db replicate-same-server-id replicate-wild-do-table replicate-wild-ignore-table report-host report-port skip-slave-start slave-load-tmpdir slave-net-timeout slave-skip-errors slave_compressed_protocol performance redundancy relay logs row-based 2nd single-master slaves configuring connections formats last statement date thread states statement-based status files table options, checking troubleshooting two-way updates upgrading version compatibility REPLICATION CLIENT privilege REPLICATION SLAVE privilege report-host option (replication) report-port option (replication) reporting errors 2nd Cluster limitations mysqlbug script replication verifying the error writing error reports request verification resetmaster option (mysqlhotcopy) resetslave option (mysqlhotcopy) resolving joins queries RESTART command (ndb_mgm) restarting Cluster nodes servers system RestartOnErrorInsert parameter (config.ini file) restoring [See crashes, recovery.] RESTRICT action restrictions BDB tables InnoDB tables restructuring key caches result-file option mysqlbinlog mysqldump retrieving rows of queries REVOKE statement rhost option (mysqlaccess) RIGHT JOIN rollback option (mysqlaccess) rollbacks segments transactions 2nd root accounts root passwords ROTATE_EVENT event routines option (mysqldump) row-based replication 2nd row-level locking 2nd rows column (EXPLAIN statement) rows, locking rpl_recovery_rank dynamic system variable Rpl_status status variable RPM Package Manager RPM packages installing signature verification run-as-service option (mysqlmanager) running ANSI mode configure after prior invocation multiple nodes multiple servers client programs data directory sharing options Unix Windows mysql_upgrade script queries |
Категории