MySQL Chapter 3 培训资料.ppt

;;;;日志组; ;MySQL Arch;MySQL’s Logical Architecture;MySQL’s Logical Architecture;Connection Management and Security;Optimization and Execution;;Concurrency Control;Read/Write Locks;Lock Granularity;Table locks;Row locks;Transactions;Isolation Levels;;Transaction life cycle;Savepoints;READ UNCOMMITTED;READ COMMITTED;REPEATABLE READ;SERIALIZABLE;ANSI SQL isolation levels;Modifying the Transaction Isolation Level;Pseudo-Transactions;Locking models and concurrency in MySQL;Deadlocks;Transaction Logging;Transactions in MySQL;AUTOCOMMIT;Mixing storage engines in transactions;Implicit and explicit locking;;Multiversion Concurrency Control;Understanding Storage Engines;MySQL Server Storage Engine Overview;;MyISAM storage engine;;MyISAM Configuration Options;MyISAM utilities;myisamchk;myisampack;Merge storage engine;InnoDB storage engine;;Tablespace configuration variables;;InnoDB Performance Configuration Variables;InnoDB Status Sections;InnoDB tablespace management;Working with ibdata files;InnoDB log files and crash recovery;; ;;About MySQL Users;Access Control Lists;Wildcards;System tables;Managing User Accounts;Approaches to Account Management ;Types of Privileges That MySQL Supports ;;;;The Grant Tables ;Granting Privileges ;;;Revoking Privileges ;Changing Account Passwords ;Disabling Client Access Control ;When Privilege Changes Take Effect ; ;;Introduction;How the Cache Uses Memory;;2byte;Query cache invalidation;Query cache pruning;When the Query Cache Is Helpful;;Query cache memory usage and tuning;;Query Cache System Variables;Query cache status variables;Query Cache Status Variables;Hits ratio;Query cache fragmentation;Utilizing memcached;;., , Age;;Logs, Backups and Recovery;SQL，IO;;;;完全备份;;;;;;;Log Files;Error log;;Binary logs;DML, DCL, DDL;;sync, async;FIO: Fusion-IO;恢复;;;;;;;;;Mysqlbinlog examples;Server Variables Used to Manage General and Slow Query Logs;Rotating logs;About Backup;Some principles with regard to backups ;Logical backup;Physical backup;Full bac