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] C client library C++ compilers executables, creating gcc caches hostnames key open tables query configuring defragmenting disabling functionality identical queries incoming queries maintenance non-cached queries options performance monitoring status transactions variable-length blocks CASCADE action case sensitivity access-checking database/table names options CC environment variable 2nd certificates (SSL) CFLAGS environment variable compiler settings flags, defining changing [See customizing.] Character Set dialog box character-set-client-handshake option (mysqld) character-set-filesystem option (mysqld) character-set-server option (mysqld) character-sets-dir option myisamchk myisampack mysql mysqladmin mysqlbinlog mysqlcheck mysqld mysqldump mysqlimport mysqlshow character_set_client system variable 2nd character_set_connection system variable 2nd character_set_database system variable (mysqld) character_set_filesystem system variable 2nd character_set_results system variable 2nd character_set_server system variable 2nd character_set_system system variable (mysqld) characters definition arrays multi-byte sets adding configuring default German lowercase/uppercase multi-byte characters MySQL Configuration Wizard troubleshooting check option myisamchk mysqlcheck check-only-changed option myisamchk mysqlcheck check-upgrade option (mysqlcheck) checking permissions checkpoint option (mysqlhotcopy) checkpoints Cluster 2nd defined GCPs LCPs Checksum parameter (config.ini file) SCI section SHM section TCP_DEFAULT section choosing distributions servers SQL modes storage engines versions Windows installation packages chroot option mysqld mysqlhotcopy clauses DISTINCT GROUP BY LIMIT ORDER BY WHERE EXPLAIN statements indexes optimization client nodes [See Cluster, SQL nodes.] clients management programs list of multiple servers standard MySQL closing tables 2nd Cluster arbitrators backups automating configuration parameters creating with management servers creating with replication defined metadata parameters restoring schema changes table records transaction logs troubleshooting buffering 2nd checkpoints 2nd configuration file computers, defining connectstrings data nodes, defining [See ndbd, ; parameters.] defined example INI format management server my.cnf example parameter values shared-memory connections SQL nodes TCP/IP connections transport connections configuring config.ini file configuration directory from binary tarballs NDB Cluster storage engine nodes, starting server, starting status report connectstrings creating from source code data nodes backups boolean values buffering checkpointing defined disk paging identifying intervals logging memory metadata objects multiple scans/buffering temporary storage timeouts transactions data types supported databases, importing defined disk paging disk-based records efficiency errors messages reporting limitations event logs categories checkpoint events cluster logs connection events defined error events format INFO events management commands node logs node restart events priorities security startup events statistics events thresholds failures forum fragments hardware operating system combinations requirements 2nd high-speed interconnects access methods performance benchmarks SCI sockets, configuring transporters hosts defined names storage in-memory storage indexes initialization intervals isolation levels language requirements limitations 2nd adding/dropping nodes behavior non-compliance error reporting missing features multi-computer multiple management servers multiple network interfaces multiple servers MySQL 4.1 node maximums online schema changes performance syntax noncompliance transactions unsupported features logging management commands parameters 2nd mailing list management client commands management nodes configuring defined installing multiple memory index requirements metadata objects multi-computers configuration 2nd functionality installation requirement MySQL 5.0 MySQL 5.1 NDBCluster storage engine networking requirements running nodes adding communication data 2nd defined failures groups 2nd initial restarts multiple restarting 2nd starting operating systems hardware combinations supported optimization overview partitioning 2nd performance privileges processes command options management client management server server storage engine node programs push-down conditions replicas 2nd replication abbreviations/symbols automatic backups backups, creating binlog-injector thread cluster-to-cluster layout compared failovers future support master cluster preparations problems requirements schema changes single channel tables two channels restarting restoring scans security share-nothing shared-memory connections shutting down 2nd single-user mode software installing requirements support SQL nodes accessing configuring defined installing queries, running starting 2nd 3rd stopping storage engine support system crashes/restarts tables autodiscovery defined definitions, customizing importing 2nd primary keys replicating TCP/IP connections timeouts transactions support temporary storage transport connections transporters 2nd troubleshooting variable-sized records clustered indexes CLUSTERLOG command CLUSTERLOG FILTER command CLUSTERLOG INFO command CLUSTERLOG OFF command CLUSTERLOG ON command collating strings collation-server option (mysqld) collation_connection system variable 2nd collation_database system variable (mysqld) collation_server system variable 2nd collecting table statistics column-names option 2nd columns indexes names columns option (mysqlimport) columns_priv table columns SET columns wildcard characters Com status variables command line history (mysql) multiple Windows servers programs invoking options command options mysql, help mysqld allow-suspicious-udfs ansi basedir bind-address binlog-format binlog-row-event-max-size bootstrap character-set-client-handshake character-set-filesystem character-set-server character-sets-dir chroot collation-server console core-file datadir debug default-character-set default-collation default-storage-engine default-table-type default-time-zone delay-key-write des-key-file enable-named-pipe exit-info external-locking flush help init-file innodb-safe-binlog language large-pages log log-bin log-bin-index log-bin-trust-function-creators log-bin-trust-routine-creators log-error log-isam log-long-format log-queries-not-using-indexes log-short-format log-slow-admin-statements log-slow-queries log-warnings low-priority-updates maximum memlock myisam-recover ndb-connectstring ndbcluster old-passwords one-thread open-files-limit pid-file port port-open-timeout reading safe-mode safe-show-database safe-user-create secure-auth shared-memory shared-memory-base-name skip-bdb skip-concurrent-insert skip-external-locking skip-grant-tables skip-host-cache skip-innodb skip-name-resolve skip-ndbcluster skip-networking skip-safemalloc skip-show-database skip-stack-trace skip-symbolic-links skip-thread-priority socket sql-mode standalone symbolic-links temp-pool tmpdir transaction-isolation user version commands binary distributions cluster logs Cluster process options CLUSTERLOG create debug delimiter drop ENTER SINGLE USER MODE executing EXIT SINGLE USER MODE extended-status FLUSH INSTANCES flush-hosts flush-logs flush-privileges flush-status flush-tables flush-threads HELP kill 2nd mysql delimiter list of options pager prompt status tee mysqladmin list of options mysqldump mysqlimport mysqlmanager ndb_mgm program old-password pager password ping processlist 2nd prompt QUIT refresh reload 2nd RESTART SET SHOW mysqlmanager ndb_mgm SHOW INSTANCE OPTIONS SHOW INSTANCE STATUS SHOW INSTANCES SHUTDOWN shutdown 2nd source distributions START START INSTANCE start-slave STATUS status mysql mysqladmin STOP STOP INSTANCE stop-slave syntax tee UNSET variables version comments comments option (mysqldump) commercial SSH client Web site commit option (mysqlaccess) commits, transactions 2nd compact option (mysqldump) compatibility lock type compatibility matrix MySQL versions Oracle password hashing PostgreSQL replication between versions standard SQL differences MySQL compatible option (mysqldump) compilers (C++) 2nd compiling optimization speed statically troubleshooting Windows source distribution Complete package complete-insert option (mysqldump) completion_type system variable 2nd compliance (Y2K) compress option mysql mysqladmin mysqlcheck mysqldump mysqlimport mysqlshow compressing MyISAM tables [See myisampack tables.] zlib lossless data compression Compression status variable Concurrent Connections dialog box concurrent inserts 2nd concurrent_insert system variable 2nd condition pushdowns conditions deleting null-rejected pushdowns Cluster EXPLAIN statements inner joins outer joins ranges config-file option mysqld_multi script ndb_mgmd config.cache file config.ini file COMPUTER parameters configuring connectstrings data nodes [See ndbd, ; parameters.] example INI format my.cnf example MYSQLD parameters NDB_MGMD parameters NDBD parameters backup boolean values buffering/logging logging/checkpointing memory metadata objects node identification scans/buffering temporary storage timeouts/intervals/disk paging transactions parameter values SCI section SHM section TCP_DEFAULT section configuration files C client library implementation Cluster computers, defining connectstrings data nodes, defining [See ndbd, ; parameters.] defined example INI format management server, defining my.cnf example parameter values shared-memory connections SQL nodes, defining TCP/IP connections transport connections config.ini [See parameters, config.ini file.] connection parameters global handling mysqld_multi script example mysqlmanager reading sample syntax user Windows installation Configuration Type dialog box configure script mysqld-max running after prior invocation source distribution installations configuring account passwords character sets Cluster configuration directory configuration file [See config.ini file.] from binary tarballs NDB Cluster storage engine nodes, starting server, starting status report Cluster multi-computers host storage InnoDB storage engine multiple tablespaces my.cnf file examples shared tablespaces tablespace files locks log files management nodes passwords program variables query cache replication SCI sockets driver installation network structure package installation requirements testing slave servers socket locations 2nd source distributions SQL nodes SSL certificates Confirmation dialog box connect-string option (NDB programs) connect_timeout system variable mysql mysqladmin mysqld connections events mysqlmanager remote servers 2nd shared-memory slave servers TCP/IP timeouts transport verification Connections status variable connectstrings consistent reads console messages console option (mysqld) constant tables EXPLAIN statements optimization constraints DEFAULT ENUM FOREIGN KEY handling invalid data NOT NULL NULL PRIMARY KEY SET UNIQUE controlling access connections, verifying requests, verifying query optimizer conventions, typographical convert_character_set system variable copy option (mysqlaccess) copying databases core-file option (mysqld) core-file-size option (mysqld_safe) correct-checksum option (myisamchk) count option mysqladmin mysqlshow crash-me programs 2nd crashes recovery system create command (mysqladmin) CREATE privilege CREATE ROUTINE privilege CREATE TABLE statement 2nd CREATE TEMPORARY TABLES privilege CREATE USER privilege CREATE VIEW privilege create-options option (mysqldump) CREATE_FILE_EVENT event Created_tmp_disk_tables status variable Created_tmp_files status variable Created_tmp_tables status variable cryptographic signatures CSV storage engine 2nd CSV tables curly braces ({ }) current version Custom Install dialog box customers of MySQL customizing grant tables 2nd privileges table definitions Windows installations CXX environment variable C++ compiler problems compiler names compiler settings CXXFLAGS environment variable compiler settings flags, defining |
Категории