MySQL 5.7官方手册：新特性与NDBCluster 7.5/7.6详解
需积分: 8 172 浏览量
更新于2024-07-19
收藏 38.38MB PDF 举报
"MySQL 5.7官方手册是MySQL官方于2018年2月发布的最新文档，涵盖了MySQL 5.7系列的版本5.7.0至5.7.22，以及基于NDB Cluster 7.5的相应版本。该手册详细介绍了MySQL 5.7的主要特性和功能，这些特性可能并非所有版本都包含，用户应参考自己的授权协议了解具体涵盖内容。
MySQL 5.7作为一款多线程的SQL数据库服务器，其显著特点是执行性能高、运行速度快且易于使用，这使得它在全球范围内广受欢迎。手册中特别强调了那些在不同版本中有所差异的高级功能，如果用户对所使用的MySQL 5.7版本的特性有疑问，应查阅相关许可证协议或联系Oracle的销售代表获取更多信息。
手册还提供了关于每个版本更新的详细变化记录，用户可以通过MySQL 5.7 Release Notes获取这部分内容。对于法律条款，用户需要查看Legal Notices部分，以确保理解和遵守相关规定。
在遇到MySQL使用问题时，手册建议用户前往MySQL论坛或邮件列表进行讨论，与其他MySQL用户交流解决方案。此外，MySQL产品还提供了丰富的额外文档，包括翻译成多种语言的版本和可供下载的不同格式（如HTML和PDF），用户可以在MySQL Documentation Library中找到这些资源。
最后，手册提供了关于MySQL 5.7的许可证信息，这是理解如何合法使用和授权的重要部分。MySQL 5.7官方手册是开发者和管理员深入了解和掌握MySQL 5.7的核心工具，无论是初次接触还是深入研究，都是不可或缺的参考资料。"
MySQL 5.7 Reference Manual
xvi
14.17.3 InnoDB Standard Monitor and Lock Monitor Output ............................................ 2626
14.18 InnoDB Backup and Recovery ..................................................................................... 2632
14.18.1 InnoDB Backup ................................................................................................ 2632
14.18.2 InnoDB Recovery ............................................................................................. 2633
14.19 InnoDB and MySQL Replication ................................................................................... 2636
14.20 InnoDB memcached Plugin .......................................................................................... 2638
14.20.1 Benefits of the InnoDB memcached Plugin ........................................................ 2638
14.20.2 InnoDB memcached Architecture ...................................................................... 2639
14.20.3 Setting Up the InnoDB memcached Plugin ........................................................ 2643
14.20.4 Security Considerations for the InnoDB memcached Plugin ................................ 2649
14.20.5 Writing Applications for the InnoDB memcached Plugin ...................................... 2651
14.20.6 The InnoDB memcached Plugin and Replication ................................................ 2664
14.20.7 InnoDB memcached Plugin Internals ................................................................. 2668
14.20.8 Troubleshooting the InnoDB memcached Plugin ................................................ 2672
14.21 InnoDB Troubleshooting .............................................................................................. 2674
14.21.1 Troubleshooting InnoDB I/O Problems ............................................................... 2675
14.21.2 Forcing InnoDB Recovery ................................................................................. 2676
14.21.3 Troubleshooting InnoDB Data Dictionary Operations .......................................... 2677
14.21.4 InnoDB Error Handling ...................................................................................... 2681
15 Alternative Storage Engines ..................................................................................................... 2683
15.1 Setting the Storage Engine ............................................................................................ 2687
15.2 The MyISAM Storage Engine ........................................................................................ 2687
15.2.1 MyISAM Startup Options .................................................................................... 2690
15.2.2 Space Needed for Keys ..................................................................................... 2691
15.2.3 MyISAM Table Storage Formats ......................................................................... 2692
15.2.4 MyISAM Table Problems .................................................................................... 2694
15.3 The MEMORY Storage Engine ...................................................................................... 2696
15.4 The CSV Storage Engine .............................................................................................. 2700
15.4.1 Repairing and Checking CSV Tables .................................................................. 2701
15.4.2 CSV Limitations ................................................................................................. 2702
15.5 The ARCHIVE Storage Engine ...................................................................................... 2702
15.6 The BLACKHOLE Storage Engine ................................................................................. 2703
15.7 The MERGE Storage Engine ......................................................................................... 2706
15.7.1 MERGE Table Advantages and Disadvantages .................................................... 2708
15.7.2 MERGE Table Problems ..................................................................................... 2709
15.8 The FEDERATED Storage Engine ................................................................................. 2711
15.8.1 FEDERATED Storage Engine Overview .............................................................. 2711
15.8.2 How to Create FEDERATED Tables ................................................................... 2712
15.8.3 FEDERATED Storage Engine Notes and Tips ..................................................... 2715
15.8.4 FEDERATED Storage Engine Resources ............................................................ 2717
15.9 The EXAMPLE Storage Engine ..................................................................................... 2717
15.10 Other Storage Engines ................................................................................................ 2717
15.11 Overview of MySQL Storage Engine Architecture ......................................................... 2717
15.11.1 Pluggable Storage Engine Architecture .............................................................. 2718
15.11.2 The Common Database Server Layer ................................................................ 2718
16 Replication ............................................................................................................................... 2721
16.1 Configuring Replication .................................................................................................. 2722
16.1.1 Binary Log File Position Based Replication Configuration Overview ....................... 2723
16.1.2 Setting Up Binary Log File Position Based Replication ......................................... 2723
16.1.3 Replication with Global Transaction Identifiers ..................................................... 2733
16.1.4 MySQL Multi-Source Replication ......................................................................... 2743
16.1.5 Changing Replication Modes on Online Servers ................................................... 2747
16.1.6 Replication and Binary Logging Options and Variables ......................................... 2753
16.1.7 Common Replication Administration Tasks .......................................................... 2840
剩余5423页未读，继续阅读
936 浏览量
点击了解资源详情
225 浏览量
181 浏览量
2021-03-19 上传
102 浏览量
2016-08-01 上传
165 浏览量
357 浏览量
jza6005186
- 粉丝: 0
- 资源: 6
我的内容管理
展开
最新资源
- C#调用AForge控制USB摄像头进行拍照录像
- cucumber-step-generator:Atom软件包，用于从特征文件生成Cucumber步骤文件
- JS响应式3D照片墙展示特效.zip
- leetcode耗时-starting-in-ds-advice:开始在ds建议
- 土拨鼠
- 财务报告编制准备管理制度DOC
- caffe-d.zip
- teenchoice
- write.github.io
- acid:ACID是算法创建图像数据的缩写，是一种简单的通用视频合成器，用于创建实时图像以及计算机生成的图像和动画。 它的工作原理与模拟合成器类似，但其中包含一些Photoshop
- find-bicycle-frontend:客户端部分，如果查找自行车应用程序
- 定制应用程序仪表板:homepage
- leetcode耗时-30_projects:30_projects
- 日期与时间c++.zip
- phoenix-react-apollo-demo:将Phoenix框架与React和GraphQL结合使用的示例应用程序
- MakersBnB
