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] daemon option data character sets adding default German lowercase/uppercase multi-byte characters troubleshooting dictionaries importing nodes 2nd backups boolean values buffering checkpointing defined disk paging identifying intervals logging 2nd memory metadata objects multiple scans/buffering temporary storage timeouts transactions size starting storing types 2nd data-file-length option (myisamchk) database option mysql mysqlbinlog Database Usage dialog box databases backups 2nd full 2nd incremental 2nd operating system crashes point in time recovery recovering from selective slave replication servers strategies Veritas filesystems copying defined design errors importing independence names point-in-time recovery populating relational replicating asynchronous benefits configuring database options, checking errors, reporting features forcing masters to block updates high availability implementation limitations log formats master thread states master/slave setup mixed hardware architectures mixed operating system support multiple-master 2nd options performance redundancy relay logs row-based 2nd single-master slaves 2nd statement-based status files table options, checking troubleshooting two-way configuration updates upgrading version compatibility replication security symbolic links Unix Windows databases option mysqlcheck mysqldump datadir option mysql_upgrade mysqld mysqld_safe DataDir parameter (config.ini file) NDB_MGMD section NDBD section datadir system variable (mysqld) DataMemory parameter (config.ini file) date functions date_format system variable (mysqld) datetime_format system variable (mysqld) DB nodes [See data, ; nodes.] db option (mysqlaccess) db tables columns sorting wildcard characters DB2 SQL mode De-Militarized Zone (DMZ) deadlocks debug command (mysqladmin) debug option myisamchk myisampack mysql mysqlaccess mysqladmin mysqlbinlog mysqlcheck mysqld mysqldump mysqlhotcopy mysqlimport mysqlshow NDB programs debug-info option (mysql) debugging [See also BDB (BerkeleyDB) storage engine, troubleshooting.] decode_bits myisamchk variable DEFAULT constraint default-character-set option mysql mysqladmin mysqlcheck mysqld mysqldump mysqlimport mysqlshow default-collation option (mysqld) default-mysqld-path option (mysqlmanager) default-storage-engine option (mysqld) default-table-type option (mysqld) default-time-zone option (mysqld) default_week_format system variable 2nd defaults character sets hostnames installation location options privileges SQL mode values suppressing tables defaults-extra-file option 2nd defaults-file option mysqld_safe mysqlmanager defragmenting query cache tables 2nd 3rd delay-key-write option (mysqld) 2nd delay_key_write system variable 2nd delayed-insert option (mysqldump) Delayed_errors status variable delayed_insert_limit system variable 2nd Delayed_insert_threads status variable delayed_insert_timeout system variable 2nd delayed_queue_size system variable 2nd Delayed_writes status variable delete option (mysqlimport) DELETE privilege DELETE statements delete-master-logs option (mysqldump) DELETE_FILE_EVENT event DELETE_ROWS_EVENT event deleting accounts conditions foreign keys parentheses privileges speed of users delimiter command (mysql) delimiter option (mysql) des-key-file option (mysqld) description option (myisamchk) design databases limitations portability development source trees dialog boxes Character Set Concurrent Connections Configuration Type Confirmation Custom Install Database Usage InnoDB Tablespace Networking Options Security Options Server Type Service Options Strict Mode Options directory structure disable-bin-log option (mysqlbinlog) disable-keys option (mysqldump) disabling auto-reconnect column names external locking 2nd 3rd privileges query cache system variables 2nd TCP/IP networking DISCARD TABLESPACE Diskless parameter (config.ini file) disks based records I/O paging performance issues sharing data across DISTINCT clauses distinct values distributions binary commands compiled by MySQL AB installing selecting Windows selecting source commands compiling problems development source tree installing MIT-pthreads Windows 2nd div_precision_increment system variable 2nd DMZ (De-Militarized Zone) DNS DocBook XML Dolphin Web site doublewriting downgrading MySQL downloading BitKeeper trees distributions 2nd GPG build keys installation packages MIT-pthreads package MySQL NetWare Support Pack world database drivers (SCI sockets) drop command (mysqladmin) DROP FOREIGN KEY DROP privilege dropping [See binary logs, deleting.] dryrun option (mysqlhotcopy) dual licensing dumping tables dynamic system variables autocommit dynamic tables |
Категории