MySQL 8.0官方参考手册：新功能与NDB Cluster详解
需积分: 9 86 浏览量
更新于2024-07-17
收藏 45.15MB PDF 举报
MySQL 8.0 Reference Manual 是一个权威的文档，涵盖了MySQL 8.0至8.0.18的主要版本，以及基于NDB 8.0.8-ndb-8.0.15的NDB Cluster版本。这份文档不仅详尽地解释了数据库管理系统的核心功能，还可能包含了未公开发布但计划引入的特性。对于用户来说，理解这些未来可能的功能是非常重要的，因为它可以帮助他们规划升级路径并充分利用新技术。
手册特别强调了不同版本之间的差异，指出并非所有功能都会出现在每一个MySQL 8.0发行版中。这意味着用户在选择适合自己环境的版本时，需要仔细阅读许可协议，确保所使用的功能符合授权范围。如果对当前版本的功能有疑问，可以通过查阅官方许可协议或咨询Oracle的销售代表来获取准确信息。
此外，MySQL 8.0的每一份新版本都伴随着详细的发行说明，这些说明会列出在各个版本中所做的主要更改，帮助用户了解新功能、优化以及潜在的影响。法律信息部分，包括许可证信息，可在前言和法律声明中找到，这对于遵循版权法规和理解使用限制至关重要。
手册还推荐用户在遇到问题时寻求帮助，鼓励他们参与MySQL论坛或邮件列表，与其他用户交流，共同解决问题。文档最后更新日期为2019年3月8日，表明它是一个持续更新的资源，反映了最新的MySQL 8.0状态。
MySQL 8.0 Reference Manual是MySQL 8.0版本管理和开发人员不可或缺的工具，它提供了一站式的指南，涵盖了从核心功能、许可、版本差异到社区支持等全方位的信息。无论是初次接触MySQL的新手，还是经验丰富的开发者，都需要利用这份文档来提升技能和优化数据库管理。
MySQL 8.0 Reference Manual
xvi
15.15.1 Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance
Schema .................................................................................................................. 2743
15.15.2 Monitoring InnoDB Mutex Waits Using Performance Schema ........................ 2745
15.16 InnoDB Monitors .................................................................................................... 2749
15.16.1 InnoDB Monitor Types ................................................................................ 2749
15.16.2 Enabling InnoDB Monitors ........................................................................... 2749
15.16.3 InnoDB Standard Monitor and Lock Monitor Output ...................................... 2751
15.17 InnoDB Backup and Recovery ................................................................................ 2755
15.17.1 InnoDB Backup ........................................................................................... 2755
15.17.2 InnoDB Recovery ........................................................................................ 2756
15.18 InnoDB and MySQL Replication ............................................................................. 2759
15.19 InnoDB memcached Plugin .................................................................................... 2761
15.19.1 Benefits of the InnoDB memcached Plugin ................................................... 2762
15.19.2 InnoDB memcached Architecture ................................................................. 2763
15.19.3 Setting Up the InnoDB memcached Plugin ................................................... 2766
15.19.4 InnoDB memcached Multiple get and Range Query Support .......................... 2772
15.19.5 Security Considerations for the InnoDB memcached Plugin ........................... 2774
15.19.6 Writing Applications for the InnoDB memcached Plugin ................................. 2776
15.19.7 The InnoDB memcached Plugin and Replication ........................................... 2788
15.19.8 InnoDB memcached Plugin Internals ............................................................ 2792
15.19.9 Troubleshooting the InnoDB memcached Plugin ........................................... 2796
15.20 InnoDB Troubleshooting ......................................................................................... 2798
15.20.1 Troubleshooting InnoDB I/O Problems ......................................................... 2798
15.20.2 Forcing InnoDB Recovery ........................................................................... 2799
15.20.3 Troubleshooting InnoDB Data Dictionary Operations ..................................... 2800
15.20.4 InnoDB Error Handling ................................................................................ 2802
16 Alternative Storage Engines ................................................................................................ 2803
16.1 Setting the Storage Engine ...................................................................................... 2806
16.2 The MyISAM Storage Engine ................................................................................... 2807
16.2.1 MyISAM Startup Options ............................................................................... 2810
16.2.2 Space Needed for Keys ................................................................................ 2812
16.2.3 MyISAM Table Storage Formats .................................................................... 2812
16.2.4 MyISAM Table Problems ............................................................................... 2815
16.3 The MEMORY Storage Engine ................................................................................ 2816
16.4 The CSV Storage Engine ........................................................................................ 2821
16.4.1 Repairing and Checking CSV Tables ............................................................. 2821
16.4.2 CSV Limitations ............................................................................................ 2822
16.5 The ARCHIVE Storage Engine ................................................................................. 2822
16.6 The BLACKHOLE Storage Engine ........................................................................... 2824
16.7 The MERGE Storage Engine ................................................................................... 2826
16.7.1 MERGE Table Advantages and Disadvantages .............................................. 2829
16.7.2 MERGE Table Problems ............................................................................... 2829
16.8 The FEDERATED Storage Engine ........................................................................... 2831
16.8.1 FEDERATED Storage Engine Overview ......................................................... 2831
16.8.2 How to Create FEDERATED Tables .............................................................. 2832
16.8.3 FEDERATED Storage Engine Notes and Tips ................................................ 2835
16.8.4 FEDERATED Storage Engine Resources ....................................................... 2836
16.9 The EXAMPLE Storage Engine ................................................................................ 2836
16.10 Other Storage Engines .......................................................................................... 2837
16.11 Overview of MySQL Storage Engine Architecture .................................................... 2837
16.11.1 Pluggable Storage Engine Architecture ........................................................ 2838
16.11.2 The Common Database Server Layer .......................................................... 2838
17 Replication ......................................................................................................................... 2841
17.1 Configuring Replication ............................................................................................ 2842
17.1.1 Binary Log File Position Based Replication Configuration Overview ................. 2843
17.1.2 Setting Up Binary Log File Position Based Replication .................................... 2843
17.1.3 Replication with Global Transaction Identifiers ................................................ 2853
17.1.4 MySQL Multi-Source Replication ................................................................... 2872
剩余6027页未读，继续阅读
2022-12-31 上传
240 浏览量
196 浏览量
130 浏览量
点击了解资源详情
645 浏览量
2025-01-01 上传
2025-01-01 上传
2025-01-01 上传
