"MySQL 8.0参考手册及NDB Cluster 8.0详解"
需积分: 11 61 浏览量
更新于2024-01-17
收藏 42.38MB PDF 举报
MySQL是一个流行的开源关系型数据库管理系统，广泛用于各种Web应用程序的后端数据存储。MySQL 8.0参考手册是官方提供的详尽文档，介绍了MySQL 8.0版本的各种功能与用法。本手册还包括MySQL NDB Cluster 8.0的相关内容。
MySQL 8.0参考手册主要分为几个部分。第一部分是摘要，简要介绍了手册的内容和版本信息。在这里，我们了解到本手册覆盖了MySQL 8.0的所有发布版本，并包括了NDB Cluster的相关版本。此外，手册中还可能包含尚未发布的MySQL版本的文档。要了解已发布的版本信息，可以查看MySQL 8.0发布说明。
接下来，手册详细介绍了MySQL 8.0的各种功能。其中一些功能并不是每个版本都包含的，所以这个手册非常有用，可以帮助用户了解各个版本的差异和新增功能。无论您是初学者还是有经验的开发人员，都可以从这个手册中找到适合自己的文档。
MySQL 8.0参考手册遵循了清晰的结构和组织原则。每个功能都有专门的章节，其中包含详细的描述、示例和用法说明。手册中还提供了丰富的图表和表格，方便读者理解和记忆各种复杂的概念和语法。
此外，MySQL 8.0参考手册还包括了一些高级主题，如存储引擎、性能优化、备份和恢复、安全性等。这些主题涵盖了MySQL数据库管理的关键方面，对于需要深入了解MySQL的用户来说，是非常有价值的参考资料。
手册的最后一部分是附录，提供了一些附加信息和参考资料。例如，手册提供了MySQL函数和操作符的完整列表，以及一些常见问题的解答。这些附录可以帮助用户更好地理解和使用MySQL。
总之，MySQL 8.0参考手册是MySQL官方提供的权威文档，对于学习和使用MySQL 8.0的开发人员来说，是必不可少的参考资料。手册通过清晰的结构和有用的示例，帮助用户了解和掌握MySQL的各种功能和用法。无论您是初学者还是专业人士，MySQL 8.0参考手册都将成为您学习和使用MySQL的好帮手。
MySQL 8.0 Reference Manual
15.9 InnoDB Table and Page Compression ...................................................................... 3081
15.9.1 InnoDB Table Compression ........................................................................... 3081
15.9.2 InnoDB Page Compression ........................................................................... 3095
15.10 InnoDB Row Formats ............................................................................................ 3098
15.11 InnoDB Disk I/O and File Space Management ........................................................ 3104
15.11.1 InnoDB Disk I/O .......................................................................................... 3105
15.11.2 File Space Management ............................................................................. 3105
15.11.3 InnoDB Checkpoints ................................................................................... 3107
15.11.4 Defragmenting a Table ................................................................................ 3107
15.11.5 Reclaiming Disk Space with TRUNCATE TABLE .......................................... 3108
15.12 InnoDB and Online DDL ........................................................................................ 3108
15.12.1 Online DDL Operations ............................................................................... 3109
15.12.2 Online DDL Performance and Concurrency .................................................. 3123
15.12.3 Online DDL Space Requirements ................................................................ 3126
15.12.4 Online DDL Memory Management ............................................................... 3127
15.12.5 Configuring Parallel Threads for Online DDL Operations ............................... 3127
15.12.6 Simplifying DDL Statements with Online DDL ............................................... 3127
15.12.7 Online DDL Failure Conditions .................................................................... 3128
15.12.8 Online DDL Limitations ................................................................................ 3128
15.13 InnoDB Data-at-Rest Encryption ............................................................................. 3129
15.14 InnoDB Startup Options and System Variables ........................................................ 3138
15.15 InnoDB INFORMATION_SCHEMA Tables .............................................................. 3225
15.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression ...................... 3226
15.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information ........ 3227
15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables ............................ 3235
15.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables ......................... 3240
15.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables .................................. 3243
15.15.6 InnoDB INFORMATION_SCHEMA Metrics Table ......................................... 3247
15.15.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table .................... 3256
15.15.8 Retrieving InnoDB Tablespace Metadata from
INFORMATION_SCHEMA.FILES ............................................................................. 3257
15.16 InnoDB Integration with MySQL Performance Schema ............................................ 3258
15.16.1 Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance
Schema .................................................................................................................. 3260
15.16.2 Monitoring InnoDB Mutex Waits Using Performance Schema ........................ 3262
15.17 InnoDB Monitors .................................................................................................... 3265
15.17.1 InnoDB Monitor Types ................................................................................ 3265
15.17.2 Enabling InnoDB Monitors ........................................................................... 3266
15.17.3 InnoDB Standard Monitor and Lock Monitor Output ...................................... 3267
15.18 InnoDB Backup and Recovery ................................................................................ 3272
15.18.1 InnoDB Backup ........................................................................................... 3272
15.18.2 InnoDB Recovery ........................................................................................ 3273
15.19 InnoDB and MySQL Replication ............................................................................. 3275
15.20 InnoDB memcached Plugin .................................................................................... 3277
15.20.1 Benefits of the InnoDB memcached Plugin ................................................... 3278
15.20.2 InnoDB memcached Architecture ................................................................. 3279
15.20.3 Setting Up the InnoDB memcached Plugin ................................................... 3282
15.20.4 InnoDB memcached Multiple get and Range Query Support .......................... 3287
15.20.5 Security Considerations for the InnoDB memcached Plugin ........................... 3290
15.20.6 Writing Applications for the InnoDB memcached Plugin ................................. 3291
15.20.7 The InnoDB memcached Plugin and Replication ........................................... 3303
15.20.8 InnoDB memcached Plugin Internals ............................................................ 3307
15.20.9 Troubleshooting the InnoDB memcached Plugin ........................................... 3311
15.21 InnoDB Troubleshooting ......................................................................................... 3313
15.21.1 Troubleshooting InnoDB I/O Problems ......................................................... 3314
15.21.2 Troubleshooting Recovery Failures .............................................................. 3314
15.21.3 Forcing InnoDB Recovery ........................................................................... 3315
15.21.4 Troubleshooting InnoDB Data Dictionary Operations ..................................... 3316
xvi
剩余6073页未读，继续阅读
2022-09-26 上传
2022-04-05 上传
2024-06-17 上传
点击了解资源详情
2022-05-12 上传
2018-10-17 上传
点击了解资源详情
点击了解资源详情
Michael_chemic
- 粉丝: 1166
- 资源: 5
我的内容管理
展开
