この記事は、2015年「MySQLマニュアルを読む」アドベントカレンダーの22日目です.
昨日の日記では、MySQLマニュアルのもくじより、レベル1(章レベル)の相違点について紹介しました。
今日は、その続きで、レベル2(節レベル)の相違を見ていきます。
なお、ここで章番号は、MySQL 5.7 マニュアルの章番号で書きます(MySQL 5.6 のマニュアルではなく)。
まず第1章General Information より、 1.5 に新たな節が追加されています。
1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 5.7
MySQL 5.7 では多くの変数類(サーバ変数、ステータス変数、オプション)が変更になっています。過去の悪しきしがらみとの決別をようやくこのバージョンで決断したな、と評価できるところもあり、そんな情報がここにまとめられています。
続いて、11章と12章。MySQL 5.7 でJSON対応したのを受けて、各章に JSON型についての説明および、JSON関係の関数についての説明の節が追加されました。
11.6 The JSON Data Type
12.16 JSON Functions
14章。細かいことですが、14.6節が、従来の「InnoDB Table Compression」から「InnoDB Table and Page Compression」へと変更されています。圧縮が、テーブルだけでなくページも対象に加わったということでしょうか(中身はまだ読んでない)。
14.6 InnoDB Table and Page Compression
17.1は、表現上の変更なので、良いでしょう。
(Replication Configuration から Configuring Replication へ)
18章の前にあった MySQL Cluster(NDB)の章が除外されたので、18章から21章まで、MySQL 5.6マニュアルの章とひとつずつずれます。(MySQL 5.6 マニュアルでは 19章から22章)
21章 INFORMATION_SCHEMA の章では、1節が追加され、2節が除去されています。
追加:20.8 The INFORMATION_SCHEMA FILES Table
除外:旧21.30 INFORMATION_SCHEMA Tables for MySQL Cluster
除外:旧21.31 Thread Pool INFORMATION_SCHEMA Tables
22章が新たに追加されたのは機能の日記のとおり。sysスキーマについての章です。
(つまりMySQL 5.6 と比べて、章は、1増1減なので、トータルで26個の章から構成されているところは、結果として変わりません)
こんな感じ。
sysスキーマとJSONの、章または節レベルでの情報追加が、やはり MySQL 5.7 の「ウリ」として、マニュアルでも目立っていますね。
MySQLマニュアルのもくじ(節レベル)
1 General Information 1.1 About This Manual 1.2 Typographical and Syntax Conventions 1.3 Overview of the MySQL Database Management System 1.4 What Is New in MySQL 5.6 1.5 MySQL Information Sources 1.6 How to Report Bugs or Problems 1.7 MySQL Standards Compliance 1.8 Credits 2 Installing and Upgrading MySQL 2.1 General Installation Guidance 2.2 Installing MySQL on Unix/Linux Using Generic Binaries 2.3 Installing MySQL on Microsoft Windows 2.4 Installing MySQL on OS X 2.5 Installing MySQL on Linux 2.6 Installing MySQL Using Unbreakable Linux Network (ULN) 2.7 Installing MySQL on Solaris and OpenSolaris 2.8 Installing MySQL on FreeBSD 2.9 Installing MySQL from Source 2.10 Postinstallation Setup and Testing 2.11 Upgrading or Downgrading MySQL 2.12 Environment Variables 2.13 Perl Installation Notes 3 Tutorial 3.1 Connecting to and Disconnecting from the Server 3.2 Entering Queries 3.3 Creating and Using a Database 3.4 Getting Information About Databases and Tables 3.5 Using mysql in Batch Mode 3.6 Examples of Common Queries 3.7 Using MySQL with Apache 4 MySQL Programs 4.1 Overview of MySQL Programs 4.2 Using MySQL Programs 4.3 MySQL Server and Server-Startup Programs 4.4 MySQL Installation-Related Programs 4.5 MySQL Client Programs 4.6 MySQL Administrative and Utility Programs 4.7 MySQL Program Development Utilities 4.8 Miscellaneous Programs 5 MySQL Server Administration 5.1 The MySQL Server 5.2 MySQL Server Logs 5.3 Running Multiple MySQL Instances on One Machine 5.4 Tracing mysqld Using DTrace 6 Security 6.1 General Security Issues 6.2 The MySQL Access Privilege System 6.3 MySQL User Account Management 7 Backup and Recovery 7.1 Backup and Recovery Types 7.2 Database Backup Methods 7.3 Example Backup and Recovery Strategy 7.4 Using mysqldump for Backups 7.5 Point-in-Time (Incremental) Recovery Using the Binary Log 7.6 MyISAM Table Maintenance and Crash Recovery 8 Optimization 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.6 Optimizing for MyISAM Tables 8.7 Optimizing for MEMORY Tables 8.8 Understanding the Query Execution Plan 8.9 Controlling the Query Optimizer 8.10 Buffering and Caching 8.11 Optimizing Locking Operations 8.12 Optimizing the MySQL Server 8.13 Measuring Performance (Benchmarking) 8.14 Examining Thread Information 9 Language Structure 9.1 Literal Values 9.2 Schema Object Names 9.3 Keywords and Reserved Words 9.4 User-Defined Variables 9.5 Expression Syntax 9.6 Comment Syntax 10 Globalization 10.1 Character Set Support 10.2 Setting the Error 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 Time Zone Support 10.7 MySQL Server Locale Support 11 Data Types 11.1 Data Type Overview 11.2 Numeric Types 11.3 Date and Time Types 11.4 String Types 11.5 Extensions for Spatial Data 11.6 Data Type Default Values 11.7 Data Type Storage Requirements 11.8 Choosing the Right Type for a Column 11.9 Using Data Types from Other Database Engines 12 Functions and Operators 12.1 Function 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 Date and Time Functions 12.8 What Calendar Is Used By MySQL? 12.9 Full-Text Search Functions 12.10 Cast Functions and Operators 12.11 XML Functions 12.12 Bit Functions and Operators 12.13 Encryption and Compression Functions 12.14 Information Functions 12.15 Spatial Analysis Functions 12.16 Functions Used with Global Transaction IDs 12.17 MySQL Enterprise Encryption Functions 12.18 Miscellaneous Functions 12.19 Functions and Modifiers for Use with GROUP BY Clauses 12.20 Precision Math 13 SQL Statement Syntax 13.1 Data Definition Statements 13.2 Data Manipulation Statements 13.3 MySQL Transactional and Locking Statements 13.4 Replication Statements 13.5 SQL Syntax for Prepared Statements 13.6 MySQL Compound-Statement Syntax 13.7 Database Administration Statements 13.8 MySQL Utility Statements 14 The InnoDB Storage Engine 14.1 Introduction to InnoDB 14.2 InnoDB Concepts and Architecture 14.3 InnoDB Configuration 14.4 InnoDB Tablespace Management 14.5 InnoDB Table Management 14.6 InnoDB Table Compression 14.7 InnoDB File-Format Management 14.8 InnoDB Row Storage and Row Formats 14.9 InnoDB Disk I/O and File Space Management 14.10 InnoDB and Online DDL 14.11 InnoDB Startup Options and System Variables 14.12 InnoDB INFORMATION_SCHEMA Tables 14.13 InnoDB Integration with MySQL Performance Schema 14.14 InnoDB Monitors 14.15 InnoDB Backup and Recovery 14.16 InnoDB and MySQL Replication 14.17 InnoDB Integration with memcached 14.18 InnoDB Troubleshooting 15 Alternative Storage Engines 15.1 Setting the Storage Engine 15.2 The MyISAM Storage Engine 15.3 The MEMORY Storage Engine 15.4 The CSV Storage Engine 15.5 The ARCHIVE Storage Engine 15.6 The BLACKHOLE Storage Engine 15.7 The MERGE Storage Engine 15.8 The FEDERATED Storage Engine 15.9 The EXAMPLE Storage Engine 15.10 Other Storage Engines 15.11 Overview of MySQL Storage Engine Architecture 16 High Availability and Scalability 16.1 Using MySQL within an Amazon EC2 Instance 16.2 Using ZFS Replication 16.3 Using MySQL with memcached 17 Replication 17.1 Replication Configuration 17.2 Replication Implementation 17.3 Replication Solutions 17.4 Replication Notes and Tips 18 MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4 18.1 MySQL Cluster Overview 18.2 MySQL Cluster Installation 18.3 Configuration of MySQL Cluster 18.4 MySQL Cluster Programs 18.5 Management of MySQL Cluster 18.6 MySQL Cluster Replication 18.7 MySQL Cluster Release Notes 19 Partitioning 19.1 Overview of Partitioning in MySQL 19.2 Partitioning Types 19.3 Partition Management 19.4 Partition Pruning 19.5 Partition Selection 19.6 Restrictions and Limitations on Partitioning 20 Stored Programs and Views 20.1 Defining Stored Programs 20.2 Using Stored Routines (Procedures and Functions) 20.3 Using Triggers 20.4 Using the Event Scheduler 20.5 Using Views 20.6 Access Control for Stored Programs and Views 20.7 Binary Logging of Stored Programs 21 INFORMATION_SCHEMA Tables 21.1 The INFORMATION_SCHEMA CHARACTER_SETS Table 21.2 The INFORMATION_SCHEMA COLLATIONS Table 21.3 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table 21.4 The INFORMATION_SCHEMA COLUMNS Table 21.5 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table 21.6 The INFORMATION_SCHEMA ENGINES Table 21.7 The INFORMATION_SCHEMA EVENTS Table 21.8 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables 21.9 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables 21.10 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table 21.11 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table 21.12 The INFORMATION_SCHEMA PARAMETERS Table 21.13 The INFORMATION_SCHEMA PARTITIONS Table 21.14 The INFORMATION_SCHEMA PLUGINS Table 21.15 The INFORMATION_SCHEMA PROCESSLIST Table 21.16 The INFORMATION_SCHEMA PROFILING Table 21.17 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table 21.18 The INFORMATION_SCHEMA ROUTINES Table 21.19 The INFORMATION_SCHEMA SCHEMATA Table 21.20 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table 21.21 The INFORMATION_SCHEMA STATISTICS Table 21.22 The INFORMATION_SCHEMA TABLES Table 21.23 The INFORMATION_SCHEMA TABLESPACES Table 21.24 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table 21.25 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table 21.26 The INFORMATION_SCHEMA TRIGGERS Table 21.27 The INFORMATION_SCHEMA USER_PRIVILEGES Table 21.28 The INFORMATION_SCHEMA VIEWS Table 21.29 INFORMATION_SCHEMA Tables for InnoDB 21.30 INFORMATION_SCHEMA Tables for MySQL Cluster 21.31 Thread Pool INFORMATION_SCHEMA Tables 21.32 Extensions to SHOW Statements 22 MySQL Performance Schema 22.1 Performance Schema Quick Start 22.2 Performance Schema Configuration 22.3 Performance Schema Queries 22.4 Performance Schema Instrument Naming Conventions 22.5 Performance Schema Status Monitoring 22.6 Performance Schema Atom and Molecule Events 22.7 Performance Schema Statement Digests 22.8 Performance Schema General Table Characteristics 22.9 Performance Schema Table Descriptions 22.10 Performance Schema Option and Variable Reference 22.11 Performance Schema Command Options 22.12 Performance Schema System Variables 22.13 Performance Schema Status Variables 22.14 Performance Schema and Plugins 22.15 Using the Performance Schema to Diagnose Problems 23 Connectors and APIs 23.1 MySQL Connector/ODBC 23.2 MySQL Connector/Net 23.3 MySQL Connector/J 23.4 MySQL Connector/C++ 23.5 MySQL Connector/C 23.6 MySQL Connector/Python 23.7 libmysqld, the Embedded MySQL Server Library 23.8 MySQL C API 23.9 MySQL PHP API 23.10 MySQL Perl API 23.11 MySQL Python API 23.12 MySQL Ruby APIs 23.13 MySQL Tcl API 23.14 MySQL Eiffel Wrapper 24 Extending MySQL 24.1 MySQL Internals 24.2 The MySQL Plugin API 24.3 MySQL Services for Plugins 24.4 Adding New Functions to MySQL 24.5 Debugging and Porting MySQL 25 MySQL Enterprise Edition 25.1 MySQL Enterprise Monitor Overview 25.2 MySQL Enterprise Backup Overview 25.3 MySQL Enterprise Security Overview 25.4 MySQL Enterprise Encryption Overview 25.5 MySQL Enterprise Audit Overview 25.6 MySQL Enterprise Firewall Overview 25.7 MySQL Enterprise Thread Pool Overview 26 MySQL Workbench