DevRunner
채용 통계
공식문서
면접 공유
기술 블로그
커뮤니티
피드백
☰
Loading...
시리즈 목록으로
한국어 번역
MySQL 9.5 Reference Manual
v9.5
https://dev.mysql.com/doc/refman/9.5/en
1,361개 문서
7,360 조회
최근 업데이트: 2026년 1월 26일
문서 목록
Preface and Legal Notices
66
1 General Information
101
7개 하위 문서
1.1 About This Manual
39
1.2 Overview of the MySQL Database Management System
17
3개 하위 문서
1.2.1 What is MySQL?
11
1.2.2 The Main Features of MySQL
9
1.2.3 History of MySQL
9
1.3 MySQL Releases: Innovation and LTS
13
1.4 What Is New in MySQL 9.5
9
1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 9.5
7
1.6 How to Report Bugs or Problems
6
1.7 MySQL Standards Compliance
7
3개 하위 문서
1.7.1 MySQL Extensions to Standard SQL
6
1.7.2 MySQL Differences from Standard SQL
9
1.7.3 How MySQL Deals with Constraints
30
2 Installing MySQL
80
10개 하위 문서
2.1 General Installation Guidance
30
6개 하위 문서
2.1.1 Supported Platforms
8
2.1.2 Which MySQL Version and Distribution to Install
5
2.1.3 How to Get MySQL
5
2.1.4 Verifying Package Integrity Using MD5 Checksums or GnuPG
4
2.1.5 Installation Layouts
5
2.1.6 Compiler-Specific Build Characteristics
4
2.2 Installing MySQL on Unix/Linux Using Generic Binaries
9
2.3 Installing MySQL on Microsoft Windows
4
6개 하위 문서
2.3.1 Choosing an Installation Package
5
2.3.2 Configuration: Using MySQL Configurator
4
2.3.3 Configuration: Manually
3
2.3.4 Troubleshooting a Microsoft Windows MySQL Server Installation
4
2.3.5 Windows Postinstallation Procedures
3
2.3.6 Windows Platform Restrictions
3
2.4 Installing MySQL on macOS
4
4개 하위 문서
2.4.1 General Notes on Installing MySQL on macOS
2
2.4.2 Installing MySQL on macOS Using Native Packages
3
2.4.3 Installing and Using the MySQL Launch Daemon
3
2.4.4 Installing and Using the MySQL Preference Pane
3
2.5 Installing MySQL on Linux
3
9개 하위 문서
2.5.1 Installing MySQL on Linux Using the MySQL Yum Repository
3
2.5.2 Installing MySQL on Linux Using the MySQL APT Repository
3
2.5.3 Using the MySQL SLES Repository
3
2.5.4 Installing MySQL on Linux Using RPM Packages from Oracle
3
2.5.5 Installing MySQL on Linux Using Debian Packages from Oracle
3
2.5.6 Deploying MySQL on Linux with Docker Containers
3
2.5.7 Installing MySQL on Linux from the Native Software Repositories
3
2.5.8 Installing MySQL on Linux with Juju
3
2.5.9 Managing MySQL Server with systemd
3
2.6 Installing MySQL Using Unbreakable Linux Network (ULN)
2
2.7 Installing MySQL on Solaris
3
1개 하위 문서
2.7.1 Installing MySQL on Solaris Using a Solaris PKG
3
2.8 Installing MySQL from Source
3
10개 하위 문서
2.8.1 Source Installation Methods
2
2.8.2 Source Installation Prerequisites
3
2.8.3 MySQL Layout for Source Installation
3
2.8.4 Installing MySQL Using a Standard Source Distribution
3
2.8.5 Installing MySQL Using a Development Source Tree
4
2.8.6 Configuring SSL Library Support
4
2.8.7 MySQL Source-Configuration Options
3
2.8.8 Dealing with Problems Compiling MySQL
2
2.8.9 MySQL Configuration and Third-Party Tools
3
2.8.10 Generating MySQL Doxygen Documentation Content
3
2.9 Postinstallation Setup and Testing
3
5개 하위 문서
2.9.1 Initializing the Data Directory
4
2.9.2 Starting the Server
3
2.9.3 Testing the Server
3
2.9.4 Securing the Initial MySQL Account
3
2.9.5 Starting and Stopping MySQL Automatically
4
2.10 Perl Installation Notes
3
3개 하위 문서
2.10.1 Installing Perl on Unix
3
2.10.2 Installing ActiveState Perl on Windows
9
2.10.3 Problems Using the Perl DBI/DBD Interface
21
3 Upgrading MySQL
71
15개 하위 문서
3.1 Before You Begin
23
3.2 Upgrade Paths
6
3.3 Upgrade Best Practices
5
3.4 What the MySQL Upgrade Process Upgrades
4
3.5 Changes in MySQL 9.5
4
3.6 Preparing Your Installation for Upgrade
3
3.7 Upgrading MySQL Binary or Package-based Installations on Unix/Linux
4
3.8 Upgrading MySQL with the MySQL Yum Repository
4
3.9 Upgrading MySQL with the MySQL APT Repository
4
3.10 Upgrading MySQL with the MySQL SLES Repository
4
3.11 Upgrading MySQL on Windows
4
3.12 Upgrading a Docker Installation of MySQL
5
3.13 Upgrade Troubleshooting
4
3.14 Rebuilding or Repairing Tables or Indexes
5
3.15 Copying MySQL Databases to Another Machine
33
4 Downgrading MySQL
86
5 Tutorial
64
7개 하위 문서
5.1 Connecting to and Disconnecting from the Server
33
5.2 Entering Queries
10
5.3 Creating and Using a Database
6
4개 하위 문서
5.3.1 Creating and Selecting a Database
4
5.3.2 Creating a Table
4
5.3.3 Loading Data into a Table
4
5.3.4 Retrieving Information from a Table
4
5.4 Getting Information About Databases and Tables
5
5.5 Using mysql in Batch Mode
5
5.6 Examples of Common Queries
5
9개 하위 문서
5.6.1 The Maximum Value for a Column
5
5.6.2 The Row Holding the Maximum of a Certain Column
4
5.6.3 Maximum of Column per Group
5
5.6.4 The Rows Holding the Group-wise Maximum of a Certain Column
5
5.6.5 Using User-Defined Variables
4
5.6.6 Using Foreign Keys
4
5.6.7 Searching on Two Keys
4
5.6.8 Calculating Visits Per Day
6
5.6.9 Using AUTO_INCREMENT
11
5.7 Using MySQL with Apache
23
6 MySQL Programs
81
10개 하위 문서
6.1 Overview of MySQL Programs
25
6.2 Using MySQL Programs
8
9개 하위 문서
6.2.1 Invoking MySQL Programs
7
6.2.2 Specifying Program Options
6
6.2.3 Command Options for Connecting to the Server
10
6.2.4 Connecting to the MySQL Server Using Command Options
6
6.2.5 Connecting to the Server Using URI-Like Strings or Key-Value Pairs
7
6.2.6 Connecting to the Server Using DNS SRV Records
6
6.2.7 Connection Transport Protocols
6
6.2.8 Connection Compression Control
5
6.2.9 Setting Environment Variables
6
6.3 Server and Server-Startup Programs
7
4개 하위 문서
6.3.1 mysqld — The MySQL Server
6
6.3.2 mysqld_safe — MySQL Server Startup Script
10
6.3.3 mysql.server — MySQL Server Startup Script
7
6.3.4 mysqld_multi — Manage Multiple MySQL Servers
8
6.4 Installation-Related Programs
8
3개 하위 문서
6.4.1 comp_err — Compile MySQL Error Message File
8
6.4.2 mysql_secure_installation — Improve MySQL Installation Security
6
6.4.3 mysql_tzinfo_to_sql — Load the Time Zone Tables
5
6.5 Client Programs
4
8개 하위 문서
6.5.1 mysql — The MySQL Command-Line Client
5
6.5.2 mysqladmin — A MySQL Server Administration Program
4
6.5.3 mysqlcheck — A Table Maintenance Program
5
6.5.4 mysqldump — A Database Backup Program
4
6.5.5 mysqlimport — A Data Import Program
3
6.5.6 mysqlshow — Display Database, Table, and Column Information
3
6.5.7 mysqlslap — A Load Emulation Client
4
6.5.8 mysqldm — The MySQL Diagnostic Monitor
3
6.6 Administrative and Utility Programs
3
10개 하위 문서
6.6.1 ibd2sdi — InnoDB Tablespace SDI Extraction Utility
3
6.6.2 innochecksum — Offline InnoDB File Checksum Utility
4
6.6.3 myisam_ftdump — Display Full-Text Index information
4
6.6.4 myisamchk — MyISAM Table-Maintenance Utility
2
6.6.5 myisamlog — Display MyISAM Log File Contents
2
6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables
3
6.6.7 mysql_config_editor — MySQL Configuration Utility
2
6.6.8 mysql_migrate_keyring — Keyring Key Migration Utility
2
6.6.9 mysqlbinlog — Utility for Processing Binary Log Files
3
6.6.10 mysqldumpslow — Summarize Slow Query Log Files
2
6.7 Program Development Utilities
3
2개 하위 문서
6.7.1 mysql_config — Display Options for Compiling Clients
3
6.7.2 my_print_defaults — Display Options from Option Files
2
6.8 Miscellaneous Programs
2
1개 하위 문서
6.8.1 perror — Display MySQL Error Message Information
3
6.9 Environment Variables
5
6.10 Unix Signal Handling in MySQL
18
7 MySQL Server Administration
70
12개 하위 문서
7.1 The MySQL Server
19
19개 하위 문서
7.1.1 Configuring the Server
7
7.1.2 Server Configuration Defaults
3
7.1.3 Server Configuration Validation
4
7.1.4 Server Option, System Variable, and Status Variable Reference
4
7.1.5 Server System Variable Reference
6
7.1.6 Server Status Variable Reference
5
7.1.7 Server Command Options
3
7.1.8 Server System Variables
2
7.1.9 Using System Variables
2
7.1.10 Server Status Variables
2
7.1.11 Server SQL Modes
2
7.1.12 Connection Management
3
7.1.13 IPv6 Support
2
7.1.14 Network Namespace Support
3
7.1.15 MySQL Server Time Zone Support
2
7.1.16 Resource Groups
2
7.1.17 Server-Side Help Support
2
7.1.18 Server Tracking of Client Session State
1
7.1.19 The Server Shutdown Process
4
7.2 The MySQL Data Directory
2
7.3 The mysql System Schema
2
7.4 MySQL Server Logs
2
6개 하위 문서
7.4.1 Selecting General Query Log and Slow Query Log Output Destinations
1
7.4.2 The Error Log
2
7.4.3 The General Query Log
2
7.4.4 The Binary Log
1
7.4.5 The Slow Query Log
2
7.4.6 Server Log Maintenance
2
7.5 MySQL Components
2
8개 하위 문서
7.5.1 Installing and Uninstalling Components
2
7.5.2 Obtaining Component Information
3
7.5.3 Error Log Components
2
7.5.4 Query Attribute Components
3
7.5.5 Scheduler Component
3
7.5.6 Replication Components
4
7.5.7 Multilingual Engine Component (MLE)
3
7.5.8 Option Tracker Component
2
7.6 MySQL Server Loadable Functions
3
2개 하위 문서
7.6.1 Installing and Uninstalling Loadable Functions
3
7.6.2 Obtaining Information About Loadable Functions
3
7.7 Running Multiple MySQL Instances on One Machine
3
7.8 Debugging MySQL
3
7.9 Debugging a MySQL Server
2
7.10 Debugging a MySQL Client
3
7.11 The LOCK_ORDER Tool
8
7.12 The DBUG Package
20
8 Security
69
8개 하위 문서
8.1 General Security Issues
23
7개 하위 문서
8.1.1 Security Guidelines
7
8.1.2 Keeping Passwords Secure
3
8.1.3 Making MySQL Secure Against Attackers
3
8.1.4 Security-Related mysqld Options and Variables
3
8.1.5 How to Run MySQL as a Normal User
3
8.1.6 Security Considerations for LOAD DATA LOCAL
2
8.1.7 Client Programming Security Guidelines
2
8.2 Access Control and Account Management
2
23개 하위 문서
8.2.1 Account User Names and Passwords
2
8.2.2 Privileges Provided by MySQL
3
8.2.3 Grant Tables
2
8.2.4 Specifying Account Names
2
8.2.5 Specifying Role Names
2
8.2.6 Access Control, Stage 1: Connection Verification
2
8.2.7 Access Control, Stage 2: Request Verification
3
8.2.8 Adding Accounts, Assigning Privileges, and Dropping Accounts
2
8.2.9 Reserved Accounts
2
8.2.10 Using Roles
2
8.2.11 Account Categories
2
8.2.12 Privilege Restriction Using Partial Revokes
2
8.2.13 When Privilege Changes Take Effect
2
8.2.14 Assigning Account Passwords
2
8.2.15 Password Management
2
8.2.16 Server Handling of Expired Passwords
2
8.2.17 Pluggable Authentication
3
8.2.18 Multifactor Authentication
2
8.2.19 Proxy Users
2
8.2.20 Account Locking
2
8.2.21 Setting Account Resource Limits
3
8.2.22 Troubleshooting Problems Connecting to MySQL
2
8.2.23 SQL-Based Account Activity Auditing
2
8.3 Using Encrypted Connections
2
5개 하위 문서
8.3.1 Configuring MySQL to Use Encrypted Connections
2
8.3.2 Encrypted Connection TLS Protocols and Ciphers
1
8.3.3 Creating SSL and RSA Certificates and Keys
2
8.3.4 Connecting to MySQL Remotely from Windows with SSH
2
8.3.5 Reusing SSL Sessions
2
8.4 Security Components and Plugins
2
8개 하위 문서
8.4.1 Authentication Plugins
2
8.4.2 The Connection Control Component
2
8.4.3 Connection Control Plugins
2
8.4.4 The Password Validation Component
2
8.4.5 The MySQL Keyring
2
8.4.6 MySQL Enterprise Audit
2
8.4.7 The Audit Message Component
2
8.4.8 MySQL Enterprise Firewall
2
8.5 MySQL Enterprise Data Masking
2
3개 하위 문서
8.5.1 Data-Masking Components Versus the Data-Masking Plugin
2
8.5.2 MySQL Enterprise Data Masking Components
2
8.5.3 MySQL Enterprise Data Masking Plugin
3
8.6 MySQL Enterprise Encryption
3
5개 하위 문서
8.6.1 MySQL Enterprise Encryption Installation and Upgrading
2
8.6.2 Configuring MySQL Enterprise Encryption
2
8.6.3 MySQL Enterprise Encryption Usage and Examples
2
8.6.4 MySQL Enterprise Encryption Function Reference
2
8.6.5 MySQL Enterprise Encryption Component Function Descriptions
3
8.7 SELinux
2
6개 하위 문서
8.7.1 Check if SELinux is Enabled
2
8.7.2 Changing the SELinux Mode
2
8.7.3 MySQL Server SELinux Policies
1
8.7.4 SELinux File Context
2
8.7.5 SELinux TCP Port Context
2
8.7.6 Troubleshooting SELinux
3
8.8 FIPS Support
13
9 Backup and Recovery
65
6개 하위 문서
9.1 Backup and Recovery Types
15
9.2 Database Backup Methods
4
9.3 Example Backup and Recovery Strategy
3
3개 하위 문서
9.3.1 Establishing a Backup Policy
3
9.3.2 Using Backups for Recovery
3
9.3.3 Backup Strategy Summary
1
9.4 Using mysqldump for Backups
2
5개 하위 문서
9.4.1 Dumping Data in SQL Format with mysqldump
3
9.4.2 Reloading SQL-Format Backups
2
9.4.3 Dumping Data in Delimited-Text Format with mysqldump
3
9.4.4 Reloading Delimited-Text Format Backups
1
9.4.5 mysqldump Tips
2
9.5 Point-in-Time (Incremental) Recovery
2
2개 하위 문서
9.5.1 Point-in-Time Recovery Using Binary Log
1
9.5.2 Point-in-Time Recovery Using Event Positions
2
9.6 MyISAM Table Maintenance and Crash Recovery
2
5개 하위 문서
9.6.1 Using myisamchk for Crash Recovery
1
9.6.2 How to Check MyISAM Tables for Errors
3
9.6.3 How to Repair MyISAM Tables
3
9.6.4 MyISAM Table Optimization
6
9.6.5 Setting Up a MyISAM Table Maintenance Schedule
22
10 Optimization
74
15개 하위 문서
10.1 Optimization Overview
25
10.2 Optimizing SQL Statements
9
7개 하위 문서
10.2.1 Optimizing SELECT Statements
16
10.2.2 Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions
7
10.2.3 Optimizing INFORMATION_SCHEMA Queries
3
10.2.4 Optimizing Performance Schema Queries
4
10.2.5 Optimizing Data Change Statements
2
10.2.6 Optimizing Database Privileges
2
10.2.7 Other Optimization Tips
2
10.3 Optimization and Indexes
2
14개 하위 문서
10.3.1 How MySQL Uses Indexes
2
10.3.2 Primary Key Optimization
2
10.3.3 SPATIAL Index Optimization
2
10.3.4 Foreign Key Optimization
2
10.3.5 Column Indexes
2
10.3.6 Multiple-Column Indexes
1
10.3.7 Verifying Index Usage
2
10.3.8 InnoDB and MyISAM Index Statistics Collection
2
10.3.9 Comparison of B-Tree and Hash Indexes
2
10.3.10 Use of Index Extensions
2
10.3.11 Optimizer Use of Generated Column Indexes
2
10.3.12 Invisible Indexes
3
10.3.13 Descending Indexes
2
10.3.14 Indexed Lookups from TIMESTAMP Columns
2
10.4 Optimizing Database Structure
2
7개 하위 문서
10.4.1 Optimizing Data Size
2
10.4.2 Optimizing MySQL Data Types
2
10.4.3 Optimizing for Many Tables
2
10.4.4 Internal Temporary Table Use in MySQL
2
10.4.5 Limits on Number of Databases and Tables
3
10.4.6 Limits on Table Size
2
10.4.7 Limits on Table Column Count and Row Size
2
10.5 Optimizing for InnoDB Tables
1
10개 하위 문서
10.5.1 Optimizing Storage Layout for InnoDB Tables
2
10.5.2 Optimizing InnoDB Transaction Management
2
10.5.3 Optimizing InnoDB Read-Only Transactions
2
10.5.4 Optimizing InnoDB Redo Logging
1
10.5.5 Bulk Data Loading for InnoDB Tables
2
10.5.6 Optimizing InnoDB Queries
2
10.5.7 Optimizing InnoDB DDL Operations
2
10.5.8 Optimizing InnoDB Disk I/O
2
10.5.9 Optimizing InnoDB Configuration Variables
2
10.5.10 Optimizing InnoDB for Systems with Many Tables
2
10.6 Optimizing for MyISAM Tables
2
3개 하위 문서
10.6.1 Optimizing MyISAM Queries
2
10.6.2 Bulk Data Loading for MyISAM Tables
3
10.6.3 Optimizing REPAIR TABLE Statements
2
10.7 Optimizing for MEMORY Tables
1
10.8 Understanding the Query Execution Plan
2
5개 하위 문서
10.8.1 Optimizing Queries with EXPLAIN
3
10.8.2 EXPLAIN Output Format
4
10.8.3 Extended EXPLAIN Output Format
4
10.8.4 Obtaining Execution Plan Information for a Named Connection
3
10.8.5 Estimating Query Performance
2
10.9 Controlling the Query Optimizer
1
6개 하위 문서
10.9.1 Controlling Query Plan Evaluation
2
10.9.2 Switchable Optimizations
2
10.9.3 Optimizer Hints
2
10.9.4 Index Hints
2
10.9.5 The Optimizer Cost Model
2
10.9.6 Optimizer Statistics
2
10.10 Buffering and Caching
3
3개 하위 문서
10.10.1 InnoDB Buffer Pool Optimization
3
10.10.2 The MyISAM Key Cache
2
10.10.3 Caching of Prepared Statements and Stored Programs
2
10.11 Optimizing Locking Operations
2
5개 하위 문서
10.11.1 Internal Locking Methods
2
10.11.2 Table Locking Issues
1
10.11.3 Concurrent Inserts
2
10.11.4 Metadata Locking
2
10.11.5 External Locking
2
10.12 Optimizing the MySQL Server
2
3개 하위 문서
10.12.1 Optimizing Disk I/O
3
10.12.2 Using Symbolic Links
1
10.12.3 Optimizing Memory Use
2
10.13 Measuring Performance (Benchmarking)
2
3개 하위 문서
10.13.1 Measuring the Speed of Expressions and Functions
2
10.13.2 Using Your Own Benchmarks
3
10.13.3 Measuring Performance with performance_schema
3
10.14 Examining Server Thread (Process) Information
2
9개 하위 문서
10.14.1 Accessing the Process List
2
10.14.2 Thread Command Values
2
10.14.3 General Thread States
2
10.14.4 Replication Source Thread States
1
10.14.5 Replication I/O (Receiver) Thread States
2
10.14.6 Replication SQL Thread States
2
10.14.7 Replication Connection Thread States
3
10.14.8 NDB Cluster Thread States
2
10.14.9 Event Scheduler Thread States
2
10.15 Tracing the Optimizer
3
16개 하위 문서
10.15.1 Typical Usage
2
10.15.2 System Variables Controlling Tracing
1
10.15.3 Traceable Statements
2
10.15.4 Tuning Trace Purging
2
10.15.5 Tracing Memory Usage
2
10.15.6 Privilege Checking
1
10.15.7 Interaction with the --debug Option
2
10.15.8 The optimizer_trace System Variable
3
10.15.9 The end_markers_in_json System Variable
2
10.15.10 Selecting Optimizer Features to Trace
2
10.15.11 Trace General Structure
3
10.15.12 Example
2
10.15.13 Displaying Traces in Other Applications
3
10.15.14 Preventing the Use of Optimizer Trace
2
10.15.15 Testing Optimizer Trace
4
10.15.16 Optimizer Trace Implementation
17
11 Language Structure
65
7개 하위 문서
11.1 Literal Values
19
7개 하위 문서
11.1.1 String Literals
7
11.1.2 Numeric Literals
3
11.1.3 Date and Time Literals
4
11.1.4 Hexadecimal Literals
3
11.1.5 Bit-Value Literals
3
11.1.6 Boolean Literals
3
11.1.7 NULL Values
3
11.2 Schema Object Names
3
5개 하위 문서
11.2.1 Identifier Length Limits
2
11.2.2 Identifier Qualifiers
2
11.2.3 Identifier Case Sensitivity
1
11.2.4 Mapping of Identifiers to File Names
2
11.2.5 Function Name Parsing and Resolution
2
11.3 Keywords and Reserved Words
2
11.4 User-Defined Variables
2
11.5 Expressions
3
11.6 Query Attributes
5
11.7 Comments
22
12 Character Sets, Collations, Unicode
64
16개 하위 문서
12.1 Character Sets and Collations in General
21
12.2 Character Sets and Collations in MySQL
1
2개 하위 문서
12.2.1 Character Set Repertoire
2
12.2.2 UTF-8 for Metadata
2
12.3 Specifying Character Sets and Collations
2
10개 하위 문서
12.3.1 Collation Naming Conventions
2
12.3.2 Server Character Set and Collation
2
12.3.3 Database Character Set and Collation
2
12.3.4 Table Character Set and Collation
6
12.3.5 Column Character Set and Collation
2
12.3.6 Character String Literal Character Set and Collation
3
12.3.7 The National Character Set
2
12.3.8 Character Set Introducers
3
12.3.9 Examples of Character Set and Collation Assignment
2
12.3.10 Compatibility with Other DBMSs
2
12.4 Connection Character Sets and Collations
3
12.5 Configuring Application Character Set and Collation
2
12.6 Error Message Character Set
2
12.7 Column Character Set Conversion
2
12.8 Collation Issues
2
7개 하위 문서
12.8.1 Using COLLATE in SQL Statements
2
12.8.2 COLLATE Clause Precedence
2
12.8.3 Character Set and Collation Compatibility
2
12.8.4 Collation Coercibility in Expressions
2
12.8.5 The binary Collation Compared to _bin Collations
2
12.8.6 Examples of the Effect of Collation
2
12.8.7 Using Collation in INFORMATION_SCHEMA Searches
3
12.9 Unicode Support
2
8개 하위 문서
12.9.1 The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)
2
12.9.2 The utf8mb3 Character Set (3-Byte UTF-8 Unicode Encoding)
2
12.9.3 The utf8 Character Set (Deprecated alias for utf8mb3)
2
12.9.4 The ucs2 Character Set (UCS-2 Unicode Encoding)
4
12.9.5 The utf16 Character Set (UTF-16 Unicode Encoding)
1
12.9.6 The utf16le Character Set (UTF-16LE Unicode Encoding)
2
12.9.7 The utf32 Character Set (UTF-32 Unicode Encoding)
2
12.9.8 Converting Between 3-Byte and 4-Byte Unicode Character Sets
2
12.10 Supported Character Sets and Collations
2
8개 하위 문서
12.10.1 Unicode Character Sets
3
12.10.2 West European Character Sets
2
12.10.3 Central European Character Sets
3
12.10.4 South European and Middle East Character Sets
2
12.10.5 Baltic Character Sets
3
12.10.6 Cyrillic Character Sets
1
12.10.7 Asian Character Sets
2
12.10.8 The Binary Character Set
2
12.11 Restrictions on Character Sets
3
12.12 Setting the Error Message Language
2
12.13 Adding a Character Set
2
3개 하위 문서
12.13.1 Character Definition Arrays
2
12.13.2 String Collating Support for Complex Character Sets
3
12.13.3 Multi-Byte Character Support for Complex Character Sets
2
12.14 Adding a Collation to a Character Set
3
4개 하위 문서
12.14.1 Collation Implementation Types
2
12.14.2 Choosing a Collation ID
2
12.14.3 Adding a Simple Collation to an 8-Bit Character Set
2
12.14.4 Adding a UCA Collation to a Unicode Character Set
2
12.15 Character Set Configuration
2
12.16 MySQL Server Locale Support
16
13 Data Types
64
9개 하위 문서
13.1 Numeric Data Types
17
7개 하위 문서
13.1.1 Numeric Data Type Syntax
4
13.1.2 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT
2
13.1.3 Fixed-Point Types (Exact Value) - DECIMAL, NUMERIC
2
13.1.4 Floating-Point Types (Approximate Value) - FLOAT, DOUBLE
2
13.1.5 Bit-Value Type - BIT
2
13.1.6 Numeric Type Attributes
1
13.1.7 Out-of-Range and Overflow Handling
2
13.2 Date and Time Data Types
2
9개 하위 문서
13.2.1 Date and Time Data Type Syntax
2
13.2.2 The DATE, DATETIME, and TIMESTAMP Types
3
13.2.3 The TIME Type
2
13.2.4 The YEAR Type
2
13.2.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME
3
13.2.6 Fractional Seconds in Time Values
1
13.2.7 What Calendar Is Used By MySQL?
2
13.2.8 Conversion Between Date and Time Types
2
13.2.9 2-Digit Years in Dates
2
13.3 String Data Types
2
7개 하위 문서
13.3.1 String Data Type Syntax
3
13.3.2 The CHAR and VARCHAR Types
3
13.3.3 The BINARY and VARBINARY Types
3
13.3.4 The BLOB and TEXT Types
3
13.3.5 The VECTOR Type
2
13.3.6 The ENUM Type
3
13.3.7 The SET Type
3
13.4 Spatial Data Types
2
11개 하위 문서
13.4.1 Spatial Data Types
1
13.4.2 The OpenGIS Geometry Model
1
13.4.3 Supported Spatial Data Formats
2
13.4.4 Geometry Well-Formedness and Validity
1
13.4.5 Spatial Reference System Support
1
13.4.6 Creating Spatial Columns
3
13.4.7 Populating Spatial Columns
1
13.4.8 Fetching Spatial Data
2
13.4.9 Optimizing Spatial Analysis
3
13.4.10 Creating Spatial Indexes
2
13.4.11 Using Spatial Indexes
2
13.5 The JSON Data Type
3
13.6 Data Type Default Values
2
13.7 Data Type Storage Requirements
3
13.8 Choosing the Right Type for a Column
8
13.9 Using Data Types from Other Database Engines
29
14 Functions and Operators
72
25개 하위 문서
14.1 Built-In Function and Operator Reference
27
14.2 Loadable Function Reference
7
14.3 Type Conversion in Expression Evaluation
2
14.4 Operators
2
4개 하위 문서
14.4.1 Operator Precedence
2
14.4.2 Comparison Functions and Operators
3
14.4.3 Logical Operators
2
14.4.4 Assignment Operators
1
14.5 Flow Control Functions
3
14.6 Numeric Functions and Operators
2
2개 하위 문서
14.6.1 Arithmetic Operators
2
14.6.2 Mathematical Functions
2
14.7 Date and Time Functions
1
14.8 String Functions and Operators
2
3개 하위 문서
14.8.1 String Comparison Functions and Operators
2
14.8.2 Regular Expressions
1
14.8.3 Character Set and Collation of Function Results
2
14.9 Full-Text Search Functions
3
9개 하위 문서
14.9.1 Natural Language Full-Text Searches
2
14.9.2 Boolean Full-Text Searches
2
14.9.3 Full-Text Searches with Query Expansion
6
14.9.4 Full-Text Stopwords
2
14.9.5 Full-Text Restrictions
2
14.9.6 Fine-Tuning MySQL Full-Text Search
2
14.9.7 Adding a User-Defined Collation for Full-Text Indexing
2
14.9.8 ngram Full-Text Parser
2
14.9.9 MeCab Full-Text Parser Plugin
2
14.10 Cast Functions and Operators
2
14.11 XML Functions
2
14.12 Bit Functions and Operators
2
14.13 Encryption and Compression Functions
3
14.14 Locking Functions
2
14.15 Information Functions
3
14.16 Spatial Analysis Functions
3
13개 하위 문서
14.16.1 Spatial Function Reference
2
14.16.2 Argument Handling by Spatial Functions
2
14.16.3 Functions That Create Geometry Values from WKT Values
2
14.16.4 Functions That Create Geometry Values from WKB Values
2
14.16.5 MySQL-Specific Functions That Create Geometry Values
2
14.16.6 Geometry Format Conversion Functions
2
14.16.7 Geometry Property Functions
2
14.16.8 Spatial Operator Functions
3
14.16.9 Functions That Test Spatial Relations Between Geometry Objects
2
14.16.10 Spatial Geohash Functions
2
14.16.11 Spatial GeoJSON Functions
2
14.16.12 Spatial Aggregate Functions
2
14.16.13 Spatial Convenience Functions
3
14.17 JSON Functions
2
8개 하위 문서
14.17.1 JSON Function Reference
2
14.17.2 Functions That Create JSON Values
2
14.17.3 Functions That Search JSON Values
2
14.17.4 Functions That Modify JSON Values
2
14.17.5 Functions That Return JSON Value Attributes
2
14.17.6 JSON Table Functions
3
14.17.7 JSON Schema Validation Functions
3
14.17.8 JSON Utility Functions
2
14.18 Replication Functions
2
4개 하위 문서
14.18.1 Group Replication Functions
2
14.18.2 Functions Used with Global Transaction Identifiers (GTIDs)
3
14.18.3 Asynchronous Replication Channel Failover Functions
2
14.18.4 Position-Based Synchronization Functions
2
14.19 Aggregate Functions
2
4개 하위 문서
14.19.1 Aggregate Function Descriptions
2
14.19.2 GROUP BY Modifiers
3
14.19.3 MySQL Handling of GROUP BY
2
14.19.4 Detection of Functional Dependence
2
14.20 Window Functions
2
5개 하위 문서
14.20.1 Window Function Descriptions
2
14.20.2 Window Function Concepts and Syntax
2
14.20.3 Window Function Frame Specification
2
14.20.4 Named Windows
2
14.20.5 Window Function Restrictions
2
14.21 Vector Functions
2
14.22 Performance Schema Functions
2
14.23 Internal Functions
2
14.24 Miscellaneous Functions
2
14.25 Precision Math
2
5개 하위 문서
14.25.1 Types of Numeric Values
2
14.25.2 DECIMAL Data Type Characteristics
2
14.25.3 Expression Handling
2
14.25.4 Rounding Behavior
3
14.25.5 Precision Math Examples
19
15 SQL Statements
54
8개 하위 문서
15.1 Data Definition Statements
21
42개 하위 문서
15.1.1 Atomic Data Definition Statement Support
3
15.1.2 ALTER DATABASE Statement
3
15.1.3 ALTER EVENT Statement
2
15.1.4 ALTER FUNCTION Statement
2
15.1.5 ALTER INSTANCE Statement
2
15.1.6 ALTER JSON DUALITY VIEW Statement
2
15.1.7 ALTER LIBRARY Statement
3
15.1.8 ALTER LOGFILE GROUP Statement
2
15.1.9 ALTER PROCEDURE Statement
2
15.1.10 ALTER SERVER Statement
2
15.1.11 ALTER TABLE Statement
2
15.1.12 ALTER TABLESPACE Statement
2
15.1.13 ALTER VIEW Statement
2
15.1.14 CREATE DATABASE Statement
2
15.1.15 CREATE EVENT Statement
2
15.1.16 CREATE FUNCTION Statement
2
15.1.17 CREATE JSON DUALITY VIEW Statement
2
15.1.18 CREATE INDEX Statement
2
15.1.19 CREATE LIBRARY Statement
2
15.1.20 CREATE LOGFILE GROUP Statement
2
15.1.21 CREATE PROCEDURE and CREATE FUNCTION Statements
2
15.1.22 CREATE SERVER Statement
2
15.1.23 CREATE SPATIAL REFERENCE SYSTEM Statement
2
15.1.24 CREATE TABLE Statement
3
15.1.25 CREATE TABLESPACE Statement
3
15.1.26 CREATE TRIGGER Statement
2
15.1.27 CREATE VIEW Statement
3
15.1.28 DROP DATABASE Statement
2
15.1.29 DROP EVENT Statement
2
15.1.30 DROP FUNCTION Statement
3
15.1.31 DROP INDEX Statement
2
15.1.32 DROP LIBRARY Statement
2
15.1.33 DROP LOGFILE GROUP Statement
2
15.1.34 DROP PROCEDURE and DROP FUNCTION Statements
2
15.1.35 DROP SERVER Statement
2
15.1.36 DROP SPATIAL REFERENCE SYSTEM Statement
3
15.1.37 DROP TABLE Statement
2
15.1.38 DROP TABLESPACE Statement
3
15.1.39 DROP TRIGGER Statement
2
15.1.40 DROP VIEW Statement
3
15.1.41 RENAME TABLE Statement
2
15.1.42 TRUNCATE TABLE Statement
2
15.2 Data Manipulation Statements
3
20개 하위 문서
15.2.1 CALL Statement
3
15.2.2 DELETE Statement
3
15.2.3 DO Statement
2
15.2.4 EXCEPT Clause
3
15.2.5 HANDLER Statement
3
15.2.6 IMPORT TABLE Statement
2
15.2.7 INSERT Statement
2
15.2.8 INTERSECT Clause
2
15.2.9 LOAD DATA Statement
2
15.2.10 LOAD XML Statement
1
15.2.11 Parenthesized Query Expressions
2
15.2.12 REPLACE Statement
2
15.2.13 SELECT Statement
3
15.2.14 Set Operations with UNION, INTERSECT, and EXCEPT
3
15.2.15 Subqueries
3
15.2.16 TABLE Statement
3
15.2.17 UPDATE Statement
3
15.2.18 UNION Clause
2
15.2.19 VALUES Statement
3
15.2.20 WITH (Common Table Expressions)
3
15.3 Transactional and Locking Statements
4
8개 하위 문서
15.3.1 START TRANSACTION, COMMIT, and ROLLBACK Statements
3
15.3.2 Statements That Cannot Be Rolled Back
2
15.3.3 Statements That Cause an Implicit Commit
2
15.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements
2
15.3.5 LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements
2
15.3.6 LOCK TABLES and UNLOCK TABLES Statements
2
15.3.7 SET TRANSACTION Statement
3
15.3.8 XA Transactions
2
15.4 Replication Statements
2
3개 하위 문서
15.4.1 SQL Statements for Controlling Source Servers
3
15.4.2 SQL Statements for Controlling Replica Servers
1
15.4.3 SQL Statements for Controlling Group Replication
2
15.5 Prepared Statements
2
3개 하위 문서
15.5.1 PREPARE Statement
3
15.5.2 EXECUTE Statement
2
15.5.3 DEALLOCATE PREPARE Statement
3
15.6 Compound Statement Syntax
4
8개 하위 문서
15.6.1 BEGIN ... END Compound Statement
4
15.6.2 Statement Labels
3
15.6.3 DECLARE Statement
3
15.6.4 Variables in Stored Programs
2
15.6.5 Flow Control Statements
2
15.6.6 Cursors
1
15.6.7 Condition Handling
2
15.6.8 Restrictions on Condition Handling
2
15.7 Database Administration Statements
2
8개 하위 문서
15.7.1 Account Management Statements
2
15.7.2 Resource Group Management Statements
2
15.7.3 Table Maintenance Statements
3
15.7.4 Component, Plugin, and Loadable Function Statements
2
15.7.5 CLONE Statement
2
15.7.6 SET Statements
2
15.7.7 SHOW Statements
2
15.7.8 Other Administrative Statements
2
15.8 Utility Statements
3
4개 하위 문서
15.8.1 DESCRIBE Statement
3
15.8.2 EXPLAIN Statement
4
15.8.3 HELP Statement
8
15.8.4 USE Statement
16
16 MySQL Data Dictionary
63
8개 하위 문서
16.1 Data Dictionary Schema
16
16.2 Removal of File-based Metadata Storage
4
16.3 Transactional Storage of Dictionary Data
3
16.4 Dictionary Object Cache
2
16.5 INFORMATION_SCHEMA and Data Dictionary Integration
3
16.6 Serialized Dictionary Information (SDI)
3
16.7 Data Dictionary Usage Differences
2
16.8 Data Dictionary Limitations
14
17 The InnoDB Storage Engine
61
22개 하위 문서
17.1 Introduction to InnoDB
15
4개 하위 문서
17.1.1 Benefits of Using InnoDB Tables
5
17.1.2 Best Practices for InnoDB Tables
2
17.1.3 Verifying that InnoDB is the Default Storage Engine
3
17.1.4 Testing and Benchmarking with InnoDB
2
17.2 InnoDB and the ACID Model
2
17.3 InnoDB Multi-Versioning
2
17.4 InnoDB Architecture
2
17.5 InnoDB In-Memory Structures
3
4개 하위 문서
17.5.1 Buffer Pool
4
17.5.2 Change Buffer
3
17.5.3 Adaptive Hash Index
4
17.5.4 Log Buffer
3
17.6 InnoDB On-Disk Structures
3
6개 하위 문서
17.6.1 Tables
3
17.6.2 Indexes
3
17.6.3 Tablespaces
3
17.6.4 Doublewrite Buffer
3
17.6.5 Redo Log
3
17.6.6 Undo Logs
3
17.7 InnoDB Locking and Transaction Model
2
6개 하위 문서
17.7.1 InnoDB Locking
4
17.7.2 InnoDB Transaction Model
2
17.7.3 Locks Set by Different SQL Statements in InnoDB
8
17.7.4 Phantom Rows
2
17.7.5 Deadlocks in InnoDB
2
17.7.6 Transaction Scheduling
3
17.8 InnoDB Configuration
2
13개 하위 문서
17.8.1 InnoDB Startup Configuration
2
17.8.2 Configuring InnoDB for Read-Only Operation
2
17.8.3 InnoDB Buffer Pool Configuration
3
17.8.4 Configuring Thread Concurrency for InnoDB
2
17.8.5 Configuring the Number of Background InnoDB I/O Threads
2
17.8.6 Using Asynchronous I/O on Linux
2
17.8.7 Configuring InnoDB I/O Capacity
2
17.8.8 Configuring Spin Lock Polling
2
17.8.9 Purge Configuration
2
17.8.10 Configuring Optimizer Statistics for InnoDB
2
17.8.11 Configuring the Merge Threshold for Index Pages
2
17.8.12 Container Detection and Configuration
2
17.8.13 Enabling Automatic InnoDB Configuration for a Dedicated MySQL Server
2
17.9 InnoDB Table and Page Compression
2
2개 하위 문서
17.9.1 InnoDB Table Compression
2
17.9.2 InnoDB Page Compression
3
17.10 InnoDB Row Formats
2
17.11 InnoDB Disk I/O and File Space Management
2
5개 하위 문서
17.11.1 InnoDB Disk I/O
2
17.11.2 File Space Management
2
17.11.3 InnoDB Checkpoints
2
17.11.4 Defragmenting a Table
2
17.11.5 Reclaiming Disk Space with TRUNCATE TABLE
1
17.12 InnoDB and Online DDL
2
8개 하위 문서
17.12.1 Online DDL Operations
2
17.12.2 Online DDL Performance and Concurrency
2
17.12.3 Online DDL Space Requirements
2
17.12.4 Online DDL Memory Management
2
17.12.5 Configuring Parallel Threads for Online DDL Operations
3
17.12.6 Simplifying DDL Statements with Online DDL
2
17.12.7 Online DDL Failure Conditions
1
17.12.8 Online DDL Limitations
2
17.13 InnoDB Data-at-Rest Encryption
3
17.14 InnoDB Startup Options and System Variables
2
17.15 InnoDB INFORMATION_SCHEMA Tables
1
8개 하위 문서
17.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression
2
17.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information
2
17.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables
2
17.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
2
17.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables
2
17.15.6 InnoDB INFORMATION_SCHEMA Metrics Table
2
17.15.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table
2
17.15.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES
2
17.16 InnoDB Integration with MySQL Performance Schema
2
2개 하위 문서
17.16.1 Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema
2
17.16.2 Monitoring InnoDB Mutex Waits Using Performance Schema
2
17.17 InnoDB Monitors
1
3개 하위 문서
17.17.1 InnoDB Monitor Types
2
17.17.2 Enabling InnoDB Monitors
2
17.17.3 InnoDB Standard Monitor and Lock Monitor Output
1
17.18 InnoDB Backup and Recovery
2
2개 하위 문서
17.18.1 InnoDB Backup
2
17.18.2 InnoDB Recovery
2
17.19 InnoDB and MySQL Replication
1
17.20 InnoDB Troubleshooting
2
5개 하위 문서
17.20.1 Troubleshooting InnoDB I/O Problems
2
17.20.2 Troubleshooting Recovery Failures
2
17.20.3 Forcing InnoDB Recovery
2
17.20.4 Troubleshooting InnoDB Data Dictionary Operations
2
17.20.5 InnoDB Error Handling
3
17.21 InnoDB Limits
5
17.22 InnoDB Restrictions and Limitations
19
18 Alternative Storage Engines
66
11개 하위 문서
18.1 Setting the Storage Engine
19
18.2 The MyISAM Storage Engine
6
4개 하위 문서
18.2.1 MyISAM Startup Options
2
18.2.2 Space Needed for Keys
2
18.2.3 MyISAM Table Storage Formats
2
18.2.4 MyISAM Table Problems
2
18.3 The MEMORY Storage Engine
7
18.4 The CSV Storage Engine
2
2개 하위 문서
18.4.1 Repairing and Checking CSV Tables
2
18.4.2 CSV Limitations
3
18.5 The ARCHIVE Storage Engine
2
18.6 The BLACKHOLE Storage Engine
3
18.7 The MERGE Storage Engine
2
2개 하위 문서
18.7.1 MERGE Table Advantages and Disadvantages
2
18.7.2 MERGE Table Problems
2
18.8 The FEDERATED Storage Engine
2
4개 하위 문서
18.8.1 FEDERATED Storage Engine Overview
2
18.8.2 How to Create FEDERATED Tables
2
18.8.3 FEDERATED Storage Engine Notes and Tips
2
18.8.4 FEDERATED Storage Engine Resources
2
18.9 The EXAMPLE Storage Engine
2
18.10 Other Storage Engines
2
18.11 Overview of MySQL Storage Engine Architecture
2
2개 하위 문서
18.11.1 Pluggable Storage Engine Architecture
2
18.11.2 The Common Database Server Layer
18
19 Replication
59
5개 하위 문서
19.1 Configuring Replication
18
7개 하위 문서
19.1.1 Binary Log File Position Based Replication Configuration Overview
4
19.1.2 Setting Up Binary Log File Position Based Replication
2
19.1.3 Replication with Global Transaction Identifiers
2
19.1.4 Changing GTID Mode on Online Servers
2
19.1.5 MySQL Multi-Source Replication
2
19.1.6 Replication and Binary Logging Options and Variables
3
19.1.7 Common Replication Administration Tasks
2
19.2 Replication Implementation
3
5개 하위 문서
19.2.1 Replication Formats
2
19.2.2 Replication Channels
2
19.2.3 Replication Threads
2
19.2.4 Relay Log and Replication Metadata Repositories
2
19.2.5 How Servers Evaluate Replication Filtering Rules
3
19.3 Replication Security
3
3개 하위 문서
19.3.1 Setting Up Replication to Use Encrypted Connections
2
19.3.2 Encrypting Binary Log Files and Relay Log Files
2
19.3.3 Replication Privilege Checks
2
19.4 Replication Solutions
2
11개 하위 문서
19.4.1 Using Replication for Backups
2
19.4.2 Handling an Unexpected Halt of a Replica
2
19.4.3 Monitoring Row-based Replication
2
19.4.4 Using Replication with Different Source and Replica Storage Engines
2
19.4.5 Using Replication for Scale-Out
1
19.4.6 Replicating Different Databases to Different Replicas
3
19.4.7 Improving Replication Performance
2
19.4.8 Switching Sources During Failover
2
19.4.9 Switching Sources and Replicas with Asynchronous Connection Failover
2
19.4.10 Semisynchronous Replication
2
19.4.11 Delayed Replication
2
19.5 Replication Notes and Tips
1
5개 하위 문서
19.5.1 Replication Features and Issues
2
19.5.2 Replication Compatibility Between MySQL Versions
3
19.5.3 Upgrading or Downgrading a Replication Topology
3
19.5.4 Troubleshooting Replication
7
19.5.5 How to Report Replication Bugs or Problems
21
20 Group Replication
57
10개 하위 문서
20.1 Group Replication Background
20
5개 하위 문서
20.1.1 Replication Technologies
4
20.1.2 Group Replication Use Cases
2
20.1.3 Multi-Primary and Single-Primary Modes
2
20.1.4 Group Replication Services
2
20.1.5 Group Replication Plugin Architecture
2
20.2 Getting Started
2
2개 하위 문서
20.2.1 Deploying Group Replication in Single-Primary Mode
2
20.2.2 Deploying Group Replication Locally
2
20.3 Requirements and Limitations
2
2개 하위 문서
20.3.1 Group Replication Requirements
2
20.3.2 Group Replication Limitations
2
20.4 Monitoring Group Replication
2
4개 하위 문서
20.4.1 GTIDs and Group Replication
2
20.4.2 Group Replication Server States
2
20.4.3 The replication_group_members Table
3
20.4.4 The replication_group_member_stats Table
1
20.5 Group Replication Operations
3
6개 하위 문서
20.5.1 Configuring an Online Group
2
20.5.2 Restarting a Group
2
20.5.3 Transaction Consistency Guarantees
2
20.5.4 Distributed Recovery
1
20.5.5 Support For IPv6 And For Mixed IPv6 And IPv4 Groups
3
20.5.6 Using MySQL Enterprise Backup with Group Replication
3
20.6 Group Replication Security
2
4개 하위 문서
20.6.1 Communication Stack for Connection Security Management
2
20.6.2 Securing Group Communication Connections with Secure Socket Layer (SSL)
2
20.6.3 Securing Distributed Recovery Connections
2
20.6.4 Group Replication IP Address Permissions
2
20.7 Group Replication Performance and Troubleshooting
1
9개 하위 문서
20.7.1 Fine Tuning the Group Communication Thread
3
20.7.2 Flow Control
2
20.7.3 Single Consensus Leader
2
20.7.4 Message Compression
2
20.7.5 Message Fragmentation
1
20.7.6 XCom Cache Management
3
20.7.7 Responses to Failure Detection and Network Partitioning
2
20.7.8 Handling a Network Partition and Loss of Quorum
2
20.7.9 Monitoring Group Replication Memory Usage with Performance Schema Memory Instrumentation
2
20.8 Upgrading Group Replication
3
3개 하위 문서
20.8.1 Combining Different Member Versions in a Group
2
20.8.2 Group Replication Offline Upgrade
3
20.8.3 Group Replication Online Upgrade
2
20.9 Group Replication Variables
3
2개 하위 문서
20.9.1 Group Replication System Variables
2
20.9.2 Group Replication Status Variables
6
20.10 Frequently Asked Questions
23
21 MySQL Shell
75
22 Using MySQL as a Document Store
69
5개 하위 문서
22.1 Interfaces to a MySQL Document Store
30
22.2 Document Store Concepts
6
22.3 JavaScript Quick-Start Guide: MySQL Shell for Document Store
4
5개 하위 문서
22.3.1 MySQL Shell
2
22.3.2 Download and Import world_x Database
3
22.3.3 Documents and Collections
3
22.3.4 Relational Tables
2
22.3.5 Documents in Tables
2
22.4 Python Quick-Start Guide: MySQL Shell for Document Store
1
5개 하위 문서
22.4.1 MySQL Shell
2
22.4.2 Download and Import world_x Database
2
22.4.3 Documents and Collections
2
22.4.4 Relational Tables
2
22.4.5 Documents in Tables
2
22.5 X Plugin
2
7개 하위 문서
22.5.1 Checking X Plugin Installation
2
22.5.2 Disabling X Plugin
2
22.5.3 Using Encrypted Connections with X Plugin
2
22.5.4 Using X Plugin with the Caching SHA-2 Authentication Plugin
2
22.5.5 Connection Compression with X Plugin
3
22.5.6 X Plugin Options and Variables
7
22.5.7 Monitoring X Plugin
22
23 InnoDB Cluster
68
24 InnoDB ReplicaSet
76
25 MySQL NDB Cluster 9.5
76
8개 하위 문서
25.1 General Information
18
25.2 NDB Cluster Overview
6
7개 하위 문서
25.2.1 NDB Cluster Core Concepts
4
25.2.2 NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions
3
25.2.3 NDB Cluster Hardware, Software, and Networking Requirements
3
25.2.4 What is New in MySQL NDB Cluster 9.5
5
25.2.5 Options, Variables, and Parameters Added, Deprecated or Removed in NDB 9.5
1
25.2.6 MySQL Server Using InnoDB Compared with NDB Cluster
2
25.2.7 Known Limitations of NDB Cluster
2
25.3 NDB Cluster Installation
2
7개 하위 문서
25.3.1 Installation of NDB Cluster on Linux
2
25.3.2 Installing NDB Cluster on Windows
2
25.3.3 Initial Configuration of NDB Cluster
2
25.3.4 Initial Startup of NDB Cluster
2
25.3.5 NDB Cluster Example with Tables and Data
2
25.3.6 Safe Shutdown and Restart of NDB Cluster
2
25.3.7 Upgrading and Downgrading NDB Cluster
2
25.4 Configuration of NDB Cluster
2
4개 하위 문서
25.4.1 Quick Test Setup of NDB Cluster
2
25.4.2 Overview of NDB Cluster Configuration Parameters, Options, and Variables
2
25.4.3 NDB Cluster Configuration Files
3
25.4.4 Using High-Speed Interconnects with NDB Cluster
2
25.5 NDB Cluster Programs
2
32개 하위 문서
25.5.1 ndbd — The NDB Cluster Data Node Daemon
2
25.5.2 ndbinfo_select_all — Select From ndbinfo Tables
2
25.5.3 ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)
2
25.5.4 ndb_mgmd — The NDB Cluster Management Server Daemon
2
25.5.5 ndb_mgm — The NDB Cluster Management Client
2
25.5.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables
2
25.5.7 ndb_config — Extract NDB Cluster Configuration Information
2
25.5.8 ndb_delete_all — Delete All Rows from an NDB Table
2
25.5.9 ndb_desc — Describe NDB Tables
2
25.5.10 ndb_drop_index — Drop Index from an NDB Table
3
25.5.11 ndb_drop_table — Drop an NDB Table
2
25.5.12 ndb_error_reporter — NDB Error-Reporting Utility
2
25.5.13 ndb_import — Import CSV Data Into NDB
2
25.5.14 ndb_index_stat — NDB Index Statistics Utility
3
25.5.15 ndb_move_data — NDB Data Copy Utility
2
25.5.16 ndb_perror — Obtain NDB Error Message Information
3
25.5.17 ndb_print_backup_file — Print NDB Backup File Contents
2
25.5.18 ndb_print_file — Print NDB Disk Data File Contents
3
25.5.19 ndb_print_frag_file — Print NDB Fragment List File Contents
2
25.5.20 ndb_print_schema_file — Print NDB Schema File Contents
2
25.5.21 ndb_print_sys_file — Print NDB System File Contents
2
25.5.22 ndb_redo_log_reader — Check and Print Content of Cluster Redo Log
1
25.5.23 ndb_restore — Restore an NDB Cluster Backup
2
25.5.24 ndb_secretsfile_reader — Obtain Key Information from an Encrypted NDB Data File
3
25.5.25 ndb_select_all — Print Rows from an NDB Table
2
25.5.26 ndb_select_count — Print Row Counts for NDB Tables
2
25.5.27 ndb_show_tables — Display List of NDB Tables
1
25.5.28 ndb_sign_keys — Create, Sign, and Manage TLS Keys and Certificates for NDB Cluster
2
25.5.29 ndb_size.pl — NDBCLUSTER Size Requirement Estimator
2
25.5.30 ndb_top — View CPU usage information for NDB threads
2
25.5.31 ndb_waiter — Wait for NDB Cluster to Reach a Given Status
2
25.5.32 ndbxfrm — Compress, Decompress, Encrypt, and Decrypt Files Created by NDB Cluster
2
25.6 Management of NDB Cluster
2
19개 하위 문서
25.6.1 Commands in the NDB Cluster Management Client
2
25.6.2 NDB Cluster Log Messages
2
25.6.3 Event Reports Generated in NDB Cluster
2
25.6.4 Summary of NDB Cluster Start Phases
2
25.6.5 Performing a Rolling Restart of an NDB Cluster
1
25.6.6 NDB Cluster Single User Mode
2
25.6.7 Adding NDB Cluster Data Nodes Online
2
25.6.8 Online Backup of NDB Cluster
2
25.6.9 Importing Data Into MySQL Cluster
2
25.6.10 MySQL Server Usage for NDB Cluster
2
25.6.11 NDB Cluster Disk Data Tables
2
25.6.12 Online Operations with ALTER TABLE in NDB Cluster
3
25.6.13 Privilege Synchronization and NDB_STORED_USER
2
25.6.14 NDB API Statistics Counters and Variables
2
25.6.15 ndbinfo: The NDB Cluster Information Database
2
25.6.16 INFORMATION_SCHEMA Tables for NDB Cluster
2
25.6.17 NDB Cluster and the Performance Schema
1
25.6.18 Quick Reference: NDB Cluster SQL Statements
2
25.6.19 NDB Cluster Security
1
25.7 NDB Cluster Replication
2
12개 하위 문서
25.7.1 NDB Cluster Replication: Abbreviations and Symbols
3
25.7.2 General Requirements for NDB Cluster Replication
2
25.7.3 Known Issues in NDB Cluster Replication
3
25.7.4 NDB Cluster Replication Schema and Tables
2
25.7.5 Preparing the NDB Cluster for Replication
2
25.7.6 Starting NDB Cluster Replication (Single Replication Channel)
2
25.7.7 Using Two Replication Channels for NDB Cluster Replication
3
25.7.8 Implementing Failover with NDB Cluster Replication
2
25.7.9 NDB Cluster Backups With NDB Cluster Replication
2
25.7.10 NDB Cluster Replication: Bidirectional and Circular Replication
2
25.7.11 NDB Cluster Replication Using the Multithreaded Applier
3
25.7.12 NDB Cluster Replication Conflict Resolution
4
25.8 NDB Cluster Release Notes
19
26 Partitioning
55
6개 하위 문서
26.1 Overview of Partitioning in MySQL
19
26.2 Partitioning Types
5
7개 하위 문서
26.2.1 RANGE Partitioning
2
26.2.2 LIST Partitioning
2
26.2.3 COLUMNS Partitioning
2
26.2.4 HASH Partitioning
2
26.2.5 KEY Partitioning
2
26.2.6 Subpartitioning
2
26.2.7 How MySQL Partitioning Handles NULL
2
26.3 Partition Management
2
5개 하위 문서
26.3.1 Management of RANGE and LIST Partitions
3
26.3.2 Management of HASH and KEY Partitions
2
26.3.3 Exchanging Partitions and Subpartitions with Tables
2
26.3.4 Maintenance of Partitions
2
26.3.5 Obtaining Information About Partitions
2
26.4 Partition Pruning
1
26.5 Partition Selection
2
26.6 Restrictions and Limitations on Partitioning
2
3개 하위 문서
26.6.1 Partitioning Keys, Primary Keys, and Unique Keys
2
26.6.2 Partitioning Limitations Relating to Storage Engines
5
26.6.3 Partitioning Limitations Relating to Functions
21
27 Stored Objects
59
11개 하위 문서
27.1 Defining Stored Programs
22
27.2 Using Stored Routines
7
4개 하위 문서
27.2.1 Stored Routine Syntax
3
27.2.2 Stored Routines and MySQL Privileges
2
27.2.3 Stored Routine Metadata
2
27.2.4 Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
2
27.3 JavaScript Stored Programs
2
12개 하위 문서
27.3.1 JavaScript Stored Program Creation and Management
2
27.3.2 Obtaining Information About JavaScript Stored Programs
2
27.3.3 JavaScript Stored Program Language Support
2
27.3.4 JavaScript Stored Program Data Types and Argument Handling
2
27.3.5 JavaScript Stored Programs—Session Information and Options
2
27.3.6 JavaScript SQL API
2
27.3.7 Using the JavaScript SQL API
2
27.3.8 Using JavaScript Libraries
2
27.3.9 Using WebAssembly Libraries
2
27.3.10 JavaScript GenAI API
3
27.3.11 JavaScript Stored Program Limitations and Restrictions
2
27.3.12 JavaScript Stored Program Examples
3
27.4 Using Triggers
3
2개 하위 문서
27.4.1 Trigger Syntax and Examples
2
27.4.2 Trigger Metadata
2
27.5 Using the Event Scheduler
2
6개 하위 문서
27.5.1 Event Scheduler Overview
2
27.5.2 Event Scheduler Configuration
3
27.5.3 Event Syntax
3
27.5.4 Event Metadata
3
27.5.5 Event Scheduler Status
2
27.5.6 The Event Scheduler and MySQL Privileges
2
27.6 Using Views
3
5개 하위 문서
27.6.1 View Syntax
2
27.6.2 View Processing Algorithms
2
27.6.3 Updatable and Insertable Views
3
27.6.4 The View WITH CHECK OPTION Clause
2
27.6.5 View Metadata
2
27.7 JSON Duality Views
2
3개 하위 문서
27.7.1 Creating JSON Duality Views
3
27.7.2 DML Operations on JSON Duality Views (MySQL Enterprise Edition)
2
27.7.3 JSON Duality View Metadata
2
27.8 Stored Object Access Control
2
27.9 Stored Program Binary Logging
4
27.10 Restrictions on Stored Programs
7
27.11 Restrictions on Views
20
28 INFORMATION_SCHEMA Tables
57
8개 하위 문서
28.1 Introduction
18
28.2 INFORMATION_SCHEMA Table Reference
4
28.3 INFORMATION_SCHEMA General Tables
2
55개 하위 문서
28.3.1 INFORMATION_SCHEMA General Table Reference
2
28.3.2 The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table
2
28.3.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table
2
28.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table
2
28.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
2
28.3.6 The INFORMATION_SCHEMA COLLATIONS Table
4
28.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
2
28.3.8 The INFORMATION_SCHEMA COLUMNS Table
3
28.3.9 The INFORMATION_SCHEMA COLUMNS_EXTENSIONS Table
3
28.3.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
2
28.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
2
28.3.12 The INFORMATION_SCHEMA ENABLED_ROLES Table
2
28.3.13 The INFORMATION_SCHEMA ENGINES Table
2
28.3.14 The INFORMATION_SCHEMA EVENTS Table
2
28.3.15 The INFORMATION_SCHEMA FILES Table
2
28.3.16 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
3
28.3.17 The INFORMATION_SCHEMA KEYWORDS Table
2
28.3.18 The INFORMATION SCHEMA JSON_DUALITY_VIEWS Table
2
28.3.19 The INFORMATION SCHEMA JSON_DUALITY_VIEW_COLUMNS Table
2
28.3.20 The INFORMATION SCHEMA JSON_DUALITY_VIEW_LINKS Table
2
28.3.21 The INFORMATION SCHEMA JSON_DUALITY_VIEW_TABLES Table
3
28.3.22 The INFORMATION_SCHEMA LIBRARIES Table
3
28.3.23 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
3
28.3.24 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
2
28.3.25 The INFORMATION_SCHEMA PARAMETERS Table
2
28.3.26 The INFORMATION_SCHEMA PARTITIONS Table
2
28.3.27 The INFORMATION_SCHEMA PLUGINS Table
2
28.3.28 The INFORMATION_SCHEMA PROCESSLIST Table
2
28.3.29 The INFORMATION_SCHEMA PROFILING Table
1
28.3.30 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
2
28.3.31 The INFORMATION_SCHEMA RESOURCE_GROUPS Table
2
28.3.32 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
1
28.3.33 The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table
1
28.3.34 The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table
3
28.3.35 The INFORMATION_SCHEMA ROUTINE_LIBRARIES Table
2
28.3.36 The INFORMATION_SCHEMA ROUTINES Table
2
28.3.37 The INFORMATION_SCHEMA SCHEMATA Table
2
28.3.38 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table
3
28.3.39 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
2
28.3.40 The INFORMATION_SCHEMA STATISTICS Table
2
28.3.41 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
2
28.3.42 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table
3
28.3.43 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table
2
28.3.44 The INFORMATION_SCHEMA TABLES Table
2
28.3.45 The INFORMATION_SCHEMA TABLES_EXTENSIONS Table
2
28.3.46 The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table
2
28.3.47 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
3
28.3.48 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table
2
28.3.49 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
2
28.3.50 The INFORMATION_SCHEMA TRIGGERS Table
2
28.3.51 The INFORMATION_SCHEMA USER_ATTRIBUTES Table
2
28.3.52 The INFORMATION_SCHEMA USER_PRIVILEGES Table
2
28.3.53 The INFORMATION_SCHEMA VIEWS Table
3
28.3.54 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table
2
28.3.55 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table
2
28.4 INFORMATION_SCHEMA InnoDB Tables
3
29개 하위 문서
28.4.1 INFORMATION_SCHEMA InnoDB Table Reference
2
28.4.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
2
28.4.3 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
2
28.4.4 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
2
28.4.5 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table
2
28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
2
28.4.7 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
2
28.4.8 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
2
28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table
2
28.4.10 The INFORMATION_SCHEMA INNODB_DATAFILES Table
2
28.4.11 The INFORMATION_SCHEMA INNODB_FIELDS Table
2
28.4.12 The INFORMATION_SCHEMA INNODB_FOREIGN Table
2
28.4.13 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table
2
28.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
2
28.4.15 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
2
28.4.16 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
2
28.4.17 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
2
28.4.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
2
28.4.19 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
2
28.4.20 The INFORMATION_SCHEMA INNODB_INDEXES Table
1
28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table
2
28.4.22 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table
2
28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table
2
28.4.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table
2
28.4.25 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table
2
28.4.26 The INFORMATION_SCHEMA INNODB_TABLESTATS View
2
28.4.27 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table
2
28.4.28 The INFORMATION_SCHEMA INNODB_TRX Table
2
28.4.29 The INFORMATION_SCHEMA INNODB_VIRTUAL Table
2
28.5 INFORMATION_SCHEMA Thread Pool Tables
2
4개 하위 문서
28.5.1 INFORMATION_SCHEMA Thread Pool Table Reference
2
28.5.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table
2
28.5.3 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table
2
28.5.4 The INFORMATION_SCHEMA TP_THREAD_STATE Table
2
28.6 INFORMATION_SCHEMA Connection Control Tables
1
2개 하위 문서
28.6.1 INFORMATION_SCHEMA Connection Control Table Reference
2
28.6.2 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table
3
28.7 INFORMATION_SCHEMA MySQL Enterprise Firewall Plugin Tables
2
3개 하위 문서
28.7.1 INFORMATION_SCHEMA Firewall Plugin Table Reference
2
28.7.2 The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table
2
28.7.3 The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table
4
28.8 Extensions to SHOW Statements
19
29 MySQL Performance Schema
81
20개 하위 문서
29.1 Performance Schema Quick Start
19
29.2 Performance Schema Build Configuration
3
29.3 Performance Schema Startup Configuration
3
29.4 Performance Schema Runtime Configuration
3
10개 하위 문서
29.4.1 Performance Schema Event Timing
3
29.4.2 Performance Schema Event Filtering
3
29.4.3 Event Pre-Filtering
2
29.4.4 Pre-Filtering by Instrument
2
29.4.5 Pre-Filtering by Object
2
29.4.6 Pre-Filtering by Thread
2
29.4.7 Pre-Filtering by Consumer
2
29.4.8 Example Consumer Configurations
2
29.4.9 Naming Instruments or Consumers for Filtering Operations
2
29.4.10 Determining What Is Instrumented
2
29.5 Performance Schema Queries
2
29.6 Performance Schema Instrument Naming Conventions
2
29.7 Performance Schema Status Monitoring
2
29.8 Performance Schema Atom and Molecule Events
2
29.9 Performance Schema Tables for Current and Historical Events
3
29.10 Performance Schema Statement Digests and Sampling
2
29.11 Performance Schema General Table Characteristics
2
29.12 Performance Schema Table Descriptions
2
22개 하위 문서
29.12.1 Performance Schema Table Reference
2
29.12.2 Performance Schema Setup Tables
3
29.12.3 Performance Schema Instance Tables
2
29.12.4 Performance Schema Wait Event Tables
2
29.12.5 Performance Schema Stage Event Tables
2
29.12.6 Performance Schema Statement Event Tables
3
29.12.7 Performance Schema Transaction Tables
3
29.12.8 Performance Schema Connection Tables
2
29.12.9 Performance Schema Connection Attribute Tables
2
29.12.10 Performance Schema User-Defined Variable Tables
2
29.12.11 Performance Schema Replication Tables
2
29.12.12 Performance Schema NDB Cluster Tables
2
29.12.13 Performance Schema Lock Tables
2
29.12.14 Performance Schema System Variable Tables
3
29.12.15 Performance Schema Status Variable Tables
3
29.12.16 Performance Schema Thread Pool Tables
2
29.12.17 Performance Schema Firewall Tables
2
29.12.18 Performance Schema Keyring Tables
2
29.12.19 Performance Schema Clone Tables
2
29.12.20 Performance Schema Summary Tables
2
29.12.21 Performance Schema Telemetry Tables
2
29.12.22 Performance Schema Miscellaneous Tables
2
29.13 Performance Schema Option and Variable Reference
2
29.14 Performance Schema Command Options
2
29.15 Performance Schema System Variables
3
29.16 Performance Schema Status Variables
2
29.17 The Performance Schema Memory-Allocation Model
3
29.18 Performance Schema and Plugins
3
29.19 Using the Performance Schema to Diagnose Problems
2
2개 하위 문서
29.19.1 Query Profiling Using Performance Schema
2
29.19.2 Obtaining Parent Event Information
4
29.20 Restrictions on Performance Schema
24
30 MySQL sys Schema
52
4개 하위 문서
30.1 Prerequisites for Using the sys Schema
25
30.2 Using the sys Schema
5
30.3 sys Schema Progress Reporting
2
30.4 sys Schema Object Reference
2
5개 하위 문서
30.4.1 sys Schema Object Index
2
30.4.2 sys Schema Tables and Triggers
2
30.4.3 sys Schema Views
2
30.4.4 sys Schema Stored Procedures
4
30.4.5 sys Schema Stored Functions
16
31 Connectors and APIs
80
13개 하위 문서
31.1 MySQL Connector/C++
16
31.2 MySQL Connector/J
4
31.3 MySQL Connector/NET
3
31.4 MySQL Connector/ODBC
2
31.5 MySQL Connector/Python
2
31.6 MySQL Connector/Node.js
2
31.7 MySQL C API
2
31.8 MySQL PHP API
2
31.9 MySQL Perl API
1
31.10 MySQL Python API
2
31.11 MySQL Ruby APIs
2
2개 하위 문서
31.11.1 The MySQL/Ruby API
1
31.11.2 The Ruby/MySQL API
5
31.12 MySQL Tcl API
6
31.13 MySQL Eiffel Wrapper
22
32 MySQL Enterprise Edition
78
9개 하위 문서
32.1 MySQL Enterprise Backup Overview
20
32.2 MySQL Enterprise Security Overview
2
32.3 MySQL Enterprise Encryption Overview
2
32.4 MySQL Enterprise Audit Overview
2
32.5 MySQL Enterprise Firewall Overview
2
32.6 MySQL Enterprise Thread Pool Overview
3
32.7 MySQL Enterprise Data Masking and De-Identification Overview
2
32.8 MySQL Enterprise Monitor Overview
2
32.9 MySQL Telemetry
21
33 MySQL Workbench
58
34 MySQL on OCI Marketplace
62
5개 하위 문서
34.1 Prerequisites to Deploying MySQL EE on Oracle Cloud Infrastructure
19
34.2 Deploying MySQL EE on Oracle Cloud Infrastructure
2
34.3 Configuring Network Access
4
34.4 Connecting
5
34.5 Maintenance
19
35 Telemetry
51
5개 하위 문서
35.1 Installing OpenTelemetry Support
18
35.2 Telemetry Variables
5
35.3 OpenTelemetry Trace
2
2개 하위 문서
35.3.1 Configuring Trace Telemetry
2
35.3.2 Trace Format
2
35.4 OpenTelemetry Metrics
2
3개 하위 문서
35.4.1 Configuring Metrics Telemetry
3
35.4.2 Server Meters
2
35.4.3 Server Metrics
2
35.5 OpenTelemetry Logging
8
1개 하위 문서
35.5.1 Configuring Log Telemetry
18
A MySQL 9.5 Frequently Asked Questions
52
18개 하위 문서
A.1 MySQL 9.5 FAQ: General
19
A.2 MySQL 9.5 FAQ: Storage Engines
7
A.3 MySQL 9.5 FAQ: Server SQL Mode
3
A.4 MySQL 9.5 FAQ: Stored Procedures and Functions
2
A.5 MySQL 9.5 FAQ: Triggers
2
A.6 MySQL 9.5 FAQ: Views
2
A.7 MySQL 9.5 FAQ: INFORMATION_SCHEMA
2
A.8 MySQL 9.5 FAQ: Migration
2
A.9 MySQL 9.5 FAQ: Security
2
A.10 MySQL 9.5 FAQ: NDB Cluster
2
A.11 MySQL 9.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
2
A.12 MySQL 9.5 FAQ: Connectors & APIs
2
A.13 MySQL 9.5 FAQ: C API, libmysql
2
A.14 MySQL 9.5 FAQ: Replication
2
A.15 MySQL 9.5 FAQ: MySQL Enterprise Thread Pool
2
A.16 MySQL 9.5 FAQ: InnoDB Change Buffer
3
A.17 MySQL 9.5 FAQ: InnoDB Data-at-Rest Encryption
3
A.18 MySQL 9.5 FAQ: Virtualization Support
10
B Error Messages and Common Problems
73
3개 하위 문서
B.1 Error Message Sources and Elements
12
B.2 Error Information Interfaces
3
B.3 Problems and Common Errors
3
7개 하위 문서
B.3.1 How to Determine What Is Causing a Problem
2
B.3.2 Common Errors When Using MySQL Programs
2
B.3.3 Administration-Related Issues
2
B.3.4 Query-Related Issues
2
B.3.5 Optimizer-Related Issues
2
B.3.6 Table Definition-Related Issues
2
B.3.7 Known Issues in MySQL
13
C Indexes
72
14개 하위 문서
General Index
13
C Function Index
3
Command Index
3
Function Index
2
INFORMATION_SCHEMA Index
3
Join Types Index
2
Operator Index
2
Option Index
2
Privileges Index
3
SQL Modes Index
4
Statement/Syntax Index
3
Status Variable Index
3
System Variable Index
7
Transaction Isolation Level Index
14
MySQL Glossary
67
