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] tab option (mysqldump) table option mysql mysqlaccess table-level locking table_cache system variable 2nd 3rd Table_locks_immediate status variable Table_locks_waited status variable TABLE_MAP_EVENT event table_type system variable 2nd tables apply_status ARCHIVE 2nd BDB 2nd characteristics installing mysqld-max support operating systems supported overview restrictions startup options troubleshooting binlog_index BLACKHOLE 2nd checking columns_priv columns scope/privilege columns SET columns wildcard characters compressing characteristics examples constant EXPLAIN statements optimization crash recovery CSV 2nd db 2nd default values definitions defragmenting 2nd 3rd details, viewing dumping dynamic eq_ref error checking EXAMPLE 2nd FEDERATED creating flow of information forum functionality limitations overview flush grant changes 2nd initializing privileges re-creating scope columns server functionality sorting structure host importing 2nd indexes, adding InnoDB AUTO_INCREMENT columns autocommit mode backups configuring contact information crash recovery creating defragmenting disk I/O error handling file space management forcing recovery foreign key constraints forum fuzzy checkpointing index structures initialization problems InnoDB Monitors intention locks locking [See InnoDB storage engines, ; locking.] moving between machines multi-versioning multiple tablespaces my.cnf file examples MyISAM table conversions options overview performance tuning recovering from backups replication restrictions shared tablespaces size startup options system variables tablespaces 2nd transactions [See InnoDB storage engine, ; transactions.] troubleshooting maintenance 2nd MEMORY 2nd MERGE advantages creating disadvantages forum overview problems queries, issuing remapping MyISAM automatic recovery characteristics compressing [See backup option, myisampack.] converting to InnoDB tables corruption forum key caches key space maintenance not closed properly overview startup options statistics collection storage 2nd system variables names NDB [See NDB storage engine.] non-transaction-safe non-transactional opening/closing 2nd optimizing partitioning performance improvements procs_priv columns scope/privilege columns SET columns ref repairing 2nd scans, avoiding size limitations static statistics collection symbolic links system EXPLAIN statements testing/repairing upgrading tables_priv columns scope/privilege columns SET columns wildcard characters temporary too many transactions 2nd types [See choosing, storage engines.] updating user columns Host/User values netmask notation sorting wildcard characters WHERE clauses optimization tables option mysqlcheck mysqldump tables_priv table columns scope/privilege columns SET columns wildcard characters tablespaces InnoDB 2nd moving multiple sharing tcp-ip option (mysqld_multi script) TCP/IP networking config.ini file parameters enabling/disabling support testing Windows installation tee command (mysql) tee option (mysql) temp-pool option (mysqld) temporary files temporary tables test option (myisampack) testing post-installation accounts Unix Windows releases SCI sockets server connections system tables Windows installation TEXT columns text files thread_cache_size system variable 2nd thread_concurrency system variable (mysqld) thread_stack system variable (mysqld) threads active non-native support support Threads_cached status variable Threads_connected status variable Threads_created status variable Threads_running status variable thresholds (cluster event logs) tight index scans time zones time_format system variable (mysqld) time_zone system variable 2nd TimeBetweenGlobalCheckpoints parameter (config.ini file) TimeBetweenInactiveTransaction-AbortCheck parameter (config.ini file) TimeBetweenLocalCheckpoints parameter (config.ini file) TimeBetweenWatchDogCheck parameter (config.ini) timeouts Cluster connect_timeout 2nd shutdown_timeout variable timestamp dynamic system variable timezone option (mysqld_safe script) tips mysql optimization tmp_table_size system variable 2nd TMPDIR environment variable tmpdir option myisamchk myisampack mysqld mysqlhotcopy tmpdir system variable (mysqld) to-last-log option (mysqlbinlog) tools TRADITIONAL SQL mode 2nd transaction-isolation option (mysqld) transaction-safe tables (TSTs) transaction_alloc_block_size system variable 2nd transaction_prealloc_size system variable 2nd TransactionBufferMemory parameter (config.ini file) TransactionDeadlockDetectionTimeout parameter (config.ini file) TransactionInactiveTimeout parameter (config.ini file) transactions binary logs Cluster limitations parameters support temporary storage parameters InnoDB tables autocommit mode consistent read example consistent reads implicit commits/rollbacks isolation levels support 2nd transporters connections defined trees BitKeeper downloading installing Windows source distribution, building development source triggers triggers option (mysqldump) troubleshooting access denied errors BDB tables character sets Cluster backups error messages failures replication 2nd split brain scenario compiling debugging support disk performance FreeBSD InnoDB tables data dictionaries error handling errors initialization problems Linux errors Windows errors Mac OS X package installer MERGE tables MyISAM tables mysql_install_db script Perl installation phantom problem replication Solaris Solaris x86_64 issues starting servers table-level locking tables, too many Windows installation try-reconnect option (ndb_mgm) TSTs (transaction-safe tables) two-way replication 2nd tx_isolation system variable 2nd typographical conventions 2nd tz-utc option (mysqldump) |
Категории