MySQL 5.6 Database Administration Certification Guide
Introduction
MySQL Architecture
Client\/Server Overview
Communication Protocols
Connecting to MySQL Server
The SQL Parser and Storage Engines
How MySQL uses Disk Space
How MySQL Uses Memory
Monitoring MySQL Memory Usage
System Administration
Types of MySQL Distributions
Starting and Stopping MySQL Server on Unix
Runtime Configuration
Loading Timezone Tables
Setting Default SQL Mode
Upgrading MySQL Server
Client Programs for DBA Work
MySQL WorkBench
Command Line Clients
mysqladmin - Client for Administering a MySQL Server
mysqlcheck - A Table Maintenance Program
mysqldump - A Database Backup Program
mysqlimport - A Data Import Program
mysqlshow - Display Database, Table, and Column Information
mysqlslap - Load Emulation Client
MySQL Workbench
User Management
Data Types
Character Set Support
Transactions and Locking
Locking Concepts
Advisory Locks
Obtaining Metadata
Storage Engines
MySQL Storage Engines Overview
MyISAM Storage Engine
InnoDB Storage Engine
InnoDB Memcached Storage Plugin
Memory Engine
Federated Engine
Partitioning
Why Partition
Types of Partitioning
Creating Partitioned Tables
Obtaining Partition Metadata
Security
Table Maintenance
Exporting and Importing Data
Programming inside MySQL
MySQL Backup and Recovery
Replication
Setting Master Server
Setting Up Replication on the Salve Database
Introduction to Performance Tuning
Index Types
Clustered Index
Secondary Index
Basic Indexing
Order of Indexes
OR Conditional with Indexes
Powered by
GitBook
InnoDB Memcached Storage Plugin
InnoDB Memcached Plugin
results matching "
"
No results matching "
"