学习MySQL的参考资料

以下是一些参考资料

MySQL Architecture

1.      UseMySQL client programs to interface with the MySQL Server interactively and inbatch

o  http://dev.mysql.com/doc/refman/5.6/en/programs-client.html

2.      Describehow MySQL uses disk and memory resources

o  http://dev.mysql.com/doc/refman/5.6/en/memory-use.html

o  http://dev.mysql.com/doc/refman/5.6/en/disk-issues.html

3.      Listand describe key characteristics of standard MySQL storage engines includingInnoDB, NDB, MyISAM, MEMORY, FEDERATED

o  http://dev.mysql.com/doc/refman/5.6/en/storage-engines.html

MySQL Server Installation, Configuration andMaintenance

1.      Select,deploy, start and stop MySQL using appropriate binary packages for Windows andLinux platforms

o  http://dev.mysql.com/doc/refman/5.6/en/binary-installation.html

o  http://dev.mysql.com/doc/refman/5.6/en/windows-installation.html

o  http://dev.mysql.com/doc/mysql-startstop-excerpt/5.6/en/index.html

2.      ConfigureMySQL Server deployments using options files, command-line options and servervariables

o  http://dev.mysql.com/doc/refman/5.6/en/server-parameters.html

3.      Identify,configure, locate and describe appropriate use cases for MySQL the error,binary, general query and slow query log

o  http://dev.mysql.com/doc/refman/5.6/en/server-logs.html

MySQL Security

1.      Describeappropriate steps to secure a MySQL deployment at the operating system,filesystem and network levels

o  http://dev.mysql.com/doc/refman/5.6/en/faqs-security.html

2.      Createand maintain user accounts with appropriate privileges and configuration

o  http://dev.mysql.com/doc/refman/5.6/en/privilege-system.html

o  http://dev.mysql.com/doc/refman/5.6/en/user-account-management.html

3.      Deployand configure MySQL Enterprise Audit

o  http://www.mysql.com/products/enterprise/audit.html

o  http://dev.mysql.com/doc/refman/5.5/en/audit-log-plugin.html

Diagnostic Data and Metadata Sources in MySQL

1.      Configureand leverage PERFORMANCE_SCHEMA tables to identify and diagnose performanceproblems

o  http://dev.mysql.com/doc/refman/5.6/en/performance-schema.html

2.      ObtainMySQL metadata from INFORMATION_SCHEMA tables

o  http://dev.mysql.com/doc/refman/5.6/en/information-schema.html

Optimizing MySQL Performance

1.      Demonstrateability to diagnose and optimize poorly-performing queries

o  http://dev.mysql.com/doc/refman/5.6/en/statement-optimization.html

o  http://dev.mysql.com/doc/refman/5.6/en/execution-plan-information.html

2.      TuneMySQL Server configuration for best performance

o  http://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb.html

o  http://dev.mysql.com/doc/refman/5.6/en/optimizing-myisam.html

o  http://dev.mysql.com/doc/refman/5.6/en/optimizing-memory-tables.html

3.      Createand utilize table partitioning

o  http://dev.mysql.com/doc/refman/5.6/en/partitioning.html

4.      Applybest practices in optimizing schema objects

o  http://dev.mysql.com/doc/refman/5.6/en/optimizing-database-structure.html

o  http://dev.mysql.com/doc/refman/5.6/en/optimization-indexes.html

5.      Demonstrateunderstanding of locking concepts as applied to MySQL Server and storageengines

o  http://dev.mysql.com/doc/refman/5.6/en/locking-issues.html

Backups and Recovery in MySQL

1.      Createand restore logical backups using mysqldump

o  http://dev.mysql.com/doc/mysql-backup-excerpt/5.6/en/using-mysqldump.html

2.      Createand restore binary backups

o  http://dev.mysql.com/doc/mysql-backup-excerpt/5.6/en/innodb-backup.html

o  http://dev.mysql.com/doc/refman/5.6/en/mysql-enterprise-backup.html

3.      Usebackups for data recovery

o  http://dev.mysql.com/doc/mysql-backup-excerpt/5.6/en/point-in-time-recovery.html

High Availability Techniques for MySQL

1.      Describe,configure, deploy and troubleshoot MySQL replication

o  http://dev.mysql.com/doc/refman/5.6/en/replication-semisync.html

o  http://dev.mysql.com/doc/refman/5.6/en/replication.html

2.      Describeand contrast characteristics of common MySQL high availability solutions (MySQLCluster, DRBD, Windows Failover Clustering, Solaris Cluster, OVM Template forMySQL Enterprise)

o  http://dev.mysql.com/doc/mysql-ha-scalability/en/index.html

以上的资料只做参考，是有一个e家装网的朋友的朋友介绍的，请读者斟酌考虑。