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] packages Complete Essentials integrity verification cryptographic signatures MD5 checksums RPM packages Mac OS X PKG MIT-pthreads Noinstall archive RPM installing signature verification Windows installation packlength option (myisampack) page-level locking pager command (mysql) pager option (mysql) parallel-recover option (myisamchk) parameters Cluster backups config.ini file ArbitrationDelay ArbitrationRank ArbitrationTimeout BackupDataBufferSize BackupDataDir BackupLogBufferSize BackupMemory BackupWriteSize BatchByteSize BatchSize BatchSizePerLocalScan Checksum DataDir DataMemory Diskless ExecuteOnComputer 2nd FileSystemPath HeartbeatIntervalDbApi HeartbeatIntervalDbDb Host1SciId0 Host1SciId1 Host2SciId0 Host2SciId2 HostName Id 2nd IndexMemory 2nd LockPagesInMainMemory LogDestination LongMessageBuffer MaxNoOfAttributes MaxNoOfConcurrentIndexOperations MaxNoOfConcurrentOperations MaxNoOfConcurrentScans MaxNoOfConcurrentTransactions MaxNoOfFiredTriggers MaxNoOfIndexes MaxNoOfLocalOperations MaxNoOfLocalScans MaxNoOfOrderedIndexes MaxNoOfTables MaxNoOfTriggers MaxNoOfUniqueHashIndexes MaxScanBatchSize NodeId1 NodeId2 NoOfDiskPagesToDiskAfterRestartACC NoOfDiskPagesToDiskAfterRestartTUP NoOfDiskPagesToDiskDuringRestartACC NoOfDiskPagesToDiskDuringRestartTUP NoOfReplicas PortNumber 2nd ReceiveBufferMemory RedoBuffer RestartOnErrorInsert SendBufferMemory SendLimit SendSignalId ServerPort SharedBufferSize ShmKey ShmSize StartFailureTimeout StartPartialTimeout StartPartitionedTimeout StopOnError TimeBetweenGlobalCheckpoints TimeBetweenInactiveTransaction-AbortCheck TimeBetweenLocalCheckpoints TimeBetweenWatchDogCheck TransactionBufferMemory TransactionDeadlockDetectionTimeout TransactionInactiveTimeout UndoDataBuffer UndoIndexBuffer ndbd backups boolean values buffering checkpointing data memory/index memory disk paging identification intervals logging 2nd metadata objects scans/buffering temporary storage timeouts transactions server startup parentheses ( ) partitions 2nd Cluster raw disk replicas 2nd tables user-defined passwd option (mysqlmanager) password command (mysqladmin) password option mysql mysqlaccess mysqladmin mysqlbinlog mysqlcheck mysqld_multi script mysqldump mysqlhotcopy mysqlimport mysqlshow PASSWORD( ) function 2nd password-file option (mysqlmanager) passwords accounts configuring security setting anonymous users hashing compatibility implications old-passwords option OLD_PASSWORD( ) function Password column width short/long mysqlmanager root accounts security users PATH environment variable performance benchmarks binary logs bottlenecks finding sources Cluster benchmarks limitations disk issues improving 2nd InnoDB tables queries cache estimating optimizer speed, increasing Perl DBI/DBD interface installing permission checks perror program 2nd 3rd phantom problem, avoiding pid-file option multiple servers mysqld mysqld_safe mysqlmanager pid_file system variable (mysqld) ping command (mysqladmin) PIPES_AS_CONCAT SQL mode plan option (mysqlaccess) point-in-time recovery mysqlbinlog mysqldump positions, specifying times, specifying port option multiple servers mysql mysqladmin mysqlbinlog mysqlcheck mysqld mysqld_safe mysqldump mysqlhotcopy mysqlimport mysqlmanager mysqlshow port system variable (mysqld) port-open-timeout option (mysqld) portability 2nd PortNumber parameter (config.ini file) NDB_MGMD section TCP_DEFAULT section position option (mysqlbinlog) possible_keys column (EXPLAIN statements) post-installation multiple servers client programs data directory sharing options Unix Windows setup/testing accounts Unix Windows PostgreSQL compatibility POSTGRESQL SQL mode precedence preload_buffer_size system variable 2nd preloading key caches preview option (mysqlaccess) PRIMARY KEY constraints primary keys Cluster access NDB tables print-defaults option 2nd privileges access control adding administrative ALTER ALTER ROUTINE changes checking 2nd Cluster nodes CREATE CREATE ROUTINE CREATE TEMPORARY TABLES CREATE USER CREATE VIEW default DELETE deleting DROP enabling/disabling EXECUTE FILE 2nd functionality GRANT OPTION grant tables changes columns structure INDEX information locations INSERT limitations LOCK TABLES overview PROCESS REFERENCES RELOAD REPLICATION CLIENT REPLICATION SLAVE request verification SELECT SHOW DATABASES SHOW VIEW SHUTDOWN storing SUPER UPDATE problems [See Cluster, errors.] [See BDB (BerkeleyDB) storage engine, troubleshooting.] PROCESS privilege processes (Cluster) command options management client management server server storage engine node processlist command (mysqladmin) 2nd procs_priv table 2nd program variables programs [See also servers, scripts.] client list of multiple servers Cluster crash-me 2nd environment variables GUI help option invoking list of make_binary_distribution myisamlog 2nd myisampack 2nd 3rd column information invoking options results table compression example mysql_fix_privilege_tables mysql_upgrade mysql_zap 2nd mysqlaccess 2nd mysqladmin 2nd 3rd commands 2nd options status command variables mysqlbinlog 2nd 3rd hex dumps invoking multiple binary logs options overview piping output point-in-time recover redirecting output variables mysqlcheck 2nd default behavior invoking options overview mysqldump 2nd 3rd databases options overview populating databases variables mysqlhotcopy 2nd options overview mysqlimport 2nd 3rd 4th mysqlmanager 2nd commands configuration files connecting to mysqld, starting options server status, monitoring users/passwords mysqlshow 2nd invoking options overview ndb_mgm backups, creating commands options starting ndb_mgmd configuration file definition options ndb_restore options command line descriptions of option files program variables specifying with environment variables perror 2nd 3rd portability replace 2nd server startup scripts server-side Services prompt command (mysql) prompt option (mysql) pronunciation of MySQL protocol option mysql mysqladmin mysqlbinlog mysqlcheck mysqldump mysqlimport mysqlshow protocol_version system variable (mysqld) protocols SSL certificates, configuring OpenSSL options overview yaSSL TCP/IP networking config.ini file parameters enabling/disabling support testing Windows installation push-down conditions Cluster inner joins outer joins |
Категории