mysql5.7官方参考文档资源-CSDN文库

共244个文件

png：195个

html：46个

jpg：2个

5星 · 超过95%的资源需积分: 17 196 浏览量 2013-08-22 12:43:26 上传评论 2 收藏 10.51MB ZIP 举报

MySQL 5.7官方参考文档是数据库管理员、开发人员和系统架构师的重要资源，它详尽地涵盖了MySQL 5.7版本的所有特性和功能。MySQL是一个广泛使用的开源关系型数据库管理系统（RDBMS），以其高性能、高可用性、易于安装和使用而闻名。在MySQL 5.7中，有一些关键知识点值得深入理解： 1. **InnoDB存储引擎**：MySQL 5.7默认的存储引擎是InnoDB，它支持事务处理、行级锁定和外键约束，确保了数据的一致性和完整性。在5.7版本中，InnoDB在性能和并发性方面有显著提升，如更快的插入速度和更高效的缓冲池管理。 2. **性能优化**：5.7版本引入了诸多性能改进，包括优化查询执行计划、提高索引效率、增加并行复制等。其中，Query Cache的改进使查询缓存更加智能，能够更好地适应不同的工作负载。 3. **JSON支持**：MySQL 5.7开始支持内置的JSON数据类型，允许存储和检索JSON格式的数据，这对于处理半结构化数据非常有用。同时，提供了丰富的函数来操作JSON字段，如`JSON_EXTRACT`、`JSON_INSERT`等。 4. **窗口函数**：5.7版本引入了窗口函数，使得在分组或排序数据时可以进行复杂的计算，如计算排名、移动平均等，无需使用子查询或自连接。 5. **分区表**：MySQL 5.7对分区表的管理进行了增强，支持更多的分区类型和更灵活的分区策略，这有助于大数据管理和查询性能的提升。 6. **安全增强**：MySQL 5.7增强了安全性，如支持密码验证插件、改进的权限管理系统以及更严格的默认安全设置。此外，还有用于审计的日志功能，帮助监控数据库活动。 7. **复制改进**：5.7中的复制功能得到升级，支持多线程复制，可以加快主从同步速度，提高了高可用性和灾难恢复能力。 8. **GROUP BY和ORDER BY优化**：优化了处理大量数据时的GROUP BY和ORDER BY操作，通过使用临时表和内存优化，减少了磁盘I/O。 9. **存储过程和触发器**：5.7版本提供了更强大的存储过程和触发器功能，允许开发者编写复杂的业务逻辑，提高应用的可维护性和复用性。 10. **性能分析工具**：MySQL 5.7引入了新的性能分析工具，如Performance Schema，可以帮助诊断和优化数据库性能。 MySQL 5.7官方参考文档包含了这些及更多高级特性，是学习和掌握MySQL 5.7的必备资料。通过深入学习和实践，你可以充分利用这些功能来设计、部署和维护高效稳定的数据库系统。阅读`refman-5.7-en.html-chapter`这个文件将为你提供更详细的信息和具体的操作指南。

资源推荐

资源详情

资源评论

收起资源包目录

mysql 5.7 官方参考文档（244个子文件）

mvl.css 26KB

connectors-apis.html 5.13MB

server-administration.html 2.19MB

sql-syntax.html 1.71MB

storage-engines.html 1.4MB

programs.html 1.27MB

functions.html 1.06MB

ix01.html 996KB

replication.html 972KB

optimization.html 934KB

installing.html 658KB

error-handling.html 636KB

dynindex-statement.html 624KB

performance-schema.html 601KB

security.html 577KB

dynindex-option.html 554KB

ha-overview.html 491KB

glossary.html 425KB

globalization.html 425KB

extending-mysql.html 399KB

partitioning.html 351KB

information-schema.html 327KB

dynindex-sysvar.html 322KB

data-types.html 320KB

dynindex-command.html 260KB

introduction.html 257KB

licenses-third-party.html 216KB

dynindex-function.html 214KB

faqs.html 178KB

stored-programs-views.html 175KB

backup-and-recovery.html 167KB

tutorial.html 159KB

language-structure.html 155KB

index.html 152KB

dynindex-cfunction.html 134KB

restrictions.html 108KB

dynindex-statvar.html 81KB

dynindex-priv.html 70KB

dynindex-operator.html 55KB

dynindex-is.html 45KB

mysql-for-excel.html 30KB

dynindex-sqlmode.html 28KB

mysql-enterprise.html 17KB

dynindex-jointype.html 16KB

dynindex-isolevel.html 13KB

preface.html 11KB

workbench.html 5KB

wfc-architecture.jpg 61KB

innodb_memcached2.jpg 38KB

excel-plugin-import-data.png 275KB

excel-plugin-import-data-procedure.png 221KB

mi-choose-setup-type-win.png 148KB

install-osx-startup-3.png 147KB

install-osx-pkg-4.png 138KB

lua-classes.png 131KB

install-osx-startup-5.png 130KB

install-osx-pkg-1.png 128KB

myaccess.png 125KB

install-osx-startup-1.png 122KB

connector-net-visual-studio-entity-framework-data-form-design.png 112KB

connector-cpp-netbeans.png 105KB

connector-net-ddl-properties.png 102KB

connector-net-visual-studio-entity-framework-save-enabled.png 101KB

drbd-main.png 98KB

mysql-for-excel-navigation-bar.png 95KB

gnupg-kleopatra-change-trust.png 89KB

replication-filtering-tbl-rules.png 88KB

connector-net-visual-studio-entity-framework-tutorial-linq-5.png 86KB

connector-net-visual-studio-table-properties-menu.png 85KB

connector-net-visual-studio-entity-framework-form-add-code.png 85KB

connector-net-visual-studio-selecting-table-properties.png 80KB

connector-net-visual-studio-views-sql-saved.png 75KB

ha-cost-vs-nines.png 73KB

gnupg-kleopatra-find-certificate.png 65KB

mysql-for-excel-append-data-automatic.png 65KB

cnet-win-install-step1.png 63KB

cnet-win-install-step5.png 62KB

gnupg-kleopatra-home.png 61KB

myodbc-macosx-odbcadmin-adddsn.png 58KB

install-osx-prefpane.png 57KB

connector-net-visual-studio-editing-new-table.png 55KB

myodbc-macosx-odbcadmin-main.png 53KB

mysql-for-excel-export.png 53KB

myodbc-macosx-odbcadmin-tracing.png 52KB

myodbc-win-install-step1.png 52KB

excel-plugin-edit-window.png 51KB

myodbc-win-install-step4.png 51KB

connector-net-sql-editor-query.png 49KB

connector-cpp-installer-welcome.png 49KB

mysql-for-excel-export-advanced.png 43KB

mysql-for-excel-append-data-advanced.png 42KB

scaleout.png 40KB

replication-filtering-db-rules.png 40KB

connector-net-visual-studio-entity-framework-add-entity-data-model.png 40KB

gnupg-kleopatra-decrypt-invalid-sig.png 39KB

connector-cpp-mysql-include-dir.png 37KB

proxy-architecture.png 37KB

myodbc-win-odbcadmin-options-5-1.png 37KB

connector-net-visual-studio-entity-framework-entity-data-model-diagram.png 36KB

connector-cpp-additional-library-dir.png 36KB

共 244 条

<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Chapter 21. Connectors and APIs</title> <link rel="stylesheet" href="mvl.css" type="text/css" /> <meta name="generator" content="DocBook XSL Stylesheets V1.69.1 + chunker.py v1.9.1" /> <link rel="start" href="index.html" title="{book-title}" /> <link rel="up" href="" title="" /> <link rel="prev" href="performance-schema.html" title="Chapter 20. MySQL Performance Schema" /> <link rel="next" href="extending-mysql.html" title="Chapter 22. Extending MySQL" /> <script language="javascript" type="text/javascript"> function addOnload(theFunc) { var previous = window.onload; if (typeof window.onload != 'function') { window.onload = theFunc; } else { window.onload = function() { previous(); theFunc(); } } } addOnload(function() { var base = new Date(1377046276+*1000); var now = new Date(); var diff = ((now-base)/1000)/(24*3600); if (diff > 90) { var nodes = document.getElementsByClassName('titlepage'); nodes[0].innerHTML = '' + 'This copy of the manual is more than 90 days old. We encourage you to download a ' + 'new version from <a href="http://dev.mysql.com">dev.mysql.com/doc</a>.' + nodes[0].innerHTML; } }); </script> <noscript></noscript> </head> <body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"> <div class="navheader"> <table width="100%" summary="Navigation header"> <tr> <th colspan="3" align="center">Chapter 21. Connectors and APIs</th> </tr> <tr> <td width="20%" align="left"><a accesskey="p" href="performance-schema.html">Prev</a> </td> <th width="60%" align="center"></th> <td width="20%" align="right"> <a accesskey="n" href="extending-mysql.html">Next</a></td> </tr> </table> <hr> </div> <div class="chapter"> <div class="titlepage"> <div> <div> <h1 class="title"><a name="connectors-apis"></a>Chapter 21. Connectors and APIs</h1> </div> </div> </div> <div class="toc"> Table of Contents<dl><dt><a href="connectors-apis.html#connector-odbc">21.1. MySQL Connector/ODBC</a></dt><dd><dl><dt><a href="connectors-apis.html#connector-odbc-versions">21.1.1. Connector/ODBC Versions</a></dt><dt><a href="connectors-apis.html#connector-odbc-introduction">21.1.2. Connector/ODBC Introduction</a></dt><dt><a href="connectors-apis.html#connector-odbc-installation">21.1.3. Connector/ODBC Installation</a></dt><dt><a href="connectors-apis.html#connector-odbc-configuration">21.1.4. Configuring Connector/ODBC</a></dt><dt><a href="connectors-apis.html#connector-odbc-examples">21.1.5. Connector/ODBC Examples</a></dt><dt><a href="connectors-apis.html#connector-odbc-reference">21.1.6. Connector/ODBC Reference</a></dt><dt><a href="connectors-apis.html#connector-odbc-usagenotes">21.1.7. Connector/ODBC Notes and Tips</a></dt><dt><a href="connectors-apis.html#connector-odbc-support">21.1.8. Connector/ODBC Support</a></dt></dl></dd><dt><a href="connectors-apis.html#connector-net">21.2. MySQL Connector/Net</a></dt><dd><dl><dt><a href="connectors-apis.html#connector-net-versions">21.2.1. Connector/Net Versions</a></dt><dt><a href="connectors-apis.html#connector-net-installation">21.2.2. Connector/Net Installation</a></dt><dt><a href="connectors-apis.html#connector-net-visual-studio">21.2.3. Connector/Net Visual Studio Integration</a></dt><dt><a href="connectors-apis.html#connector-net-tutorials">21.2.4. Connector/Net Tutorials</a></dt><dt><a href="connectors-apis.html#connector-net-programming">21.2.5. Connector/Net Programming</a></dt><dt><a href="connectors-apis.html#connector-net-connection-options">21.2.6. Connector/Net Connection String Options Reference</a></dt><dt><a href="connectors-apis.html#connector-net-rt">21.2.7. Connector/Net Support for Windows Store</a></dt><dt><a href="connectors-apis.html#connector-net-entityframework50">21.2.8. EF 5 Support</a></dt><dt><a href="connectors-apis.html#connector-net-ref">21.2.9. Connector/Net API Reference</a></dt><dt><a href="connectors-apis.html#connector-net-support">21.2.10. Connector/Net Support</a></dt><dt><a href="connectors-apis.html#connector-net-faq">21.2.11. Connector/Net FAQ</a></dt></dl></dd><dt><a href="connectors-apis.html#connector-j">21.3. MySQL Connector/J</a></dt><dd><dl><dt><a href="connectors-apis.html#connector-j-overview">21.3.1. Overview of MySQL Connector/J</a></dt><dt><a href="connectors-apis.html#connector-j-versions">21.3.2. Connector/J Versions</a></dt><dt><a href="connectors-apis.html#connector-j-installing">21.3.3. Connector/J Installation</a></dt><dt><a href="connectors-apis.html#connector-j-examples">21.3.4. Connector/J Examples</a></dt><dt><a href="connectors-apis.html#connector-j-reference">21.3.5. Connector/J (JDBC) Reference</a></dt><dt><a href="connectors-apis.html#connector-j-usagenotes-basic">21.3.6. JDBC Concepts</a></dt><dt><a href="connectors-apis.html#connector-j-usagenotes-j2ee-concepts-connection-pooling">21.3.7. Connection Pooling with Connector/J</a></dt><dt><a href="connectors-apis.html#connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections">21.3.8. Load Balancing with Connector/J</a></dt><dt><a href="connectors-apis.html#connector-j-usagenotes-j2ee-concepts-load-balancing-failover">21.3.9. Failover with Connector/J</a></dt><dt><a href="connectors-apis.html#connector-j-interceptors">21.3.10. Using the Connector/J Interceptor Classes</a></dt><dt><a href="connectors-apis.html#connector-j-usagenotes-tomcat">21.3.11. Using Connector/J with Tomcat</a></dt><dt><a href="connectors-apis.html#connector-j-usagenotes-jboss">21.3.12. Using Connector/J with JBoss</a></dt><dt><a href="connectors-apis.html#connector-j-usagenotes-spring-config">21.3.13. Using Connector/J with Spring</a></dt><dt><a href="connectors-apis.html#connector-j-usagenotes-glassfish-config">21.3.14. Using Connector/J with GlassFish</a></dt><dt><a href="connectors-apis.html#connector-j-usagenotes-troubleshooting">21.3.15. Troubleshooting Connector/J Applications</a></dt><dt><a href="connectors-apis.html#connector-j-usagenotes-known-issues-limitations">21.3.16. Known Issues and Limitations</a></dt><dt><a href="connectors-apis.html#connector-j-support">21.3.17. Connector/J Support</a></dt></dl></dd><dt><a href="connectors-apis.html#connector-cpp">21.4. MySQL Connector/C++</a></dt><dd><dl><dt><a href="connectors-apis.html#connector-cpp-downloading">21.4.1. How to Get MySQL Connector/C++</a></dt><dt><span class="se

评论收藏

内容反馈