没有合适的资源?快使用搜索试试~ 我知道了~
首页MySQL 5.6英文参考手册:功能详解与安装指南
MySQL 5.6英文参考手册:功能详解与安装指南
5星 · 超过95%的资源 需积分: 11 420 下载量 46 浏览量
更新于2024-07-26
1
收藏 34.27MB PDF 举报
MySQL 5.6英文参考手册是一份详尽的官方文档,涵盖了MySQL 5.6版本(包括5.6.11)的详细信息。该手册特别强调了MySQL 5.6的功能特性,这些功能并非所有版本都包含,用户应参照其许可证协议或联系Oracle销售代表了解所使用的版本具体特性。它旨在帮助管理员、企业开发者以及那些关注数据库管理和功能实现的专业人士。
文档的核心内容包括:
1. **MySQL 5.6特性和概述**:介绍了MySQL 5.6的新功能和改进,可能涉及性能提升、安全性增强、新特性如函数和运算符的更新等,用户可以通过Chapter 12 "Functions and Operators" 查阅完整的函数一览表。
2. **管理员指南**:针对数据库管理员提供安装、升级、配置以及服务器管理的最佳实践,确保系统的高效运行和稳定。
3. **企业版与功能扩展**:文档详细讨论了MySQL Enterprise Edition,可能涵盖高级功能、故障切换(High Availability, HA)和可扩展性(Scalability)方面的内容,这对于寻求商业级解决方案的用户来说至关重要。
4. **开发人员工具**:介绍了用于连接MySQL的各类接口和API,如Connector/J,这些工具支持应用程序开发,使得数据交互更加便捷。
5. **教程与指南**:提供了关于如何使用MySQL Workbench进行数据建模、可视化操作以及HA/Scalability Guide,帮助用户深入了解和掌握复杂系统的部署和维护。
6. **法律信息与许可**:文档最后包含了法律声明和版权信息,确保用户在使用过程中遵守相关法规。
7. **文档生成日期**:此文档生成于2013年1月22日,修订至第33999版,表明文档是基于当时的最新状态。
这份手册对于深入理解MySQL 5.6的各个方面,无论是作为技术开发者、数据库管理员还是系统集成者,都是极其宝贵的参考资料。阅读并掌握其中的知识,能够帮助提升数据库管理技能,优化应用程序性能,并有效利用MySQL 5.6的各项功能特性。
MySQL 5.6 Reference Manual
xvi
20.3. Performance Schema Queries ................................................................................. 2182
20.4. Performance Schema Instrument Naming Conventions ............................................. 2182
20.5. Performance Schema Status Monitoring .................................................................. 2184
20.6. Performance Schema Atom and Molecule Events .................................................... 2187
20.7. Performance Schema Statement Digests ................................................................. 2188
20.8. Performance Schema General Table Characteristics ................................................ 2189
20.9. Performance Schema Table Descriptions ................................................................. 2189
20.9.1. Performance Schema Setup Tables .............................................................. 2190
20.9.2. Performance Schema Instance Tables .......................................................... 2194
20.9.3. Performance Schema Wait Event Tables ...................................................... 2198
20.9.4. Performance Schema Stage Event Tables .................................................... 2201
20.9.5. Performance Schema Statement Event Tables .............................................. 2203
20.9.6. Performance Schema Connection Tables ...................................................... 2207
20.9.7. Performance Schema Connection Attribute Tables ......................................... 2209
20.9.8. Performance Schema Summary Tables ........................................................ 2209
20.9.9. Performance Schema Miscellaneous Tables .................................................. 2222
20.10. Performance Schema Command Options ............................................................... 2228
20.11. Performance Schema System Variables ................................................................. 2228
20.12. Performance Schema Status Variables .................................................................. 2242
20.13. Performance Schema and Plugins ......................................................................... 2243
20.14. Using the Performance Schema to Diagnose Problems ........................................... 2243
21. Connectors and APIs ......................................................................................................... 2245
21.1. MySQL Connector/ODBC ........................................................................................ 2249
21.1.1. Connector/ODBC Versions ........................................................................... 2250
21.1.2. Connector/ODBC Introduction ....................................................................... 2251
21.1.3. Connector/ODBC Installation ........................................................................ 2254
21.1.4. Configuring Connector/ODBC ....................................................................... 2264
21.1.5. Connector/ODBC Examples .......................................................................... 2284
21.1.6. Connector/ODBC Reference ......................................................................... 2310
21.1.7. Connector/ODBC Notes and Tips ................................................................. 2316
21.1.8. Connector/ODBC Support ............................................................................ 2326
21.2. MySQL Connector/Net ............................................................................................ 2327
21.2.1. Connector/Net Versions ................................................................................ 2328
21.2.2. Installing Connector/Net ............................................................................... 2330
21.2.3. Connector/Net Visual Studio Integration ........................................................ 2338
21.2.4. Connector/Net Tutorials ................................................................................ 2368
21.2.5. Connector/Net Programming ......................................................................... 2408
21.2.6. Connector/Net Connection String Options Reference ..................................... 2447
21.2.7. Connector/Net API Reference ....................................................................... 2454
21.2.8. Connector/Net Support ................................................................................. 2561
21.2.9. Connector/Net FAQ ...................................................................................... 2562
21.3. MySQL Connector/J ................................................................................................ 2563
21.3.1. Overview of MySQL Connector/J .................................................................. 2563
21.3.2. Connector/J Versions ................................................................................... 2564
21.3.3. Connector/J Installation ................................................................................ 2565
21.3.4. Connector/J Examples ................................................................................. 2570
21.3.5. Connector/J (JDBC) Reference ..................................................................... 2570
21.3.6. JDBC Concepts ........................................................................................... 2603
21.3.7. Connection Pooling with Connector/J ............................................................ 2611
21.3.8. Load Balancing with Connector/J .................................................................. 2615
21.3.9. Failover with Connector/J ............................................................................. 2617
21.3.10. Using the Connector/J Interceptor Classes .................................................. 2619
21.3.11. Using Connector/J with Tomcat .................................................................. 2619
21.3.12. Using Connector/J with JBoss .................................................................... 2621
21.3.13. Using Connector/J with Spring .................................................................... 2621
21.3.14. Using Connector/J with GlassFish ............................................................... 2626
21.3.15. Troubleshooting Connector/J Applications ................................................... 2631
21.3.16. Connector/J Support ................................................................................... 2639
MySQL 5.6 Reference Manual
xvii
21.4. MySQL Connector/C++ ........................................................................................... 2641
21.4.1. Installing the MySQL Connector/C++ Binary .................................................. 2643
21.4.2. Installing MySQL Connector/C++ from Source ............................................... 2645
21.4.3. MySQL Connector/C++ Building Windows Applications with Microsoft Visual
Studio ..................................................................................................................... 2650
21.4.4. MySQL Connector/C++ Building Linux Applications with NetBeans .................. 2658
21.4.5. MySQL Connector/C++ Getting Started: Usage Examples .............................. 2662
21.4.6. MySQL Connector/C++ Tutorials .................................................................. 2668
21.4.7. MySQL Connector/C++ Debug Tracing ......................................................... 2675
21.4.8. MySQL Connector/C++ Usage Notes ............................................................ 2676
21.4.9. MySQL Connector/C++ Known Bugs and Issues ........................................... 2680
21.4.10. MySQL Connector/C++ Feature requests .................................................... 2680
21.4.11. MySQL Connector/C++ Support .................................................................. 2681
21.5. MySQL Connector/C ............................................................................................... 2681
21.5.1. Building MySQL Connector/C from the Source Code ...................................... 2681
21.5.2. Testing MySQL Connector/C ........................................................................ 2684
21.5.3. MySQL Connector/C FAQ ............................................................................ 2684
21.6. MySQL Connector/Python ....................................................................................... 2685
21.6.1. Guidelines for Python Developers ................................................................. 2685
21.6.2. Connector/Python Versions .......................................................................... 2687
21.6.3. Connector/Python Installation ....................................................................... 2687
21.6.4. Connector/Python Coding Examples ............................................................. 2689
21.6.5. Connector/Python Tutorials ........................................................................... 2694
21.6.6. Connector/Python Connection Arguments ..................................................... 2695
21.6.7. Connector/Python API Reference .................................................................. 2697
21.6.8. Connector/Python FAQ ................................................................................. 2715
21.7. libmysqld, the Embedded MySQL Server Library ...................................................... 2715
21.7.1. Compiling Programs with libmysqld ........................................................... 2715
21.7.2. Restrictions When Using the Embedded MySQL Server ................................. 2716
21.7.3. Options with the Embedded Server ............................................................... 2716
21.7.4. Embedded Server Examples ........................................................................ 2717
21.8. MySQL C API ......................................................................................................... 2720
21.8.1. C API Data Structures .................................................................................. 2721
21.8.2. C API Function Overview ............................................................................. 2726
21.8.3. C API Function Descriptions ......................................................................... 2730
21.8.4. C API Prepared Statements ......................................................................... 2780
21.8.5. C API Prepared Statement Data Structures ................................................... 2781
21.8.6. C API Prepared Statement Function Overview ............................................... 2787
21.8.7. C API Prepared Statement Function Descriptions .......................................... 2790
21.8.8. C API Threaded Function Descriptions .......................................................... 2812
21.8.9. C API Embedded Server Function Descriptions ............................................. 2814
21.8.10. C API Client Plugin Functions ..................................................................... 2814
21.8.11. Common Questions and Problems When Using the C API ............................ 2817
21.8.12. Controlling Automatic Reconnection Behavior .............................................. 2819
21.8.13. C API Support for Multiple Statement Execution .......................................... 2820
21.8.14. C API Prepared Statement Problems .......................................................... 2822
21.8.15. C API Prepared Statement Handling of Date and Time Values ...................... 2822
21.8.16. C API Support for Prepared CALL Statements ............................................. 2824
21.8.17. Building Client Programs ............................................................................ 2827
21.9. MySQL PHP API .................................................................................................... 2830
21.9.1. Overview of the MySQL PHP drivers ............................................................ 2831
21.9.2. Original MySQL API (Mysql) ........................................................................ 2837
21.9.3. MySQL Improved Extension (Mysqli) .......................................................... 2907
21.9.4. MySQL Functions (PDO_MYSQL) (MySQL (PDO)) ....................................... 3121
21.9.5. MySQL Native Driver (Mysqlnd) .................................................................. 3125
21.9.6. Mysqlnd replication and load balancing plugin (mysqlnd_ms) ......................... 3157
21.9.7. Mysqlnd query result cache plugin (mysqlnd_qc) ......................................... 3249
21.9.8. Mysqlnd user handler plugin (mysqlnd_uh) .................................................. 3300
MySQL 5.6 Reference Manual
xviii
21.9.9. Mysqlnd connection multiplexing plugin (mysqlnd_mux) ................................ 3383
21.9.10. Mysqlnd Memache plugin (mysqlnd_memcache) ........................................ 3387
21.9.11. Connector/PHP .......................................................................................... 3396
21.9.12. Common Problems with MySQL and PHP ................................................... 3396
21.9.13. Enabling Both mysql and mysqli in PHP .................................................. 3396
21.10. MySQL Perl API ................................................................................................... 3397
21.11. MySQL Python API ............................................................................................... 3398
21.12. MySQL Ruby APIs ................................................................................................ 3398
21.12.1. The MySQL/Ruby API ................................................................................ 3398
21.12.2. The Ruby/MySQL API ................................................................................ 3398
21.13. MySQL Tcl API ..................................................................................................... 3398
21.14. MySQL Eiffel Wrapper .......................................................................................... 3398
22. Extending MySQL .............................................................................................................. 3399
22.1. MySQL Internals ..................................................................................................... 3399
22.1.1. MySQL Threads ........................................................................................... 3399
22.1.2. The MySQL Test Suite ................................................................................. 3400
22.2. The MySQL Plugin API ........................................................................................... 3401
22.2.1. Plugin API Characteristics ............................................................................ 3401
22.2.2. Plugin API Components ............................................................................... 3402
22.2.3. Types of Plugins .......................................................................................... 3403
22.2.4. Writing Plugins ............................................................................................. 3406
22.2.5. MySQL Services for Plugins ......................................................................... 3446
22.3. Adding New Functions to MySQL ............................................................................ 3447
22.3.1. Features of the User-Defined Function Interface ............................................ 3448
22.3.2. Adding a New User-Defined Function ........................................................... 3448
22.3.3. Adding a New Native Function ..................................................................... 3457
22.4. Debugging and Porting MySQL ............................................................................... 3459
22.4.1. Debugging a MySQL Server ......................................................................... 3459
22.4.2. Debugging a MySQL Client .......................................................................... 3465
22.4.3. The DBUG Package .................................................................................... 3466
23. MySQL Enterprise Edition .................................................................................................. 3469
23.1. MySQL Enterprise Monitor ...................................................................................... 3469
23.2. MySQL Enterprise Backup ...................................................................................... 3470
23.3. MySQL Enterprise Security ..................................................................................... 3470
23.4. MySQL Enterprise Audit .......................................................................................... 3471
23.5. MySQL Thread Pool ............................................................................................... 3471
24. MySQL Workbench ............................................................................................................ 3473
25. MySQL for Excel ............................................................................................................... 3475
25.1. Installing and Configuring ........................................................................................ 3475
25.2. Edit MySQL Data .................................................................................................... 3476
25.3. Import MySQL Data ................................................................................................ 3477
25.4. Append MySQL Data .............................................................................................. 3478
25.5. Export MySQL Data ................................................................................................ 3481
A. Licenses for Third-Party Components .................................................................................. 3485
A.1. Ant-Contrib License .................................................................................................. 3488
A.2. ANTLR 3.3 License .................................................................................................. 3488
A.3. Boost Library License ............................................................................................... 3489
A.4. c3p0 JDBC Library License ...................................................................................... 3489
A.5. dtoa.c License ....................................................................................................... 3490
A.6. Editline Library (libedit) License ........................................................................... 3490
A.7. Facebook Fast Checksum Patch License .................................................................. 3493
A.8. Facebook Patches License ....................................................................................... 3494
A.9. FindGTest.cmake License ..................................................................................... 3494
A.10. Fred Fish's Dbug Library License ............................................................................ 3495
A.11. getarg License ..................................................................................................... 3496
A.12. GLib License (for MySQL Proxy) ............................................................................. 3496
A.13. GNU General Public License Version 2.0, June 1991 ............................................... 3497
MySQL 5.6 Reference Manual
xix
A.14. GNU General Public License Version 3.0, 29 June 2007 and GCC Runtime Library
Exception Version 3.1, 31 March 2009 ............................................................................. 3502
A.15. GNU Lesser General Public License Version 2.1, February 1999 .............................. 3513
A.16. GNU Libtool License .............................................................................................. 3520
A.17. GNU Readline License ........................................................................................... 3521
A.18. GNU Standard C++ Library (libstdc++) License ........................................................ 3521
A.19. Google Controlling Master Thread I/O Rate Patch License ........................................ 3522
A.20. Google Perftools (TCMalloc utility) License .............................................................. 3523
A.21. Google SMP Patch License .................................................................................... 3523
A.22. jboss-common-jdbc-wrapper.jar License .................................................................. 3524
A.23. lib_sql.cc License ............................................................................................. 3524
A.24. Libaio License ........................................................................................................ 3524
A.25. libevent License ................................................................................................. 3525
A.26. Libiconv License ..................................................................................................... 3526
A.27. libintl License ................................................................................................... 3527
A.28. Linux-PAM License ................................................................................................. 3527
A.29. LPeg Library License ............................................................................................. 3528
A.30. Lua (liblua) License ................................................................................................ 3528
A.31. LuaFileSystem Library License ............................................................................ 3529
A.32. md5 (Message-Digest Algorithm 5) License ............................................................. 3529
A.33. memcached License ............................................................................................... 3529
A.34. mkpasswd.pl License ........................................................................................... 3530
A.35. nt_servc (Windows NT Service class library) License ............................................... 3533
A.36. OpenPAM License .................................................................................................. 3534
A.37. OpenSSL v1.0 License ........................................................................................... 3534
A.38. PCRE License ........................................................................................................ 3536
A.39. Percona Multiple I/O Threads Patch License ............................................................ 3537
A.40. Red HAT RPM Spec File License ........................................................................... 3537
A.41. RegEX-Spencer Library License .............................................................................. 3538
A.42. RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License ........................................ 3538
A.43. Richard A. O'Keefe String Library License ............................................................... 3538
A.44. SHA-1 in C License ................................................................................................ 3539
A.45. Simple Logging Facade for Java (SLF4J) License .................................................... 3539
A.46. Unicode Data Files ................................................................................................. 3539
A.47. zlib License ......................................................................................................... 3540
A.48. ZLIB.NET License .................................................................................................. 3540
B. MySQL 5.6 Frequently Asked Questions .............................................................................. 3543
B.1. MySQL 5.6 FAQ: General ........................................................................................ 3543
B.2. MySQL 5.6 FAQ: Storage Engines ............................................................................ 3545
B.3. MySQL 5.6 FAQ: Server SQL Mode ......................................................................... 3546
B.4. MySQL 5.6 FAQ: Stored Procedures and Functions ................................................... 3547
B.5. MySQL 5.6 FAQ: Triggers ........................................................................................ 3551
B.6. MySQL 5.6 FAQ: Views ........................................................................................... 3553
B.7. MySQL 5.6 FAQ: INFORMATION_SCHEMA ................................................................. 3554
B.8. MySQL 5.6 FAQ: Migration ....................................................................................... 3555
B.9. MySQL 5.6 FAQ: Security ........................................................................................ 3555
B.10. MySQL 5.6 FAQ: MySQL Cluster ............................................................................ 3556
B.11. MySQL 5.6 FAQ: MySQL Chinese, Japanese, and Korean Character Sets ................ 3557
B.12. MySQL 5.6 FAQ: Connectors & APIs ...................................................................... 3568
B.13. MySQL 5.6 FAQ: Replication .................................................................................. 3569
C. Errors, Error Codes, and Common Problems ....................................................................... 3573
C.1. Sources of Error Information ..................................................................................... 3573
C.2. Types of Error Values .............................................................................................. 3573
C.3. Server Error Codes and Messages ........................................................................... 3574
C.4. Client Error Codes and Messages ............................................................................ 3631
C.5. Problems and Common Errors .................................................................................. 3635
C.5.1. How to Determine What Is Causing a Problem ............................................... 3635
C.5.2. Common Errors When Using MySQL Programs .............................................. 3637
MySQL 5.6 Reference Manual
xx
C.5.3. Installation-Related Issues ............................................................................. 3649
C.5.4. Administration-Related Issues ........................................................................ 3650
C.5.5. Query-Related Issues .................................................................................... 3656
C.5.6. Optimizer-Related Issues ............................................................................... 3663
C.5.7. Table Definition-Related Issues ...................................................................... 3664
C.5.8. Known Issues in MySQL ............................................................................... 3665
D. MySQL Release Notes ........................................................................................................ 3669
D.1. Changes in MySQL 5.6 (Development) ..................................................................... 3669
D.2. MySQL Connector/ODBC Change History ................................................................. 3669
D.3. MySQL Connector/Net Change History ..................................................................... 3669
D.4. MySQL Visual Studio Plugin Change History ............................................................. 3670
D.5. MySQL Connector/J Change History ......................................................................... 3670
D.6. MySQL Connector/C++ Change History .................................................................... 3670
D.7. MySQL Proxy Change History .................................................................................. 3670
D.8. MySQL for Excel Change History ............................................................................. 3670
D.9. MySQL Installer Change History ............................................................................... 3670
E. Restrictions and Limits ........................................................................................................ 3671
E.1. Restrictions on Stored Programs ............................................................................... 3671
E.2. Restrictions on Condition Handling ............................................................................ 3674
E.3. Restrictions on Server-Side Cursors .......................................................................... 3674
E.4. Restrictions on Subqueries ....................................................................................... 3675
E.5. Restrictions on Views ............................................................................................... 3677
E.6. Restrictions on XA Transactions ............................................................................... 3678
E.7. Restrictions on Character Sets .................................................................................. 3679
E.8. Restrictions on Performance Schema ........................................................................ 3679
E.9. Restrictions on Pluggable Authentication ................................................................... 3680
E.10. Limits in MySQL ..................................................................................................... 3681
E.10.1. Limits of Joins ............................................................................................. 3681
E.10.2. Limits on Number of Databases and Tables .................................................. 3681
E.10.3. Limits on Table Size .................................................................................... 3682
E.10.4. Table Column-Count and Row-Size Limits .................................................... 3683
E.10.5. Windows Platform Limitations ....................................................................... 3685
F. MySQL Glossary ................................................................................................................. 3687
General Index ......................................................................................................................... 3785
C Function Index ..................................................................................................................... 3857
Command Index ...................................................................................................................... 3867
Function Index ........................................................................................................................ 3887
INFORMATION_SCHEMA Index ................................................................................................. 3905
Join Types Index ..................................................................................................................... 3909
Operator Index ........................................................................................................................ 3911
Option Index ........................................................................................................................... 3917
Privileges Index ....................................................................................................................... 3961
SQL Modes Index ................................................................................................................... 3967
Statement/Syntax Index ........................................................................................................... 3969
System Variable Index ............................................................................................................. 4011
Status Variable Index .............................................................................................................. 4037
Transaction Isolation Level Index ............................................................................................. 4045
剩余4067页未读,继续阅读
159 浏览量
296 浏览量
112 浏览量
144 浏览量
254 浏览量
125 浏览量
点击了解资源详情
oiwuliang
- 粉丝: 0
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Oracle10g数据库多用户控制与事务管理
- C++Builder6编程实例详解:实战提升与技术深度
- Oracle10g数据库体系结构与内存结构解析
- JAVA笔试必备:面向对象特征与编程基础
- 深入理解ActionScript 3.0动画基础与实战指南
- C#入门指南:实践方法
- 谭浩强C语言教材习题解答:主函数与基本数据类型转换
- 需求分析详解:撰写V1.0需求说明书关键要素
- JSP高级编程实战指南:J2EE、XML与JDBC技术详解
- Shell Script入门教程:基础操作与变量
- 全面理解软件测试各阶段工作流程图详解
- 21世纪信息安全基石:《应用密码学手册》详解
- 银行家算法详解:C++实现与操作系统应用
- 2小时快速掌握企业版iptables v1.5.4:从入门到实战
- Java与XML第二版:技术革新与应用深度指南
- 河海大学计算机系概要设计说明书详解:结构与关键模块
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功