MySQL 5.6 教程与参考手册
3星 · 超过75%的资源 需积分: 9 141 浏览量
更新于2024-07-26
收藏 29.54MB PDF 举报 "MySQL 5.6 Reference Manual"
MySQL 5.6 Reference Manual 是一本全面介绍 MySQL 5.6 版本的官方文档，涵盖了从5.6.1开始的所有细节。该手册旨在为数据库管理员、开发者和其他技术专业人员提供关于MySQL 5.6功能和使用的详尽指南。
MySQL 5.6版本引入了许多重要的增强和优化，包括性能提升、存储引擎改进、安全性的加强以及新特性的添加。例如，InnoDB存储引擎在这一版本中得到了显著的性能提升，支持更高的并发处理能力和更快的数据读写速度。此外，分区功能也得到了扩展，使得大型表的管理和查询更为高效。
文档中的"Getting Started"章节为初学者提供了入门指导，介绍了在各种操作系统（如Linux/Unix、MacOS X、Windows）上安装MySQL 5.6的步骤。对于管理员，有详细的服务器选项和变量参考，帮助他们配置和优化服务器环境。开发者可以找到SQL语法的全面概述，学习如何编写高效的查询语句。
在HA（高可用性）和可扩展性方面，MySQL 5.6提供了多种解决方案，如复制技术的改进和新的连接器支持。例如，MySQL Cluster在5.6版本中未被直接支持，但用户可以参考其他版本的MySQL Cluster NDB文档来了解相关技术。此外，手册还提到了MySQL与DRBD（分布式冗余磁盘阵列）的集成，以实现数据的高可用性和灾难恢复。
"SQLSyntax"部分详细阐述了MySQL的SQL语法，包括DML（数据操作语言）、DDL（数据定义语言）和DCL（数据控制语言）。同时，存储过程和触发器等数据库对象的创建和管理也在这部分得到详细解释。
"Connector"章节介绍了不同编程语言（如Java的Connector/J、.NET的Connector/NET）与MySQL的接口，帮助开发者在各自的应用环境中与数据库进行交互。
"Upgrading"章节则为从旧版本升级到MySQL 5.6的用户提供指导，详细说明了升级过程和可能遇到的问题，以及不同版本之间的兼容性和变化。
MySQL 5.6 Reference Manual 是一个综合性的技术资源，涵盖了从安装、配置、开发到维护MySQL 5.6系统的全方位知识，是所有MySQL 5.6用户和开发者的必备参考资料。
16.4.6. How to Report Replication Bugs or Problems ....................................................................1729
17. Partitioning .................................................................................................................................1730
17.1. Overview of Partitioning in MySQL .........................................................................................1731
17.2. Partition Types ...................................................................................................................1733
17.2.1. RANGE Partitioning ...................................................................................................1734
17.2.2. LIST Partitioning .....................................................................................................1737
17.2.3. COLUMNS Partitioning ...............................................................................................1739
17.2.4. HASH Partitioning .....................................................................................................1745
17.2.5. KEY Partitioning ......................................................................................................1748
17.2.6. Subpartitioning ........................................................................................................1749
17.2.7. How MySQL Partitioning Handles NULL .........................................................................1752
17.3. Partition Management ..........................................................................................................1755
17.3.1. Management of RANGE and LIST Partitions .....................................................................1756
17.3.2. Management of HASH and KEY Partitions ........................................................................1760
17.3.3. Exchanging Partitions and Subpartitions with Tables ............................................................1761
17.3.4. Maintenance of Partitions ............................................................................................1764
17.3.5. Obtaining Information About Partitions ...........................................................................1765
17.4. Partition Pruning ................................................................................................................1767
17.5. Restrictions and Limitations on Partitioning ................................................................................1770
17.5.1. Partitioning Keys, Primary Keys, and Unique Keys .............................................................1774
17.5.2. Partitioning Limitations Relating to Storage Engines ............................................................1777
17.5.3. Partitioning Limitations Relating to Functions ...................................................................1777
18. Stored Programs and Views ..............................................................................................................1779
18.1. Defining Stored Programs ......................................................................................................1779
18.2. Using Stored Routines (Procedures and Functions) ........................................................................1780
18.2.1. Stored Routine Syntax ................................................................................................1781
18.2.2. Stored Routines and MySQL Privileges ...........................................................................1781
18.2.3. Stored Routine Metadata .............................................................................................1782
18.2.4. Stored Procedures, Functions, Triggers, and LAST_INSERT_ID() ........................................1782
18.3. Using Triggers ...................................................................................................................1782
18.3.1. Trigger Syntax .........................................................................................................1783
18.3.2. Trigger Metadata ......................................................................................................1784
18.4. Using the Event Scheduler .....................................................................................................1785
18.4.1. Event Scheduler Overview ..........................................................................................1785
18.4.2. Event Scheduler Configuration .....................................................................................1786
18.4.3. Event Syntax ...........................................................................................................1788
18.4.4. Event Metadata ........................................................................................................1788
18.4.5. Event Scheduler Status ...............................................................................................1789
18.4.6. The Event Scheduler and MySQL Privileges .....................................................................1789
18.5. Using Views .....................................................................................................................1791
18.5.1. View Syntax ...........................................................................................................1792
18.5.2. View Processing Algorithms ........................................................................................1792
18.5.3. Updatable and Insertable Views ....................................................................................1793
18.5.4. View Metadata ........................................................................................................1795
18.6. Access Control for Stored Programs and Views ............................................................................1795
18.7. Binary Logging of Stored Programs ..........................................................................................1796
19. INFORMATION_SCHEMA Tables ......................................................................................................1802
19.1. The INFORMATION_SCHEMA SCHEMATA Table .......................................................................1803
19.2. The INFORMATION_SCHEMA TABLES Table ...........................................................................1804
19.3. The INFORMATION_SCHEMA COLUMNS Table .........................................................................1805
19.4. The INFORMATION_SCHEMA STATISTICS Table ....................................................................1806
19.5. The INFORMATION_SCHEMA USER_PRIVILEGES Table ...........................................................1806
19.6. The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table .......................................................1807
19.7. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table .........................................................1807
19.8. The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table .......................................................1808
19.9. The INFORMATION_SCHEMA CHARACTER_SETS Table .............................................................1808
19.10. The INFORMATION_SCHEMA COLLATIONS Table ..................................................................1809
19.11. The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table ..................1809
19.12. The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table ......................................................1809
19.13. The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table ........................................................1810
19.14. The INFORMATION_SCHEMA ROUTINES Table ......................................................................1811
19.15. The INFORMATION_SCHEMA VIEWS Table ...........................................................................1812
19.16. The INFORMATION_SCHEMA TRIGGERS Table ......................................................................1813
19.17. The INFORMATION_SCHEMA PLUGINS Table ........................................................................1814
19.18. The INFORMATION_SCHEMA ENGINES Table ........................................................................1815
MySQL 5.6 Reference Manual
xvi
剩余3348页未读，继续阅读
178 浏览量
117 浏览量
117 浏览量
247 浏览量
118 浏览量
292 浏览量
224 浏览量
2013-11-17 上传
117 浏览量
eyulaochen
- 粉丝: 1
- 资源: 4
我的内容管理
展开
最新资源
- 测试一下
- 倒霉熊图标下载
- SETFSB.zip
- marathon_3:免费的智力马拉松HTML-学院
- BlenderGEResourceKit:Blender游戏引擎的即用型组件集合
- winsdksetup.zip
- Aikatsu LGTM-crx插件
- dsm-htpc-群集
- simple-password-manager:Flutter制作的简单密码管理应用
- 精美蝴蝶图标下载
- 电信设备-带身份核验的物联网移动终端及人证合一核验方法.zip
- 初级java笔试题-cs-study:https://github.com/jwasham/coding-interview-universi
- MinGW压缩包省去繁琐的官网下载
- SYIPAGeneratedScript:make a ipa by script——使用脚本生成ipa包
- VTS Testing Version 2-crx插件
- 帮手
