1. Introduction.
|
|
|
|
|
1.1 History of MySQL
|
|
|
1.2 The Main Features of MySQL
|
|
|
1.3 Architecture of MySQL
|
|
2. MySQL Installation.
2.1 RPM Installation
2.2 Generic Binaries Installation
2.3 Source Code Installation
3. Initialization of MySQL Related
Programs.
3.1 mysql_install_db ―
Initialize MySQL Data Directory
3.2 mysql_secure_installation ―
Improve MySQL Installation Security
3.3 mysql_tzinfo_to_sql ― Load
the Time Zone Tables
|
|
|
|
|
|
|
|
4. MySQL Server-Startup Scripts.
|
|
|
|
4.1
mysqld_safe ― MySQL Server Startup Script
|
|
4.2
mysql.server ― MySQL Server Startup Script
4.3 mysqld ― The MySQL Server
|
|
4.3
mysqld_multi ― Manage Multiple MySQL Servers
|
|
5. MySQL User Account Management.
5.5.1 User Names and Passwords
5.5.2 Adding
User Accounts
5.5.3 Removing
User Accounts
5.5.4 Setting
Account Resource Limits
5.5.5 Assigning
Account Passwords
|
|
6. MySQL Storage Engines.
|
|
|
6.1 MyISAM Storage Engine
|
|
|
6.2 InnoDB Storage Engine
|
|
|
6.3 MERGE Storage Engine
|
|
|
6.4 MEMORY Storage Engine
|
|
|
6.5 EXAMPLE Storage Engine
|
|
|
6.6 FEDERATED Storage Engine
|
|
|
6.7 ARCHIVE Storage Engine
|
|
|
6.8 CSV Storage Engine
|
|
|
6.9 BLACKHOLE Storage Engine
|
|
7. MySQL Clients.
|
|
|
7.1 mysql ― The MySQL
Command-Line Tool
|
|
|
7.2 mysqladmin ― Client for
Administering a MySQL Server
|
|
|
7.3 mysqlcheck ― A Table
Maintenance Program
|
|
|
7.4 mysqldump ― A Database
Backup Program
|
|
|
7.5 mysqlimport ― A Data Import
Program
|
|
|
7.6 mysqlshow ― Display
Database, Table, and Column Information
|
|
|
7.7 mysqlslap ― Load Emulation
Client
|
|
8. MySQL Administrative and Utilities.
|
|
|
8.1 myisamchk ― MyISAM Table-Maintenance
Utility
|
|
|
8.2 myisampack ― Generate
Compressed, Read-Only MyISAM Tables
|
|
|
8.3 mysqlaccess ― Client for
Checking Access Privileges
|
|
|
8.4 mysqlbinlog ― Utility for
Processing Binary Log Files
|
|
|
8.5 mysqlhotcopy ― A Database
Backup Program
|
|
|
8.6 mysql_convert_table_format
― Convert Tables to Use a Given Storage Engine
|
|
9. MySQL Server Administration.
|
|
|
9.1 Server System Variables
|
|
|
9.2 Server Status Variables
|
|
|
9.3 Server SQL Modes
|
|
10. MySQL Server Logs.
|
|
|
10.1 Error Log
|
|
|
10.2 General Query Log
|
|
|
10.3 Binary Log
|
|
|
10.4 Slow Query Log
|
|
11. Backup and Recovery.
|
|
|
11.1 Backup and Recovery Types
|
|
|
11.2 Database Backup Methods
|
|
|
11.3 Using mysqldump for
Backups
|
|
|
11.3.1 Dumping Data in SQL Format
|
|
|
11.3.2 Dumping Data in Delimited-Text Format
|
|
|
11.3.3 Reloading SQL-Format Backups
|
|
|
11.3.4 Backing Up and Recovering an InnoDB
Database
11.4 Incremental Backups
|
|
12. Running Multiple MySQL Instances on One Machine.
|
|
|
12.1 Setting Up Multiple Data
Directories
|
|
|
12.2 Running Multiple MySQL
Instances on Unix
|
|
|
12.3 Using mysqld_multi for
Managing Multiple MySQL Servers
|
|
13. Optimization.
|
|
|
13.1 Optimization Overview
|
|
|
13.2 Query Execution Plan
Information
|
|
|
13.2.1 Optimizing Queries with EXPLAIN
|
|
|
13.2.2 Optimizing SELECT Statements
|
|
|
13.3 Tuning Server Parameters
|
|
14. MySQL Partitions.
|
|
|
|
|
14.1 Partitioning Types
|
|
|
14.1.1 RANGE Partition
|
|
|
14.1.2 LIST Partition
|
|
|
14.1.3 HASH Partition
|
|
|
14.1.4 KEY Partition
|
|
|
14.1.5
Sub partition
|
|
|
14.2 Restrictions and
Limitations on Partitions
|
|
15. INFORMATION_SCHEMA Tables.
15.1 INFORMATION_SCHEMA TABLES Table
15.2 INFORMATION_SCHEMA
COLUMNS Table
15.3 INFORMATION_SCHEMA
VIEWS Table
15.4 INFORMATION_SCHEMA
TABLE_CONSTRAINTS Table
15.5 INFORMATION_SCHEMA ROUTINES Table
15.6 INFORMATION_SCHEMA TRIGGERS Table
15.7 INFORMATION_SCHEMA STATISTICS Table
15.8 INFORMATION_SCHEMA USER_PRIVILEGES Table
15.9 INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
15.10 INFORMATION_SCHEMA
TABLE_PRIVILEGES Table
15.11 INFORMATION_SCHEMA
COLUMN_PRIVILEGES Table
15.12 INFORMATION_SCHEMA
CHARACTER_SETS Table
15.13 INFORMATION_SCHEMA
COLLATIONS Table
15.14 INFORMATION_SCHEMA
PROFILING Table
|
|
16. Buffering and Caching.
|
|
|
16.1 MyISAM Key Cache
|
|
16.2 InnoDB Buffer Pool
|
|
16.3 MySQL Query Cache
|
17. Locking Issues.
|
|
|
17.1 Internal Locking Methods
|
|
17.2 Table Locking Issues
|
|
17.3 Concurrent Inserts
|
|
17.4 External Locking
|
18. High Availability and Scalability.
|
|
|
18.1 Replication
|
|
|
18.1.1 Replication Configuration
|
|
|
18.1.2 Replication Formats
|
|
|
18.1.3 Replication and Binary Logging Options and
Variables
|
|
Course | : | MySQL DBA |
Duration | : | 60 Hours |
Duration | : | MySQL DBA |
The course is yet to be scheduled