《MySQL 57 Reference Manual用户手册_共3612页》pdf电子书免费下载
下载方式一：
百度网盘下载地址：https://pan.baidu.com/s/1DQQxhv3y8EGZTdtlnWGQ5w
百度网盘密码：1111
下载方式二：
http://ziliaoshare.cn/Download/ae_123546_pd_MySQL57ReferenceManualYHSC_G3612Y.zip
|
|
作者：empty 页数：3612 出版社：empty |
《MySQL 57 Reference Manual用户手册_共3612页》介绍
Abstract
This is the MySQL T Reference Manual.It documents MySQL 5.7 through 5.7.7.MySQL Cluster is currently not supported in MySQL 5.7.For information about MySQL Cluster， please see MySQLCluster NDB 7.3 and MySQL Cluster NDB 7.4.MySQL 5.7 features.This manual describes features that are not included in every edition of MySQL 5.7； suchfeatures may not be included in the edition of MySQL 5.7 licensed to you.If you have any questions about thefeatures included in your edition of MySQL 5.7， refer to your MySQL 5.7 license agreement or contact your Oraclesales representative，For notes detailing the changes in each release， see the MySQL 5.7 ReleaseNotes.For legal infomation， see the Legal Notices.Documentgeneratedon：2015-02-24(revision；41748)GeneralAdminstratorsMySQLDevelopers&Connectors&HA/ScalabilityTutorialInstallation&Connectors andwHA/Scala bili y..........
《MySQL 57 Reference Manual用户手册_共3612页》目录
1 General Information.
1.1 About This Manual.
1.2 Typographical and Syntax Conventions..
1.3Ove view of the MySQL Database Management System..
1.4 What Is New in MySQL 5.7
1.5 MySQL Development History.
1.6 MySQL Information Sources.
1.7HowtoReportBuasor Problems..
1.8 MySQL Standards Compliance..
1.9 Credits..
2.1 General Installation Guidance.
2.2 Installing MySQL on Unix/Linux Using Generic Binaries..
2.3InstalingMySQLon Microsoft Windows.
1.3.1 What is MySQL?.
1.3.2 The Main Features of MySQL..
1.3.3 History of MySQL.
1.6.1 MySQL Malling Lists..
.6.2 MySQL Community Support at the MySQL Forum..
1.6.3 MySQL Community Support on Inte met Relay Chat(IRC) ..
1.6.4 MySQL Enterprise..
1.8.1 MySQL Extensions to Standard SQL..
1.8.2MySQLDf ferences from Standard SQL..
1.8.3How MySQL Deals with Constraints..
1.9.1 Contributors to MySQL..
1.9.2 Document ers and translators.
1.9.3 Packages that support MySQL..
1.9.4 Tools that were used to create My S.
1.9.5 Supporters of MySQL..
2.1.1 Which MySQL Version and Di tr bution to Inst.
2.1.2HowtoGet MySQL..
2.1.3Vertying Package Integr t yUng MD 5 Checksums or Gnu..
2.1.4 Installation Layouts..
2.1.5 Compiler-Speci ic Bud Character ists..
2.3.1 MySQL Installation Layout on Microsoft Windows.
2.3.2 Choosing An Installation Package..
2.3.3InstalngMySQLon Microsoft Windows Using MySQL Instale r.
2.3.4MySQLNotifler..
2.3.5 Installing MySQL on Microsoft Windows Using a no install Zip Archive..
2.3.6 Troubleshooting a Microsoft Windows MySQL Server Installation..
2.3.7 Upgrading MySQL on Windows.
2.3.8 Windows Post installation Procedures.
2.4InstalngMySQLonOSX.
2.5 Installing MySQL on Linux..
2 Installing and Upgrading MySQL.
2.6InstaingMySQLon Solaris and OpenSolaris.
2.4.1GeneralNotesoninstlng MySQL on OS..
2.4.2InstalingMySQLonOSX Using Nave Packages.
2.4.3Installnga MySQL Launch Daemon..
2.4.4 Installing the MySQL Startup Item.
24.5instngandUng the MySQL Preference..a.
2.5.1InstlingMySQLon Linux Using the MySQL Yum Repost or..
MySQL 5.7 Reference Manual
2.5.2 Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository .. 140
2.5.3InstalingMySQLon Linux Using the MySQL APT Repository..142
2.5.4 Installing MySQL on Linux Using the MySQL SLES Repository.142
2.5.5 Installing MySQL on Linux Using RPM Packages..143
2.5.6InstalingMySQLon Linux Using Debian Packages from Oracle..148
2.5.7InstalingMySQLon Linux from the Native Software Repositories.150
2.6.1InstallngMySQLon Solaris Using a Solaris PKG.155
2.6.2 Installing MySQL on OpenSolaris Using IPS..156
2.8.1 MySQL Layout for Source Instalation.160
2.8.2 Installing MySQL Using a Standard Source Distribution.160
2.8.3 Installing MySQL Using a Development SourceTree..164
2.8.4 MySQL Source-Configuration Options..167
28.5Delingwth Problems Comp g My S.183
2.8.6 MySQL Configuration and Third-Party Tools.185
2.9.1 Post installation Procedures for Unix-like Systems..186
2.9.2 Securing the Initial MySQL Accounts.roo111t..191
2.9.3 Staring and Stopping MySQL Automatically.195
2.9.4 Troubleshooting Problems Starting the MySQL Server..198
2.10.1Upgradig MySQL.200
2.10.2 Downgrading MySQL.208
2.10.3 Checking Whether Tables or indexes Must Be Re bui.
.2.10.4 Rebuilding or Repairing Tables or Indexes.
2.10.5 Copying MySQL Databases to Another Machine..214
2.12.1InstalingPerionUnix..217
2.12.3 Problems Using the Perl DBI/DBD Interface.219
3.3.1 Creating and Selecting a Database..
3， 3.2 Creating a Table.
3.3.3 Loading Data into a Table..229
3.3.4 Retrieving Information from a Table..230
3.6.1 The Maximum Value for a Column.247
3.6.2TheRow Holding the Maximum of a Certain Column..247
3.6.3 Maximum of Column per Group..248
3.6.4 The Rows Holding the Group-wise Maximum of a Certain Column..248
3.6.5 Using User-De in ed Variables..249
3.6.6 Using Foreign Keys..249
3.6.7 Searching on Two Keys..251
3.6.8 Calculating Visits Per Day..251
3.6.9 Using AUTO_INCREMENT..fri.252
2.7InstallngMySQLon FreeBSD.
2.8 Installing MySQL from Source.
2.9 Post installation Setup and Testing..
2.10 Upgrading or Downgrading MySQL..
2.11 Environment Variables..
2.12Perl Installation Notes..
2.12.2instangAcveSatePerionW id.
3.1 Connecting to and Disconnecting from the Server..
3.2 Entering Queries..
3.3 Creating and Using a Database.
3.4Gettng Information About Databases and Tables.
3.5 Using mysql in Batch Mode.
3.6 Examples of Common Queries.
3.7UsingMySQLwithApach.
4.1 Overview of MySQL Programs.
4.2 Using MySQL Programs..
4.2.1 Invoking MySQL Programs.
4.2.2 Connecting to the MySQL Server..
4.2.3 Specifying Program Options.
4.2.4 Using Options on the CommandLine.
4.2.5 Program Option Modifiers..
4.2.6 Using Option Files..
4.2.7 Command-Line Options that A fec tOp in-File Hand ng..
.4.2.8 Using Options to Set Program Variables.
4.2.9Optin Defaults， Opt ins Expect g Values， and the=Sign.
4.2.10 Setting Environment Variables..
4.3.1mysqld-The MySQL Ser..
..3.2mysqid_safe-MySQL Server Startup Scrip..
4.3.3 mysql.server-MySQL Server Startup Script..
4.3.4mysqld_mu-Manage Multiple MySQL Servers.
44.1camprrCompi MySQL ErrorMessage il..
4.4.2 mysql_insall db-Initialize MySQL Data Directory.
4.4.3 mysql_plugin一Configure MySQL Server Plugins..
4.3 MySQL Server and Server-Startup Programs..
4.4 MySQL Installation-Related Programs.
4.5 MySQL Client Programs..
4.6 MySQL Administrative and Ut lity Programs..
4.7 MySQL Program Development Ui ies.
4.8 Miscellaneous Programs.
5.1 The MySQL Server..
5.3RunningMultle MySQL Instances on One Machin.
6.1 General Securty Issues..
6.2 The MySQL Access Privilege System.
6.3 MySQL User Account Management..
4.4.4 mysql_secure_installation-Improve MySQL Installation Security.
4.4.5mysq 1_ssl_rsa_setup-Generate SSL/RSA Files..
4.4.6my5ql_ezinE o_E_sql-Load the Tie Zone Tables..
4.4.7 mysql_upgrade一Check and Upgrade MySQL Tables.
4.5.1mysqi-The MySQL Command-Line Tool
4.5.2 mysqladmin-Client for Administering a MySQL Server..
4.5.3mysqlchack一A Table Maintenance Program..
4.5.4 mysqldump-A Database Backup Program.
4.5.5 mysqlimport-A Data Import Program..
4.5.6 mysqlshow-Display Database， Table， and Column Information.
4.5.7mysqlslap-Load Emulation Client.
4.6.1innochaeksum-Off ne InnoDB Fie Checksum Uity..
4.6.2myisam_ft dump-Display Ful-Text Index information.
4.6.3myisamc-MyISAM Table-Maintenance Uity.
4.6.4myisamlog-Display My l SAM LogFile Contents.
4.6.5myisampack-Generate Compressed， Read-Only MyISAM Tables.
4.6.6 mysql config editorMySQL Configuration Utility..
4.6.7 mysqlbinlog一Utility for Processing Binary LogFiles.
4.6.8 mysqldump slow一SummarizeS low Query LogFiles..
4.7.1 mysql_config-Display Options for Compiling Clients.
4.7.2my_print_defaults-Display Options from Option Files..
4.7.3resalve_stack_dump一Resolve Numeric StackTrace Dump to Symbols..
4.8.1p error-Explain Error Codes..
4.8.2 replace-AS trng-Replacement Ut ity.462
4.8.3resolveip-Resolve Hostname to IPAddress or ViceVersa，463
5.1.1 Server Option and Variable Reference.466
5.1.2 Server Conf guration Defaults..
5.1.3 Server Command Options.
5.1.4 Server System Variables..
5.1.5 Using System Variables..
5.1.6 Server Status Variables.
5.1.7 Server SQL Modes..
5.1.8 Server Plugins.730
5.1.9IPv 6 Support..
5.1.10 Server-Side Help..
5.1.11 Server Response to Signals.
5.1.12 The Shutdown Process..
5.2.1 Selecting General Query and Slow Query Log Output Desinations.
5.2.2 The ErrorLog.
5.2.3 The General Query Log.
5.2.4 The Binary Log..
5.2.5 The Slow Query Log..
5.2.6TheDDLLog..
5.2.7 Server Log Maintenance..
5.3.1 Setting Up Multiple Data Directories.
5.3.2RunningMultple MySQL Instances on Windows..765
5.3.3 Running Multiple MySQL Instances on Unix..768
5.3.4 Using Client Programs in a Multiple-Server Environment..769
5.4.1mysqldD Trace Probe Reference..
6.1.1Securty Guidelines.
6.1.2 Keeping Passwords Secure..793
6.1.3 Making MySQL Secure Against Attackers.807
6.1.4 Security-Related mysqld Options and Variables.
6.1.5HowtoRunMySQLasa Normal User..810
6.1.6 Security Issues with LOAD DATA LOCAL..
6.1.7 Client Programming Security Guidelines.
6.2.1 Privileges Provided by MySQL..814
6.2.2 Privilege System Grant Tables.818
6.2.3 Specifying Account Names.824
6.2.4 AccessControl，Stage1：ConnectionVerfication..826
6.2.5 AccessControl，Stage2：RequestVerification..829
6.2.6 When Privilege Changes Take Effect..
6.2.7 Causes of Access-Denied Errors..
6.3.1 UserNames and Passwords..
6.3.2 Adding User Accounts..838
6.3.3 Removing User Accounts..842
6.3.4 Setting Account Resource Limits.842
6.3.5 Assigning Account Passwords..844
6.3.6 Password Expiration Policy.846
6.3.7 Password Expiration and Sandbox Mode..，847
6.3.8 Pluggable Authentication.849
6.3.9 Authentic at n Plugins Avalable in My SQ..852
6， 3.10 Proxy Users..864
5 MySQL Server Administration..
5.2MySQLServarLogs.
5.4Tracingmysqid Using DTrace..
6 Security..
.MySQL 5.7 Reference Manual
MySQL 5.7 Reference Manual
6.3.11 User Account Locking.
6.3.12UsingSSL for Secure Connections.
6.3.13 Connecting to MySQL Remotely from Windows with SSH
6.3.14SQL-Based MySQL Account Activity Aud ting.
7.3.1 Establishing a Backup Policy.
7.3.2 Using Backups for Recovery..
7.3.3 Backup Strategy Summary..
7.4.1 Dumping Data in SQL Format with mysqldump.
7.4.2 Reloading SQL-Format Backups.
7.4.3 Dumping Data in Delimited-Text Format with mysqldump..
7.4.4 Reloading Delimited-Text Format Backups..
7.4.5 mysqldump Tips.
7.5.1 Point-in-Time Recovery Using Event Times..
7.5.2 Point-in-Time Recovery Using Event Positions.
7.6.1 Using myisamchk for Crash Recovery.
7.6.2How to Check MyISAM Tables for Errors.
7.6.3How to Repair MyISAM Tables.
7.6.4MylSAM Table Optimization.
7.6.5SettingUpaMyISAM Table Maintenance Schedule.
8.2.1 Optimizing SELECT Statements..
8.2.2 Optimizing DML Statements.
8.2.3 Optimizing Database Pr vie ges.
8.2.4 Optimizing INFORMATION_SCHEMA Queries.
8.2.5 Other Optimization Tips.
8.3.1How MySQL Uses Indexes
8.3.2 Using Primary Keys.，
8.3.3 Using Foreign Keys..
8.3.4 Column Indexes.
8.3.5 Multiple-Column Indexes..
8.3.6 Verifying Index Usage..
8.37InnoDB and MyISAM Index Statistics C llc tn
8.3.8 Comparison of B-Tree and Hash Indexes..
8.4.1 Optimizing Data Size.
8.4.2Optizing MySQL DataTypes..
8.4.3 Optimizing for Many Tables.
8.4.4How MySQL Uses Internal Temporary Tables..
8.5.1 Optimizing Storage Layout for InnoDB Tables..
8.5.2 Optimizing InnoDB Transaction Management，
8.5.3 Optimizing InnoDB Logging..
8.5.4Bulk Data Loading for InnoDB Tables..
8.5.5 Optimizing InnoDB Queries..
8.8.3 Obtaining Execution Plan Information for a Named Connection，
8.9.4 Caching of Prepared Statements and Stored Programs..
8.12.1 Measuring the Speed of Expressions and Functions..
8.12.2 The MySQL Benchmark Suite.
7 Backup and Recovery.
8 Optimization..
9 Language Structure..
7.1 Backup and Recovery Types..
7.2 Database Backup Methods..
7.3 Example Backup and Recovery Strategy.
7.4UsingmysqidumpforBacku..
8.6.2Bulk Data Loading for MyISAM Tables.
8.6.3 Speed of REPAIR TABLE Statements.
8.8.1 Optimizing Queries with EXPLAIN.
8.8.2 EXPLAIN Output Format..
8.8.4 EXPLAIN EXTENDED Output Format..
8.8.5 Estimating Query Perfom mance.
8.8.6 Controlling the Query Optimizer..
8.9.1 The InnoDB Buffer Pool.
8.9.2TheMylSAMKey Cache..
8.9.3 The MySQL Query Cache..
8， 10.1 Internal Locking Methods，
8.10.2 Table Locking Issues..
8.10.3 Concurrent Inserts.
8.10.4 Metadata Locking..
8.10.5 External Locking..
8.11.1 System Factors and Startup Parameter Tuning..
8.11.2 Tuning Server Parameters.
8.11.3 Optimizing Disk I/O.
8.11.4 Optimizing Memory Use..
8.11.5 Optimizing Network Use.
8.12.3 Using Your Own Benchmarks..
8.12.4 Measuring Perfom mance with performance_schema..
8.12.5 Examining Thread Information.
9.1.1SringLtra..
9.1.2 Number Literals..
9.1.3 DateandTime Literals.
9.1.4 Hexadecimal Literals.
9.1.5 Boolean Literals.
9.1.6Bit-Field Literals.
9.1.7NULL Value.
9.2.1 Identifier Qualifiers..
9.2.2 Identifier Case Sensitivity..
9.. 3 Mapping of Id enters to FileName.
9.2.4 Function Name Parsing and Resolution..
7.5 Point in-Time(Incremental) Recovery Using the Binary Log..
7.6MyISAM Table Maintenance and Crash Recovery.
8.1 Optimization Overview.
8.2 Optimizing SQL Statements..
8.3 Optimization and Indexes.
8.4 Optimizing Database Structure.
8.5 Optimizing for InnoDB Tables.
8.5.6 Optimizing InnoDB DDL Operations..
8.5.7 Optimizing InnoDB Disk//O.
8.5.8 Optimizing InnoDB Configuration Variables..
8.5.9OptimizingInncDB for Systems wth Many Tables..
8.6 Optimizing for MyISAM Tables..
8.6.1OptimingMyISAMQuerie.
8.7 Optimizing for MEMORY Tables..
8.8 Understanding the Query Execution Plan.
8.9 Buffering and Caching.
8.10 Optimizing Locking Operations..
8.11 Optimizing the MySQL Server..
8.12Measuing Performance(Benchmarking) .
9.1 Literal Values..
9.2 Schema Object Names.
9.3 Reserved Words..
MySQL 5.7 Reference Manual
MySQL 5.7 Reference Manual
9.4 User-Defined Variables..
9.5 Expression Syntax.
9.6 Comment Syntax.
10.1 Character Set Support..
10 Globalization..
11 DataTypes.
11.4 String Types..
12 Functions and Operators.
10.1.1 Character Sets and Collations in General..
10.1.2 Character Sets and Collations in MySQL..
10.1.3 Specifying Character Sets and Collations..
10.1.4 Connection Character Sets and Collations..
10.1.5 Configuring the Character Set and Collation for Applications.
10.1.6 Character Set for Error Messages.
10.1.7 Collation Issues..
10.1.8 String Repertoire..
10.1.9 Operations Affected by Character Set Support.
10.1.10 Unicode Support.
10.1.11 Upgrading from Previous to Curent Unicode Support.
10.1.12UTF-8 for Metadata.
10.1.13 Column Character Set Conversion..
10.1.14 Character Sets and Collations That MySQL Supports.
10.3.1 Character Definition Arrays..
10.3.2 String Collating Support for Complex Character Sets..
10.3.3Mult-Byte Character Support for Complex Character Sets.
10.4.1 Collation Implementation Types.
10.4.2 Choosing a Collation ID..
10.4.3 Adding a Simple Collation to an 8-Bt Character Sett..
10.4.4AddingaUCA Collation to a Unicode Character Set.
10.6.1 Staying Current wth TimeZone Changes..
10.6.2 TimeZone Leap Second Support.
11.1.1 Numeric Type Overview.
11.1.2 DateandTime Type Overview
11.1.3 StringType Overview..
10.2 Setting the Em or Message Language.
10.3 Adding a Character Set.
10.4 Adding a Collation to a Character Set..
10.5 Character Set Configuration， ..
10.6 MySQL Server TimeZone Support..
10.7 MySQL Server Locale Support.
11.1 DataType Overview..
11.2 Numeric Types.
11.3 DateandTime Types..
11.5 Extensions for Spatial Data.
11.6 DataType Default Values..
11.7 DataType Storage Requirements..
11.8 Choosing the Right Type for a Column.
11.9 Using DataTypes from Other Database Engines..
12.1Funcon and Operator Reference.
12.2 Type Conversion in Expression Evaluation..
12.3 Operators..
12.4 Control Flow Functions.
12.5 String Functions.
12.6 Numeric Functions and Operators.
12.7 DateandTime Functions.
12.8 What Calendar Is Used By MySQL?.
12.9 Full-Text Search Functions..
12.10Cast Functions and Operators.
12.11XML Functions.
12.12Bit Functions.
12.13 Encryption and Compression Functions.
12.14 Information Functions..
12.15 Spatial Analysis Functions..
11.2.1 Integer Types(Exact Value) -INTEGER， INT， SMALLINT， TINYINT， MEDIUMINT，
BIGINT..1201
11.2.2 Fixed-Point Types(Exact Value) -DECIMAL， NUMERIC1202
11.2.3 Floating-Point Types(Approximate Value) -FLOAT， DOUBLE.-------1202
11.2.4Bit-ValueType-BIT.1203
11.2.5NumercTypeAttrbutes..1203
11.2.6Out-of-Range and Overflow Handling..1204
11.3.1 The DATE， DATETIME， and TIMESTAMP Types..wwwwwww
11.3.2 The TIME Type.
11.3.3 The YEAR Type.
11.3.4 YEAR(2) Limit a ons and Migrating to YEAR(4) ..
11.3.5 Automatic Initial zation and Updating for TIMESTAMP and DATETIME
11.3.6 Fractional Seconds in Time Values..1216
11.3.7 Conversion Between DateandTime Types..
11.3.8Two-Digit Years in Dates..
11.4.1 The CHAR and VARCHAR Types.
11.4.2 The BINARY and VARBINARY Types.
11.4.3TheBLOB and TEXT Types.r trp rrrr
11.4.4TheENUM Type..
11.4.5 The SET Type..
11.5.1 Spatial DataTypes..
11.5.2 The OpenGIS Geometry Model..ttr ii，
11.5.3 Using Spatial Data.
12.3.1 Operator Precedence..
12.3.2 Comparison Functions and Operators..
12.3.3 Logical Operators.1273
12.3.4 Assignment Operators.
12.5.1 String Comparison Functions..1295
12.5.2 Regular Expressions..
12.6.1 Arithmetic Operators..1305
12.6.2 Mathematical Functions..1307
12.9.1 Natural Language Full-Text Searches..1341
12.9.2 Boolean Full-Text Searches.1344
12.9.3 Full-Text Searches with Query Expansion..1350
12.9.4 Full-Text Stopwords..1350
12.9.5 FullText Restrictions..1356
12.9.6Fine-Tuning MySQL Fu-Text Searc..1357
12.9.7 Adding a Collation for Full-Text Indexing..1360
12.9.8InnoDBngram Full-Text Parser.
12.9.9InnoDBMeCabFul-Text Parser Plugin.1363
12.15.1 Spatial Function Reference..1403
12.15.2 Argument Handing by Spatial Functions..
12.15.3Funcions That Create Geometry Values rom WkT valu..
12.15.4 Functions That Create Geometry Values from WKB Values.1407
12.15.5 MySQL-Specific Functions That Create Geometry Values.
MySQL 5.7 Reference Manual
MySQL 5.7 Reference Manual
12.15.6 Geometry Format Conversion Functions..
12.15.7 Geometry Property Functions.
12.15.8 Spatial Operator Functions..
12.15.9 Functions That Test Spatial Relations Between Geometry Objects..
12.15.10SpatialGeohash Functions..
12.15.11SpatialGeoJSON Functions.
12.18.1 GROUP BY(Aggregate) Functions.
12.18.2 GROUP BY Modifiers.
12.18.3 MySQL Handing of GROUP BY.
12.18.4 Detection of Functional Dependence..
12.19.1 Types of Numeric Values..
12.19.2 DECIMAL DataType Characteristics
12.19.3 Expression Handling..
12.19.4 Rounding Behavior..
12.19.5 Precision Math Examples.
13.1.1ALTER DATABASE Syntax.
13.1.2ALTER EVENT Syntax.
13.1.3ALTER FUNCTION Syntax..
13.1.4ALTER PROCEDURE Syntax..
13.1.5ALTER SERVER Syntax..
13.1.6ALTER TABLE Syntax..
13.1.7ALTER VIEW Syntax..
13.1.8 CREATE DATABASE Syntax..
13.1.9 CREATE EVENT Syntax..
13.1.10 CREATE FUNCTION Syntax.
13.1.11 CREATE INDEX Syntax..
13.1.12 CREATE PROCEDURE and CREATE FUNCTION Syntax
13.1.13 CREATE SERVER Syntax..
13.1.14 CREATE TABLE Syntax..
13.1.15 CREATE TRIGGER Syntax.
13.1.16 CREATE VIEW Syntax.
13.1.17DROP DATABASE Syntax..
13.1.18DROP EVENT Syntax..
13.1.19DROP FUNCTION Syntax..
13.1.20DROP INDEX Syntax.
13.1.22DROP SERVER Syntax.
13.1.23DROP TABLE Syntax.
13.1.24DROP TRIGGER Syntax.
13.1.25DROP VIEW Syntax.
13.1.26RE NAME TABLE Syntax.
13.1.27 TRUNCATE TABLE Syntax，
13.2.1C ALL Syntax..
13.2.2 DELETE Syntax..
13.2.3DO Syntax.
13.2.4 HANDLER Syntax..
13.2.5 INSERT Syntax.
13.3.1 START TRANSACTION， COMMIT， and ROLLBACK Synt..
12.16Funcions Used with Global Transaction IDs.
12.17 Miscellaneous Functions.
13.3.2 Statements That Can not Be Rolled Back.
13.3.3 Statements That Cause an Implicit Commit.
12.18 Functions and Mod fiers for Use wth GROUP BY Clauses.
12.19 Precision Math..
13.1 Data Definition Statements.
13.1.21DROP PROCEDURE and DROP FUNCTION Syntax.
13.2 Data Manipulation Statements.
13.2.6LOAD DATA IN FILE Syntax.
13.2.7LOADXML Syntax.
13.2.8 REPLACE Syntax..
13.2.9 SELECT Syntax.
13.2.10 Subquery Syntax.
13.2.11 UPDATE Syntax.
13.3 MySQL Transactional and Locking Statements.
13.5SQL Syntax for Prepared Statements..
13.6 MySQL Compound-Statement Syntax..
13.7 Database Administration Statements.
14.1 Introduction to InnoDB.
14.2InnoDB Concepts and Arch tecture.
13SQL Statement Syntax.
13.4 Replication Statements..
13.8MySQLUtity Statements..
14 The InnoDB Storage Engine.
13.3.4 SAVEPOINT， ROLLBACK TO SAVEPOINT， and RELEASE SAVEPOINT Syntax . 1612
13.3.5LOCK TABLES and UNLOCK TABLES Syntax..1613
13.3.6SET TRANSACTION Syntax.rrrrrrrr1619
13.3.7XA Transactions..1622
13.4.1SQL Statements for Conrol ng Master Servers.*-rr errr-1625
13.4.2SQL Statements for Controlling Slave Servers.1628
13.4.3SQL Statements for Controling Replication Servers..1642
13.5.1 PREPARE Syntax.1646
13.5.2 EXECUTE Syntax.merr rrrr1647
13.5.3 DEALLOCATE PREPARE Synta.--+1647
13.6.1 BEGIN.END Compound-Statement Syntax.1648
13.6.2 Statement Label Syntax.1648
13.6.3 DECLARE Syntax.1649
13.6.4 Variables in Stored Programs.1649
13.6.5 FlowControl Statements.1651
13.6.6 Cursors..1656
13.6.7CondtionHandng..rrrr mir..1657
13.7.1 Account Management Statements.1685
13.7.2 Table Maintenance Statements.1705
13.7.3 Plugin and User-Defined Function Statements.1714
13.7.4SET Syntax.1717
13.7.5 SHOW Syntax.1720
13.7.6 Other Administrative Statements..A1763
13.8.1 DESCRIBE Syntax.1773
13.8.2 EXPLAIN Syntax.1773
13.8.3 HELP Syntax..1775
13.8.4USE Syntax.1777
14.1.1InnoDBas the Default MySQL Storage Engine.1782
14.1.2 Checking InnoDB Availability..1786
14.1.3 Turning Off InnoDB.1786
14.2.1 MySQL and the ACID Model..1787
14.2.2 The InnoDB Transaction Model and Locking.1789
14.2.3InnoD BLock Modes.1790
14.2.4 Consistent Non locking Reads.，1792
14.2.5 Locking Reads(SELECT..FOR UPDATE and SELECT..LOCK IN SHARE
MODE)
MySQL 5.7 Reference Manual
MySQL 5.7 Reference Manual
14.2.6InnoDB Record， Gap， and Next-Key Locks.
14.2.7 Avoiding the Phantom Problem Using Next-Key Locking.
14.2.8 Predicate Locking for Spatial Indexes..
14.2.9LocksSetbyDiferentSQL Statements in InnoDB
14.2.10 Implicit Transaction Commit and Rollback..
14.2.11 Deadlock Detection and Rollback.
14.2.12HowtoCope with Deadlocks.
14.2.13InnoDB Multi Versioning..
14.2.14InnoDB Temporary Table Undo Logs.
14.2.15InnoDB Table and Index Structures..
14.3.1ConfguringInnoDB for Read-On y Opera ion
14.5.1 Creating the InnoDB Tablespace..
14.5.2InnoDB File-Per-Table Mode.
14.5.3Enabng and Disabling File-Per Table Mode..
14.5.4 Specifying the Location of a Tablespace..
14.3InnoDB Configuration..
14.4InnoDB Administration..
14.5InnoDB Tablespace Management..
14.6InnoDB Table Management..
14.7InnoDB Compressed Tables..
14.8InnoDB File-Format Management..
14.9InnoDBRow Storage and Row Formats.
14.10InnoDBDisk/O and FileSpace Management.
14.11InnoDB and Online DDL.
14.12InnoDB Startup Options and System Variables..
14.13InnoDB Performance..
14.14InnoDB INFORMATION SCHEMA Tables.
14.15InnoDB Monitors..
14.16InnoDB Backup and Recovery.
14.17InnoDB and MySQL Replication..
14.18InnoDB Integration with memcached.
14.5.5 Copying Tablespaces to Another Server(Transportable Tablespaces .. 1825
14.5.6StoringInnoDBUndoLogsin Separate Tablespaces.1833
14.5.7 Truncating Undo Logs That Reside in Undo Tablespaces..1834
14.. 8 Changing the Number or Sizeof InnoDB Log Fes andRes zing the InnoDB
Tablespace..1837
14.5.9UsingRawDiskPartions for the Shared Tablespace.1838
14.6.1 Creating InnoDB Tables.1840
14.6.2 Moving or Copying InnoDB Tables to Another Machine..1841
14.6.3GroupingDML Operations with Transactions..1843
14.6.4 Converting Tables from MyISAM to InnoDB.，1844
14.6.5AU TO_INCREMENT Handling in InnoDB..----1848
14.6.6InnoDB and FOREIGNKEY Constraints， .1854
14.6.7 Limits on InnoDB Tables.1855
14.7.1 Overview of Table Compression..1859
14.7.2 Enabling Compression for a Table.1860
14.7.3 Tuning Compression for InnoDB Tables.1861
14.7.4 Monitoring Compression at Runtime..1865
14.7.5How Compression Works for InnoDB Tables.1866
14.7.6 Compression for OLTP Workloads..1869
14.7.7SQL Compression Syntax Warnings and Errors..1869
14.8.1 Enabling File Formats.1872
14.8.2 Verifying FileFormat Compati bi ity..1872
14.8.3 Identifying the FileFormat in Use.-----.1876
14.8.4 Downgrading the FileFormat..1877
14.8.5 Future InnoDB File Formats..1877
14.9.1 Overview of InnoDB Row Storage..1878
14.9.2 Specifying the Row Format for a Table..1878
14.9.3 DYNAMIC and COMPRESSED Row Formats.1878
14.9.4 COMPACT and REDUNDANT Row Formats..1879
14.10.1InnoDBDiskI/O.1880
14.10.2 FileSpace Management.1880
14.10.3InnoDB Checkpoints.1881
14.10.4 Defragmenting a Table.--.-.1882
14.10.5 Reclaiming DiskSpace wth TRUNCATE TABLE..1882
14.11.1 Overview of Online DDL..
1411398omance and Concur encyConiderainsfrOnieD.*T111.1883.1890
14.11.3SQL Syntax for Online DDL1892
14.11.4 Combining or Separating DDL Statements..1893
14.11.5 Examples of Online DDL.1893
14.11.6ImplementaionDetaisofOn neD DL.1916
14.11.7How Crash Recovery Works with Onlne DDL.1917
14.11.8OnlineDDL for Partitioned InnoDB Tables.1918
14.11.9 Limitations of Online DDL.1918
14.13.1InnoDBBuffrPoolConfgur at.，1.1999
14.13.2InnoDBMutex and Read/Write Lock Implementation..2007
14.13.3 Configuring the Memory Allocator for InnoDB..2008
14.13.4 Configuring InnoDB Change Buffering..2008
14.13.5Confuring Thread Con curency for InnoDB2009
14.13.6 Configuring the Number of Background InnoDB I/O Threads.2011
14.13.7 Group Commit..2011
14.13.8 Configuring the InnoDB Master Thread I/O Rate..2011
14.13.9 Using the PAUSE Instruct in in InnoDB Spin Loo.2012
14.13.10 Configuring SpinLock Polling..2012
14.13.11InnoDBIntegratonwth MySQL PerformanceS chem..2013
14.13.12 Better Scalability with Multiple Rollback Segments.2015
14.13.13 Configuring InnoDB Purge Scheduling..2016
14.13.14OptizingInnoDB Read-Only Transactions..2016
14.13.15 Using the CRC 32 Checksum Algo thm for Faster Checksums.2017
14.13.16 Optimizer Statistics..2017
14.13.17Estaig ANALYZE TABLE Compex ty for innoDB Tabl.2025
14.13.18BulkLoad for CREATE INDEX.2027
14.13.19Conguring the Merge Threshold for Index Page.2028
14.14.1InnoDB INFORMATION_SCHEMA Tables about Compression..2031
14.14.2InnoDB INFORMATION_SCHEMA Transaction and Locking Tables.2033
14.14.3InnoDB INFORMATION_SCHEMA System Tables..2039
14.14.4InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables..2045
14.14.5InnoDB INFORMATION_SCHEMA Buffer Pool Tables.2048
14.14.6InnoDB INFORMATION SCHEMA Metrics Table.2053
14.14.7InnoDB INFORMATION_SCHEMA Temporary Table Information Table.2061
14.15.1InnoDB Monitor Types.2063
14.15.2 Enabling InnoDB Monitors..2064
14.15.3InnoDB Standard Monitor and Lock Monitor Output..2067
14.15.4InnoDB Tablespace Monitor Output..2072
14.15.5InnoDB Table Monitor Output.2074
14.16.1 The InnoDB Recovery Process..2078
14.16.2 Tablespace Discovery During Crash Recovery..2079
14.18.1Benets of the InnoDB/memcached Combination..2082
MySQL 5.7 Reference Manual
MySQL 5.7 Reference Manual
14.18.2 Architecture of InnoDB and memcached Integration.
14.18.3 GettingStarted with InnoDB Memcached Plugin..
14.18.4 Security Considerations for the InnoDB memcached Plugin..
14.18.5 Writing Applications for the InnoDB memcached Interface.
14.18.6 Using the InnoDB memcached Plugin with Replication..
14.18.7 Internals of the InnoDB memcached Plugin..
14.18.8 Troubleshooting the InnoDB memcached Plugin.
14.19.1 Troubleshooting InnoDB I/O Problems.
14.19.2 Forcing InnoDB Recovery.prr ilt if
14.19.3 Troubleshooting InnoDB Data Dictionary Operations.
14.19.4InnoDB Error Handling.
14.19.5InnoDB Error Codes.
15.2.1MyISAM Startup Options..
15.2.2 Space Needed for Keys..
15.2.3MyISAM Table Storage Formats.
15.2.4MyISAM Table Problems..
15.4.1Repairng and Checking CSV Tables
15.4.2CSV Limitations.
15.7.1MERGE Table Advantages and Disadvantages.
15.7.2MERGE Table Problems.
15.8.1 FEDERATED Storage Engine Overview..
15.8.2How to Create FEDERATED Tables..
15.8.3 FEDERATED Storage Engine Notes and Tips.
15.8.4 FEDERATED Storage Engine Resources.
15.11.1 Pluggable Storage Engine Architecture..
15.11.2 The Common Database Server Layer.
16.4.2EC 2 Instance Limitations.
164.3Depoyinga MySQL Database Using EC 2.
16.5.1UsingZFS for FileSystem Replication.
16.5.2 Configuring MySQL for ZFS Replication.
16.5.3 Handing MySQL Recovery with ZFS.
16.6.1 Installing memcached.
17.3.2 Using Replication with Diferent Master and Slave Storage Engines.
14.19InnoDB Troubleshooting.
14.19.6OperangSystemEmor Codes
15.1 Setting the Storage Engine..
15.2 The MyISAM Storage Engine..
15.3 The MEMORY Storage Engine..
15.4TheCSV Storage Engine.
15.5 The ARCHIVE Storage Engne.
15.6 The BLACKHOLE Storage Engine.
15.7 The MERGE Storage Engin.
15.8 The FEDERATED Storage Engine..
15.9 The EXAMPLE Storage Engine..
15.10 Other Storage Engines.
16.4.1SettingUpMySQLonanEC2AM I.
15 Alternative Storage Engines..
16 High Availability and Scalability..
17 Replication..
18 Partitioning.
15.11 Overview of MySQL Storage Engine Architecture..
16.1OracleVM Template for MySQL Enterprise Edi ion..
17.1.1SetingUp Binary Log Based Replication..
17.1.2 Replication Formats.
17.1.3 Replication with Global Transaction Identifer s..
17.1.4Repicain and Binary Logging Options and Variable..
17.1.5 Common Replication Administration Tasks.
17.2.1 Replication Implementation Details..
17.2.2 Replication Relay and Status Logs..
17.2.3How Servers Evaluate Replication Filtering Rules，
17.3.1 Using Replication for Backups..
17.3.3 Using Replication for Scale-Out..
17.3.4Reliating Diferent Databases to Diferent Slaves.
17.3.5 Improving Replication Performance， ..
17.3.6 Switching Masters During Failover.
17.3.7 Setting Up Replication Using SSL.
17.3.8Semi synchronous Replication.
17.3.9 Delayed Replication..
17.4.1 Replication Features and Issues..
17.4.2ReicationCompatibty Between MySQL Version..
17.4.3 Upgrading a Replication Setup..
17.4.4 Troubleshooting Replication..
17.4.5How to Report Replication Bugs or Problems.
18.2.1 RANGE Part tioning..
18.2.2 LIST Partitioning.
18.2.3 COLUMNS Partitioning.
18.2.4HASH Partitioning..
18.2.5KEY Partitioning..
18.2.6Sub partitioning..
18.2.7HowMySQLPartioning Handles NULL.
18.. 1 Management of RANGE and LIST Pario..
18.3.2 Management of HAS Hand KEY Partitions..
18.3.3 Exchanging Partitions and Subpart ions with Tables.
18.3.4 Maintenance of Partitions..
18.3.5 Obtaining Information About Partitions，
18.6.1ParttningKeys， Pr ary Keys， and Unique Keys..
18.6.2 Partitioning Limitations Relating to Storage Engines.
18.6.3 Partitioning Limitations Relating to Functions.
18.6.4 Partitioning and Locking.
16.2 Overview of MySQL with DRBD/Pacemaker/Coro sync/Oracle Linux.
16.3 Overview of MySQL with Windows Failover Clustering.
16.4 Using MySQL within an Amazon EC 2 Instance..
16.5UsingZFS Replication.
16.6 Using MySQL with memcached.
16.6.2 Using memcached， .
16.6.3DeveopingamemcachecAppi caton..
16.6.4Gettingmemaached Statistics..
16.6.5 memcached FAQ.
17.1 Replication Using the Binary Log.
17.2 Replication Implementation..
17.3 Replication Solutions..
17.4 Replication Notes and Tips..
18.1OverviewofPariioningin MySQL.
18.2 Partitioning Types..
18.3Partion Management..
18.4Paition Pruning.
18.5 Partition Selection.
18.6Restctions and Limitations on Part ii on ing..
.MySQL 5.7 Reference Manual
MySQL 5.7 Reference Manual
19 Stored Programs and Views..
20 INFORMATION_SCHEMA Tables.
21 MySQL Performance Schema.
19.1 Defining Stored Programs.
19.2 Using Stored Routines(Procedures and Functions) .
19.3 Using Triggers.
19.4 Using the Event Scheduler.
19.5 Using Views..
19.6 AccessControl for Stored Programs and Views.
19.7 Binary Logging of Stored Programs.
19.2.1 Stored Routine Syntax.
19.2.2 Stored Routines and MySQL Privileges.
19.2.3 Stored Routine Metadata..
19.2.4 Stored Procedures， Functions， Triggers， and LAST_INSERT_ID 0
19.3.1 Trigger Syntax and Examples.
19.3.2 Trigger Metadata.
19.4.1 Event Scheduler Overview..
19.4.2 Event Scheduler Configuration
19.4， 3 Event Syntax.
19.4.4 Event Metadata.
19.4.5 Event Scheduler Status.
19.4.6 The Event Scheduler and MySQL Privileges.
19.5.1 View Syntax.
19.5.2 View Processing Algorithms.
19.5.3 Updatable and Insertable Views..
19.5.4 View Metadata.
20.1 The INFORMATION_SCHEMA CHARACTER_SETS Tabl..
20.2 The INFORMATION SCHEMA COLLATION STable..
Tables.
20.30.2 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and
INNODB_CMP_PER_INDEX_RESET Tables..
20.30.3 The INFORMATION SCHEMA INNODB CMP MEM and
INNODB_CMP MEM_RESET Tables.
20.30.4 The INFORMATION_SCHEMA INNODB_TRX Table..
20.30.5 The INFORMATION_SCHEMA INNODB_LOCKS Table.
20.30.6 The INFORMATION SCHEMA INNODB LOCK WAIT STable.
20.30.7 The INFORMATION_SCHEMA INNODB_SYS_TABLES Table.
20.30.8 The INFOI RMATION_SCHEMA INNODB_SYS_INDEXES Table.
20.30.9 The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table..
20.30.10 The INMATION SCHEMA INNODB SYS FIELDS Table.
20.30.11 TheIATION_SCHEMA INNODB_SYS_FOREIGN Table.
20.30.12 The INATION
20.30.13 The INATIO
20.30.14TheiATIO
20.30.15 The INATIO
20.30.16 TheI ATIO
20.30.17 The INATION
20.30.18 The INIATION
20.30.19 The INATION
20.30.20 TheIATION
20.30.21 The INOR M
20.30.22 The INFO
20.30.23 The INFORMATION SCHEMA INNODB FT INDEX CACHE Table.
20.30.24 The INFORMATION SCHEMA INNODB FT DELETED Tabl.
20.30.25 The INFORMATION SCHEMA INNODB_FT_BEING_DELETED Table.
20.30.26 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table..
21.2.1 Performance Schema Build Configuration..
21.2.2 Performance Schema Startup Configuration.
21.2.3 Performance Schema Runtime Configuration..
21.9.1 Performance Schema Table Index.
21.9.2 Performance Schema Setup Tables..
21.9.3 Performance Schema Instance Tables.
21.9.4 Performance Schema Wait Event Tables..
21.9.5 Performance Schema Stage Event Tables..
21.9.6 Performance Schema Statement Event Tables.
21.9.7 Performance Schema Transaction Tables.
21.9.8 Performance Schema Connection Tables.
21.9.9 Performance Schema Connect nAtti bute Tables.2689
20.3 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table . 2541
20.4 The INFORMATION_SCHEMA COLUMNS Table.2541
20.5 The INFORMATION SCHEMA COLUMN PRIVILEGES Table.2542
20.6 The INFORMATION SCHEMA ENGINES Table..2543
20.7 The INFORMATION SCHEMA EVENTS Table..2544
20.8 The INFORMATION SCHEMA FILES Table..2547
20.9 The INFORMATION SCHEMA GLOBAL STATUS and SESSION STATUS Table..2548
20.10 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES
Tables.2549
20.11 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table.2549
20.12 The INFORMATION SCHEMA OPTIMIZER TRACE Table..2550
20.13 The INFORMATION_SCHEMA PARAMETERS Table..2550
20.14 The INFORMATION_SCHEMA PARTITIONS Table..2551
20.15 The INFORMATION_SCHEMA PLUGINS Table..2554
20.16 The INFORMATION_SCHEMA PROCESS LIST Table.2555
20.17 The INFORMATION_SCHEMA PROFILING Table.2556
20.18 The INFORMATION SCHEMA REFERENTIAL CONSTRAINTS Table..2557
20.19 The INFORMATION SCHEMA ROUTINES Table..2558
20.20 The INFORMATION_SCHEMA SCHEMATA Table..2559
20.21 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table..2560
20.22 The INFORMATION SCHEMA STATISTICS Table.2560
20.23 The INFORMATION SCHEMA TABLES Table.2561
20.24 The INFORMATION SCHEMA TABLESPACES Table..2562
20.25 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table..2563
20.26 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table.2563
20.27 The INFORMATION SCHEMA TRIGGERS Table.2564
20.28 The INFORMATION_SCHEMA USER_PRIVILEGES Table.2566
20.29 The INFORMATION_SCHEMA VIEWS Table..2566
20.30 INFORMATION SCHEMA Tables for InnoDB..2568
20.30.1 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET
20.31 Extensions to SHOW Statements..2603
21.1 Performance Schema QuickStart..2609
21.2 Performance Schema Configuration..2615
21.3 Performance Schema Queries..2638
21.4Periormance Schema Instrument Naming Convent n.2638
21.5 Perfomance Schema Status Monitoring.2641
21.6 Performance Schema Atom and Molecule Events..2645
21.7 Performance Schema Statement Digests.2645
21.8 Performance Schema General Table Characteristics..2648
21.9 Performance Schema Table Descriptions.2648
MySQL 5.7 Reference Manual
21.9.10 Performance Schema Replication Tables， ，
21.9.11 Performance Schema Lock Tables..
21.9.12 Performance Schema Summary Tables..
21.9.13 Performance Schema Miscellaneous Tables..
22.7.1 Compiling Programs with libmysqld.
22.7.2 Restrictions When Using the Embedded MySQL Server.
22.7.3 Options with the Embedded Server..
22.7.4 Embedded Server Examples.
22.8.1MySQLCAPI Implement at in..
22.8.2 Simultaneous MySQL Server and Connector/C Installations
22.8.3 Example CAPI Client Programs.
22.8.4 Building and Running CAPI Client Programs.
22.8.5CAPI DataStructures.
22.8.6CAPI Function Overview.
22.8.7CAPI Function Descriptions..
22.8.8CAPI Prepared Statements..
22.8.9CAPI PreparedStatement DataStructure..
22.8.10CAPI PreparedStatement Function Overview..
22.8.11CAPI PreparedStatement Function Descriptions.
22.8.12CAPI Threaded Function Descriptions.
22.8.13CAPI Embedded Server Function Descripton s..
22.8.14CAPI Client Plugin Functions.
22.8.15 Common Questions and Problems When Using the CAPI.
22.8.16 Controlling Automatic Reconnection Behavior..
22.8.17CAPI Support for Multiple Statement Execution.
22.8.18CAPI PreparedStatement Problems..
22.8.19CAPI PreparedStatement Handling of DateandTime Values.
22.8.20CAPI Support for Prepared CALL Statements..
22.12.1 The MySQL/Ruby API.
22.12.2 The Ruby/MySQL API.
23.1.1 MySQL Threads.
B.5.1How to Determine What Is Causing a Problem..
B.5.2 Common Errors When Using MySQL Programs.
B.5.3 Installation-Related Issues.
B.5.4 Administration-Related Issues..
B.5.5 Query-Related Issues..
B.5.6 Optimizer-Related Issues.
B.5.7 Table Definition-Related Issues..
B.5.8 Known Issues in MySQL.
21.10 Performance Schema Option and Variable Reference..
21.11 Performance Schema Command Options..
21.12 Performance Schema System Variables.
21.13 Performance Schema Status Variables.
21.14 Performance Schema and Plugins.
21.15 Using the Performance Schema to Diagnose Problems..
22.1 MySQL Connector/ODBC
22.2 MySQL Connector/Net.
22.3 MySQL Connector/J------
22.4 MySQL Connector/C++.
22.5 MySQL Connector/C..
22.6 MySQL Connector/Python.
22.7 libmysqld， the Embedded MySQL Server Librar.
22.8MySQLCAPI..
22.9MySQLPHPAPI.
22.10MySQLPerlAPI.
22.11MySQLPythonAPI..
22.12MySQLRubyAPls.
22.13MySQLTclAPI..
22.14 MySQL Eiffel Wrapper..
23.1 MySQL Internals..
23.1.2 The MySQL TestSuite..
23.2.1PluginAPI Character is tcs..
23.2.2PluginAPI Components..
23.2.3 Types of Plugins.
23.2.4 Writing Plugins..
23.2.5 MySQL Services for Plugins..
23.3.1 Features of the User-Defined Function Interface， .
23.3.2 Adding a New User-Defined Function..
23.3.3 Adding a New Native Function..
23.4.1 Debugging a MySQL Server.
23.4.2 Debugging a MySQL Client..
23.4.3TheDBUG Package.
24.1 MySQL Enterprise Monitor..
24.2 MySQL Enterprise Backup..
24.3 MySQL Enterprise Security.
24.4 MySQL Enterprise Encryption.
24.5 MySQL Enterprise Audit.
24.6 MySQL Enterprise ThreadPool..
A. 1 MySQL 5.7FAQ：General.
A. 2 MySQL 5.7FAQ：Storage Engines.
A. 3 MySQL 5.7FAQ：Server SQL Mode.
A. 4 MySQL 5.7FAQ：Stored Procedures and Functions.
A. 5 MySQL 5.7FAQ：Triggers.
A. 6 MySQL 5.7FAQ：Views.
A. 7 MySQL 5.7FAQ：INFORMATION_SCHEMA.
A. 8 MySQL 5.7FAQ：Migration..
A. 9 MySQL 5.7FAQ：Security..
A. 10 MySQL 5.7FAQ：MySQL Clust..
22 Connectors and APls..
23 Extending MySQL..
23.2 The MySQL Plugin API.
23.3 Adding New Functions to MySQL.
23.4 Debugging and Porting MySQL..
24 MySQL Enterprise Edi on..
25 MySQL Workbench.
A MySQL 5.7 Frequent Asked Ques i.
BE mors， Error Codes， and Common Problems..
C MySQL ReleaseNotes.
D Restrictions and Limits..
A. 11 MySQL 5.7FAQ：MySQL Chinese， Japanese， and Korean Character Sets..
A. 12 MySQL 5.7FAQ：Connectors&APls..
A. 13 MySQL 5.7FAQ：Replication.
B. 1 Sources of Error Information..