Session 1: CLIENT PROGRAMS FOR DBA WORK
- Introduction
- Client Program Limitations
- mysql
- MySQL Admin
Session 2: THE INFORMATION_SCHEMA DATABASE
- What is Metadata?
- The mysqlshow Utility
- The SHOW and DESCRIBE Commands
- The Information_Schema Database
Session 3: MYSQL ADMINISTRATOR
- Installation
- Connecting
- Server Information
- Service Control
- User Administration
- Privileges
- Health
- Backup and Restore
- Catalogs
Session 4: INSTALLING, CONFIGURING, STARTING AND STOPPING
- MySQL Distributions
- Installing on Windows
- Installing on Linux and UNIX
- Starting and Stopping on Windows
- Starting and Stopping on UNIX/Linux
- Configuration
- Log and Status Files
- The Default SQL Mode
- Time Zone Tables
- Some Security Issues
- Upgrading
Session 5: INTERPRETING ERROR AND DIAGNOSTIC INFORMATION
- MySQL Error Messages
- The SHOW Statement
- SQL Modes
- The PERROR Utility
- The Log
- The Error Log
- The Slow Query Log
Session 6: MYSQL ARCHITECTURE
- Client/Server Overview
- Communication Protocols
- The SQL Parser and Storage Engine Tiers
- How MySQL Uses Disk Space
- How MYSQL Uses Memory
Session 7: TABLES, DATA TYPES AND CHARACTER SET SUPPORT
- Table Properties
- Creating Tables
- Altering Tables
- Dropping Tables
- Emptying Tables
- Obtaining Table Metadata
- Column Attributes
- Bit Data Type
- Numeric Data Types
- Character String Data Types
- Binary String Data Types
- Enum and Set Data Types
- Temporal Data Types
- Auto_Increment
- Handling Missing or Invalid Data Values
- Performance Issues with Character sets
- Choosing Data Types for Character Columns
Session 8: LOCKING
- Locking Concepts
- Explicit Table Locking
- Advisory Locking
- Preventing Locking Problems
Session 9: STORAGE ENGINES
- Introduction
- The MYISAM Engine
- Locking with MYISAM Tables
- The Merge Engine
- Other Engines: Archive, Memory, Federated, Blackhole, NDBCluster
Session 10: THE INNODB ENGINE
- Introduction
- Features of Innodb
- Transactions
- Referential Integrity
- Physical Characteristics of Innodb Tables
- Tablespace Configuration
- Log File and Buffer Configuration
- Innodb Status
Session 11: TABLE MAINTENANCE
- Table Maintenance Operations
- Check Table
- Repair Table
- Analyze Table
- Optimize Table
- MySQL Check
- MYISAMCHK
- Repairing Innodb Tables
- Enabling MYISAM AutoRepair
Session 12: BACKUP AND RECOVERY
- Planning and Implementing a Backup and Recovery Strategy
- Defining a Disaster Recovery Plan
- Testing a Backup and Recovery Plan
- The Advantages and Disadvantages of Different Methods
- Binary Backups of MYISAM Tables
- Binary Backups of Innodb Tables
- Recovery
- Import and Export Operations
- Exporting Using SQL
- Importing Using SQL
- Exporting from the Command Line using mysqldump
- Importing from the Command Line using mysqlimport
Session 13: USER MANAGEMENT
- Introduction
- User Accounts
- Creating Users
- Renaming Users
- Changing Passwords
- Dropping Users
- Granting Privileges
- The User Table
- Connection Validation
Session 14: PRIVILEGES
- Introduction
- Types of Privileges
- Revoking Privileges
- Resource Limits
- The MySQL Database
- The Show Grants Command
Session 15: USER VARIABLES AND PREPARED STATEMENTS
- User Variables
- Prepared Statements
Session 16: STORED ROUTINES FOR ADMINISTRATION
- Types of Stored Routines
- Benefits of Stored Routines
- Stored Routines Features
- Stored Routine Maintenance
- Stored Routine Privileges and Execution Security
Session 17: TRIGGERS
- DML Triggers
- The Create Trigger Statement
- Managing Triggers
Session 18: SECURING THE SERVER
- Security Issues
- Operating System Security
- Filesystem Security
- Log Files and Security
- Network Security
- Upgrade-related Security Issues
- Upgrading the Privilege Tables
- Security-Related SQL_Mode Values
Session 19: OPTIMIZING QUERIES
- Optimization Overview
- Optimization Process
- Planning a Routine Monitoring Regime
- Setting Suitable Goals
- Identifying Candidates for Query Analysis
- Using Explain to Analyze Queries
- Meaning of Explain Output
- Using Explain Extended
Session 20: OPTIMIZATION AND INDEXES
- Indexes for Performance
- Creating and Dropping Indexes
- Obtaining Index Metadata
- Indexing Principles
- Indexing and Joins
- MyIsam Index Caching
Session 21: OPTIMIZING SCHEMAS
- Normalisation
- General Table Optimizations
- Myisam Specific Optimizations
- Innodb Specific Optimizations
- Other Engine Specific Optimizations
Session 22: OPTIMIZING THE SERVER
- Measuring Server Load
- System Factors
- Server Parameters
- Query Optimizer Performance
- The Query Cache
Session 23: OPTIMIZING THE ENVIRONMENT
- Choosing the Platform
- Hardware Configurations
- Disk Issues on Linux
- Symbolic Links
- Optimizing the Operating System
Session 24: THE EVENT SCHEDULER
- Event scheduler concepts
- Event scheduler configuration
- Creating, altering and dropping events
- Event scheduler monitoring
- Events and privileges
Session 25: PARTITIONED TABLES
- Partitioned tables concepts
- Range partitioning
- Hash partitioning
- Key partitioning
- List partitioning
- Composite partitioning or subpartitioning
- Maintenance of partitioned tables
Session 26: SCALING MYSQL
- Using Multiple Servers
- Replication